db query with dynamic criteria
I need to be able to run a query from a cell to pull in 1 bit of data for a
particular date. I would like to be able to just call a funciton if possible
and pass it the date:
=GetData(A12)
In return I would get data from the Access database. I can't seem to find
any info on any of it except to populate a spreadsheet with all of the data
returned, but I only need one record and really only one field from that
record.
|