Date join

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to join four queries into one totaling query. Query A lists all
of the accounts - Queries B,C and D will be joined to A by the account
number. B, C, and D need to be joined to eachother by a date field where the
month and day must match. Without some sort of date join, the data is being
repeated or is missing......Any assistance is GREATLY appreciated!!
 
You can create a computed field in each of your queries that returns simply
the month and day of the date field (try Format([MyDateField], "yyyymm"))
and join on that.
 
Back
Top