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

Adding working days in SQL

Status
Not open for further replies.
Amanda2

Amanda2

Technical User
Aug 3, 2004
4
US
I do not know VBA and would like to know if there is a way to get records with a date populated field that is 11 working days ago in SQL.

Any help is appreciated.

Amanda
 
Sort by date Sort by votes
no you have to use VBA to calculate the working days. Check the FAQ of the Access areas for working code examples that you can paste into a module and then call from a query.

Leslie
 
Upvote 0 Downvote
Thanks Leslie, that's what I was afraid of. Guess I'll have to face my fears of the module!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
C
  • Locked
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
410
OzFoxy
OzFoxy
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
671
mikrom
mikrom
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
996
Swi
Swi
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
5K
combo
combo

Part and Inventory Search

Sponsor

Back
Top