Hi,


I have one major problem and need to solve it, please help. I need to design query, which would return all dates between certain two dates in format year/month. I just need this let's say 'one field' query - the query has to generate the dates, this is the problem. I have to generate all the months in this format between let's say 'starting date' and 'finishing date' in order to use them later for x-axis in charts...
Any help highely appreciated since I am getting desperate... Thank you very much!


Ivan

This problem has been addressed many times before, the following link should produce a list of suitable posts, (http://www.google.co.uk/search?hl=en&as_q=between+start+end+PARAMETERS+query&as_epq=&as_oq=&as_eq=&num=10&lr=&as_filetype=&ft=i&as_sitesearch=http://www.access-programmers.co.uk/forums/&as_qdr=all&as_rights=&as_occt=any&cr=&as_nlo=&as_nhi=&safe=off) have a look through them and if you have any more questions then please post back.

I am sorry, I know, I am just newie, but I wasn't able to find the answer for my question. I know how to return all the existing dates in the records of a particular table between two stated dates. My problem is, that I have to create those dates as a new records in that query (or joined table). Thank you once more for any help!