between

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

Guest

hi,

lets say we have a table with multiple accounts. an account can have
multiple [activity code dates] it can also have multiple [payment posting
dates]. lets say our first [activity code date] is 1/5/2007 and our first
[payment posting date] is 1/30/2007. and our second [activity code date] is
2/30/2007 and our second [payment posting date] is 4/30/2007. we want to
have a showcase query determine whether or not the first [payment posting
date] is between the first and second [activity code date] and whether or not
the second [payment posting date] is between the second [activity code date]
and the third [activity code date] and whether or not the third [payment
posting date] is between the third [activity code date] and the fourth
[activity code date]. and so forth. what is the best way to approach this in
a query?

Thanks in advance,
geebee
 
You've described, in general, what data elements you have.

But queries in Access depend on the structure of your data.

Specific suggestions about how to query will depend on specific descriptions
of your data's structure.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top