ms access. queries

  • Thread starter Thread starter alex
  • Start date Start date
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
 
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.
 
Back
Top