sql - Access 2003: How to combine two count queries -

I am writing my first short access 2003 application. I have two questions which I do not understand how to combine. What I see is to get the number of all the routes in a date range, calculating the total rows of each path in the date range and counting how long it was done. I have these two questions that I take part of the way there, just can not figure out how to combine them into an access query.

  parameter start-date date time, end date time; Selection [root #], calculation (*) from total [performance audit on time] WHERE (Group Time [Route #]; Parameter Start Date (((Time Performance Audit). Date [Beach] and [End Date]) , Timeout expiration date, select [Route #], Late [performance audit on time] as calculation (*) where [[date time on performance audit]. [StartDate] and [date] between date and date (minutes ( [Real time] - [time bound time]) & gt; = 6) by group [root #];  

I'm a SQL man I'm not much of that, which is a LINQ boy, and after using VS 2010, writing a quick and dirty app in Access 2003 is a bit painful. Anyway, hope you can help thank you.

In your second example query, are you certain that you want the minute () function?

< Pre> debug.print date ("n", # 2010/09 /

If you want a duration between 2 date / time values, then DateDiff () funk Use the system. 27 01: 00 #, # 2010/09/27 02: 10 #) 70 debug print min (# 2010-09-27 02: 10 # - # 2010/09/27 01: 00 #) 10

If DateDiff () is the approach that you want, then try it:

  parameter start date, timeout date time; [Start] [Rath #], T-Seat, L. Late FOR (Select [Route #], Calculation (*) Performance Audit from AS Total [WHERE ([[Date]] between [Start] and [And Date]) Group [Root #] In the form of T byte JOIN (select [root #], calculation (*) late [performance audit on time] WHERE ((([[DATE]] between [StartDate] and [end] and dataidiff ("n" [Route #] = [root #];  

Note: I VBA giving date field name with verb bracket A () was attached to a different function.