N
Nick T
Hi, iv had some good feedback on this before so thanks to those who have
helped, but im still stumped! Ill try to be a little more accurate.
This data base is used in a production environment where more than one
record will be added for a set product each day. eg product "A" will be
added as a record containing a 'Total' of 20 five times each day. Therfore
this being my reason for creating my query in the following way:
But first, when a record is added, it adds the following info to my
'production table'.
Product, Production Date, Production Time, size and total quantity. So for
each day, i will have many records for one particular product with the total
quantities produced.
I have my access query set up so that it looks at a particular day, lists
each product produced on that day, and automatically adds up the 'total
quanity' produced.
So for eg. 'product A' could be produced 10 times in one day, each time
making 5 products. My 'production table would therefore have 10 records. I
then want to make my query tell me that on 01.02.08 a total of 50 'product
A's were produced. This is working, however the query is changing the date
format column from 'short date' (dd.mm.yy) as per the format in the table to
'long date' (01 Janurary 2008) in the query - this then messes up my sorting
in assending or decending order.
It is a summary query and my summary value = sum
I have grouped the info by day using the query wizard.
I hope this makes sence and hope that someone can help.
Many thanks
Nick
helped, but im still stumped! Ill try to be a little more accurate.
This data base is used in a production environment where more than one
record will be added for a set product each day. eg product "A" will be
added as a record containing a 'Total' of 20 five times each day. Therfore
this being my reason for creating my query in the following way:
But first, when a record is added, it adds the following info to my
'production table'.
Product, Production Date, Production Time, size and total quantity. So for
each day, i will have many records for one particular product with the total
quantities produced.
I have my access query set up so that it looks at a particular day, lists
each product produced on that day, and automatically adds up the 'total
quanity' produced.
So for eg. 'product A' could be produced 10 times in one day, each time
making 5 products. My 'production table would therefore have 10 records. I
then want to make my query tell me that on 01.02.08 a total of 50 'product
A's were produced. This is working, however the query is changing the date
format column from 'short date' (dd.mm.yy) as per the format in the table to
'long date' (01 Janurary 2008) in the query - this then messes up my sorting
in assending or decending order.
It is a summary query and my summary value = sum
I have grouped the info by day using the query wizard.
I hope this makes sence and hope that someone can help.
Many thanks
Nick