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!

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

Count number of days 1

Status
Not open for further replies.
desmur

desmur

MIS
Dec 16, 2002
26
0
0
US
I need a query that will count the number of days when giving a beginning date and an ending date. What can I do.
 
Sort by date Sort by votes
Use the DateDiff function:

DateDiff("d", YourBeginDate, YourEndDate )

See ACCESS Help for a complete explaination. Bob Scriver
 
Upvote 0 Downvote
in many/most instances, it is the number of WORKING days which are desired. see faq181-261 for that soloution


MichaelRed
m.red@att.net

Searching for employment in all the wrong places
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
301
serino
serino
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
129
JimStrand
JimStrand
mhshane
  • Locked
  • Question
Query to find keywords in description field and give count
Replies
4
Views
69
Andrzejek
Andrzejek
supportsvc
  • Locked
  • Question
How to limit the number of records based on the quantity in a field? 1
Replies
8
Views
118
supportsvc
supportsvc
supportsvc
  • Locked
  • Question
Distinct Count for Unique Number of Employees in Each Month
Replies
0
Views
37
supportsvc
supportsvc

Part and Inventory Search

Sponsor

Back
Top