Date Query

[Vinnie]

Hi,

I've got two tables:

(1) Rate table - details the rate charged from a certain date (two columns:
date and rate)
(2) Transaction table - details transactions executed as per a certain date
(three columns: date, transaction type, volume)

I want to create a query that contains all the fields in the transaction
table and the applicable matching rate from the rate table.

Any ideas?

Thanks,

 

[Ofer Cohen]

Check this link about the link options in a query between tables

http://www.databasedev.co.uk/query_joins.html