Numeric or Date Series

[OR1988]

Hi All,

I want a query that generates a series of numbers or dates
without selecting any record



For example: 1, 2, 3, 4 ... 30
OR
1/1/2011, 2/1/2011, 3/1/2011 ... 31/1/2011

Regards.

[Robeen]

Where do you want these number or date series to end up?
In a Table?

What you want is looking more like something I'd do in code.
Is that an option for you?

[OR1988]

No, I would like them to appear in the query without existing in a table.

Yes it can be done by a code, thanks.

[Robeen]

I'm sorry - I have never written a query that does not retrieve data a database - or a Text file - or an Excel spreadsheet.

My understanding of a query is that you are 'querying' [asking a question of] the database to show data that is contained in the database.

What you are wanting of the query is to CREATE the data out of thin air.
I don't think that that is what queries are designed to do.

I think the data that you need has to be created and saved either in a Table, a Text file or spreadsheet . . . and THEN you can run your query to show the data.
After you're done with the data, you can delete it.

I'm thinking of a Macro that runs Code in a Module to create the data and then runs the query to display the data.

If this answer is not what you are looking for, perhaps you can post again and include the url to THIS thread in your new post.

If it IS possible to do what you're wanting, I would like to know how.

All the best!!

[RuralGuy]

To what use do you plan for the sequence?