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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: gfoster9055
- Order by date
-
Null help
CalcWorkdays is a call to a module that only counts monday through Friday. The forumla counts how many days between start and finish minus weekends. I have a query do the same thing but now I need to find the average of all "qsf" days. I was trying to have a query write to the tables, but I...- gfoster9055
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Null help
This code is what I am using in the control source in the form DaystoCloseNonQSF: IIf([QSFNonQSF]<>"qsf",CalcWorkdays([DateReceived],[DateCompleted]),"") I am also using the same in the query. Thanks Greg- gfoster9055
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Null help
I new to access and need some help, here is my problem. I have a query that gives data to a table, the only problem is that there is blank fields in the query and from what I read that is not a good thing when doing calculations. Here is the formula that I am using in the query...- gfoster9055
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
