Queries with dates..

[KM]

Can anyone help me with a date based query?
I have two tables:
PriceChange| PriceChangeID; Date; Amount; ProductID
Product| ProductID; ProductName

I want to select the most recent date from Pricechange that matches a
specific product ID (ie the current price)

I also want to provide a date and have a query that finds the record with
the closest date before the date supplied.

I recon a module that has an optional date field should do the trick, but I
dont know
how to write the actual sql

Thanks in advance for any help,
KM

 

[[MVP] S.Clark]

Reckon ya oughtta read through this here page, then pick the method that
suits ya best.
http://www.mvps.org/access/queries/qry0020.htm

I prefer doing a two query method. One to get the max, and the second to
link back to the live data to get the rest of the data.
--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
[email protected]
www.fmsinc.com/consulting