By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,188 Members | 844 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,188 IT Pros & Developers. It's quick & easy.

Complete the Date in Query

P: 30
Good Day!

I was trying to query this data.
here is the situation: I have a data of the Following:

DATE

January 1
January 2
January 4
January 6

if you notice, there's a missing date.
What i want to do is to add or put the missing date automatically to complete the date using the QUERY only, i mean without encoding the missing date from the table.

so the query must be like this:

DATE

January 1
January 2
January 3
January 4
Jnauary 5
January 6

How to do this??? Pls. help me. Is it possible to do this in query???

Thank YOu so much!
Sep 11 '08 #1
Share this Question
Share on Google+
3 Replies


FishVal
Expert 2.5K+
P: 2,653
Hi, there.

Take a look at Calendar - Schedule Access 2007.
In the attachment you will find database sample with query generating sequential dates. You just need to filter its output to be between earliest and latest date from your table.

Regards,
Fish
Sep 11 '08 #2

P: 30
Hi, there.

Take a look at Calendar - Schedule Access 2007.
In the attachment you will find database sample with query generating sequential dates. You just need to filter its output to be between earliest and latest date from your table.

Regards,
Fish
Hi!
Thank You!!! :)
Sep 11 '08 #3

FishVal
Expert 2.5K+
P: 2,653
You are welcome .
Sep 11 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.