Query Returning All Dates Between - please help!

[Ivkosky]

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

 

[Uncle Gizmo]

This problem has been addressed many times before, the following link should produce a list of suitable posts, have a look through them and if you have any more questions then please post back.

 

[Ivkosky]

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!