UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Calculating Averages, Access 2013    
 
   
everettmiller
post Jun 25 2019, 09:36 AM
Post#1



Posts: 190
Joined: 9-May 11
From: Columbus, GA USA


Hey forum! Having a brain cramp today and could use some simple(?) help...

My project needs to determine the average number of times a piece of equipment has been issued over a selected period of time. The user would select the type of equipment and the date range via a form. The query should return the average number of pieces issued for each day in the date range, excluding weekends (Sat and Sun).

Actually, the task is a little more complicated. There are a total of eight(8) statuses that need to be averaged over the same period. Call them S1 thru S8 where S1 = Issued. An archive table contains all of the data the query needs to execute: Status codes for the various statuses, Action dates to satisfy the date range requirements, and an InvArchive_ID to do the counting/averaging, and an EQType_ID to identify the type of equipment.

For some reason I just can't get my head around how to design the query.

Any help would be greatly appreciated!

Everett
Go to the top of the page
 
theDBguy
post Jun 25 2019, 09:57 AM
Post#2


Access Wiki and Forums Moderator
Posts: 75,750
Joined: 19-June 07
From: SunnySandyEggo


Hi. It might be easier to figure out something if you could post some sample data to play with.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
everettmiller
post Jun 25 2019, 10:09 AM
Post#3



Posts: 190
Joined: 9-May 11
From: Columbus, GA USA


Hey DB.... I'll have some sample data posted shortly.
Go to the top of the page
 
everettmiller
post Jun 26 2019, 06:54 AM
Post#4



Posts: 190
Joined: 9-May 11
From: Columbus, GA USA


Finally, here is some sample data...
Attached File(s)
Attached File  SampleData.zip ( 244.96K )Number of downloads: 3
 
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    22nd July 2019 - 01:16 PM