month data or month range

[samer]

I need a data in a date range, the date format are mm/yyyy,
I have tried the: between [] and [], but it did not work!!!
Query, which I am tiring to do depending on another query which
Calculated the same field – which I want to get the date range from –
So it will be like this:
The first field is: duration date: [inv date]+([duration time]*31)
So when I have inv date: 04/2004 and the duration time is 1 month
Automatically I will get from the query:
05/2004 ……
now this query did work .

my issue is : depending on the upper query I want the range query which
is between [05/2004] and [06/2004] duration date or the query which gives me only a duration month I need like 4 or 5 , this will be better for sure .

 

[Jon K]

I have attached a sample database, which contains three queries:-

The first query returns all due dates from table tblInvoice.
The second query returns a range of due dates from the first query.
The third query returns a single due date month from the first query.


Since mm/yyyy cannot be sorted correctly whereas yyyy/mm can, to use Between [] and [] correctly, the start range and end range must be entered in yyyy/mm, not mm/yyyy, when the second query is run.


Note: Although the dates are displayed in mm/yyyy in the table and queries, Access actually defaults to the first day of the months.

 

[samer]

JON K,
Sorry for not responding directly to your solution, in fact it was helpful,
Thanks for you ,I solve the problem I had. Thanks a lot ….