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 Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get Counts between two dates

Status
Not open for further replies.

chicdog

Programmer
Feb 28, 2002
84
US
I have a report that uses a cross tab that gives me the counts for each arrival date. What I need is if Joe Smith arrives on June 22nd and departs the 25th I need to show it in the count for the 23rd & 24th. Is it possible to have a range of dates and show the proper counts for each day. An example would be great. Thanks

Chikey
bchickey@paa.org
 
From what i understand is u need to show the count of days i.e 25 - 22 which is 3 days.May be u can achieve this by using a formula field and separate the days which will give u the count.

Hope this helps!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top