View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stanley
 
Posts: n/a
Default 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.