how to calculate mean production for a period

John Smith

Guest

Posts: n/a

12th Jul 2004

i have a table like this:

type date kg
0 18.03 400
1 18.03 200
0 20.03 500
1 20.03 100

this r all the quantities at the store

and the formula is like:
mean production for 18.03 - 20.03 = [(500-100) - (400-200)] / (20-18)

that is if type is '1' u subscribe

any ideas how it can be done with access queries?

TIA

« Access snapshot viewer | horizontal to vertical »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate Payback Period	G	Microsoft Excel Worksheet Functions	1	12th Sep 2008 06:21 AM
How to calculate period	manan	Microsoft Excel Discussion	3	12th May 2006 03:00 PM
Calculate the Pay Period from the date		Microsoft Excel Worksheet Functions	0	1st Oct 2004 07:56 PM
How to calculate a period of time	AmandaP	Microsoft Access Queries	2	27th May 2004 12:39 PM
Calculate rolling 12 mo period	Leah	Microsoft Access VBA Modules	2	18th Jul 2003 03:53 PM