How to get data for a particular date till Today

[rakeshprasad]

I have a database from 1st Apr'12till date but I want the summary fron 1st Nov'12 till date what should i do & Suppose today is 15th Feb'13 I want to know the sales amount of each month till 15th of that month how can i do it in MS Access Please help....

Regards

Rakesh Prasad

[Rabbit]

Use the WHERE clause to filter for date range you want.

Any more specificity would require table definitions and your current SQL along with a description of what's wrong with the code.

[arumurali]

Just try months_between to get the exact details.