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 MikeeOK 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: chelseacraft
- Order by date
-
To
Well... after submitting the post the columns got skewed. The numbers should be under Total Units Produced and the ? marks should be under the Monthly avg column.- chelseacraft
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
To
OK... let's see if this helps. It's really very simple. Excel can do this in a flash, but doesn't automatically update itself based on input in the form we have in the database. So we must do this in Access to save days of work each month. Below is a sample query from a database I called...- chelseacraft
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
To
Thank you for your tip. What I am looking for is a way for these functions to recognize a date range from the test date field and total or average only the days elapsed for that month. Grouping the records does not account for how to return calculations for a specific individual month. I...- chelseacraft
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
To
I have a query that shows the number of days elapsed between a start date and stop date using the DateDiff function. What I need now is to find the total number of days per each month (NOT a running total). I also need to return the average elapsed days for each month. This needs to be done in...- chelseacraft
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
