By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,650 Members | 812 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,650 IT Pros & Developers. It's quick & easy.

Problem counting dates

P: 66
Hi,

Im creating a database that is used to report scrap problems on a production line, Scrap details are entered 3 times daily.

within the database there is a reporting section where the user can export data to an excel spreadsheet where a graph is created. the graph is supposed to display daily scrap.

im having a problem acumalting the 3 daily entries to one entry.

for example: i have 3 entries for the 20/03/2007 i then need to calculate 3 feilds within this record. as there are 3 records with the same date i need to calculate the three fields in each record so i get a daily percentage and not each entry?

sorry if its a bit confusing.... will try to explain more if there is any misunderstanding
Mar 21 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Something like ...
Expand|Select|Wrap|Line Numbers
  1. SELECT datefield, Sum([ScrapAmount]) As TotalScrap
  2. FROM TableName
  3. GROUP BY datefield
  4.  
Mary
Mar 21 '07 #2

P: 66
Many thanks..... this works great! much easier than i thought it would be!
Mar 22 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Many thanks..... this works great! much easier than i thought it would be!
No problem.
Mar 22 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.