Incrementing Days between two dates..

From: "John Ortt" <johnortt@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 22 Nov 2005 11:44:30 -0000

Hi everyone,

I have two records in a table (for example 25/01/05 and 30/01/05)

Is there a way I can write a query which will return those two days and
create further records for the missing days?

Thanks in advance,

John

.

Follow-Ups:
- Re: Incrementing Days between two dates..
  - From: Jeff Boyce

Prev by Date: Re: .wdb to access
Next by Date: Re: Passing parameters to an Append query using Access VB
Previous by thread: Re: Continue: Effective sequence
Next by thread: Re: Incrementing Days between two dates..
Index(es):
- Date
- Thread

Relevant Pages

Re: Comparing two tables
... Agree with John, without more detail of your table structure, it is ... them using an SQL query so i can see what data is missing? ... What you can do is create a Query joining the two tables on some ... and put a criterion on each field in the ...
(microsoft.public.access.queries)
Re: XP Pro Upgrade or full version?
... Bruce Chambers wrote: ... > John wrote: ... >> something missing. ... Prev by Date: ...
(microsoft.public.windowsxp.basics)
Re: Query rolling dates?
... >I don't know if I'm drawing a blank and missing something easy and obvious, ... >thinking there has to be a way I could do it through a query. ... Prev by Date: ...
(microsoft.public.access.queries)
Re: Weight returning unexpected results
... John, thanks for your reply. ... although now I just ran the same query and I'm getting the results I ... I'll see if I can find anything in the BOL, ... Prev by Date: ...
(microsoft.public.sqlserver.fulltext)
performance question/multiple keys
... The table I'm using has full-text columns and also a date column thats ... If I do a query on a date range and the full-text column does SQL ... John ... Prev by Date: ...
(microsoft.public.sqlserver.fulltext)