If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ms access. queries
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 |
#2
|
|||
|
|||
ms access. queries
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. -- Regards Jeff Boyce Office/Access MVP "alex" wrote in message news:CAC4f.10473$f02.3363@trndny02... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
The "Right" web hosting for data access pages?? | Ron Ehrlich | General Discussion | 9 | May 6th, 2005 05:49 AM |
Why is a French Spellchecker a "required" update for English speak | French Spellcheck Required? | General Discussion | 23 | April 26th, 2005 01:17 AM |
What is the difference between 2002 and 2003? | Red Sonya | General Discussion | 2 | March 1st, 2005 05:10 AM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |
Merging with Access queries - Multiple | CPutnam | Mailmerge | 5 | August 21st, 2004 01:11 PM |