ms access. queries

A

alex

i put together a list of monthly deposit's and
it's for the 2cnd and the 15th of each month
and the querie is. i want the total of bi-monthly
but the querie is of no help i tried the "report"
put it shows the total month only the question is
what shall i do to be able to get a bi-monthly report
sincerly alex
 
J

Jeff Boyce

Alex

I'm not sure I understand enough about your data structure to offer specific
suggestions on how to query it.

It sounds like you are trying to get totals for a period between the 1st of
the month and the 15th, and between the 16th and the end.

You could use the "Between xxxx And yyyy" expression as a selection
criterion in your query.

You could use the DateSerial() function to derive the "current" month's date
ranges.
 
Top