Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Calculation 1

Status
Not open for further replies.

RabSwinney

Technical User
Aug 21, 2002
25
FI
I have a query working with the folowing,
Start date ??/??/??
Finish date ??/??/??
Then a calculation returning number of days, how can I get it to return all the dates for the number of days?
Example it returns 5 days I want to return 5 separate dates
 
Try setting up your query to use Between [Start Date] And [End Date]. You can then use a Dcount function to find the number of records returned by the query.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top