query Sum Calculation

[prostheticHead]

i need to work out the total of a colume in my query but when i use sum its just telling me the value in the last record in that colume

if ya need anymore info just tell me

thanks heaps!

 

[maxmangion]

it would be better if your post the formula you are trying to work it out with ?

 

[prostheticHead]

no formula just using the total part and select sum

i gess if it had a formula it would look like Sum([theRetail]) but all it dose is just give me the value in the last record

count also says theres only 1. but theres clearly 2 records in the query

 

[maxmangion]

is it possible that you will upload a sample of your db ?

 

[prostheticHead]

i just worked it out! im such a dork! it was that i was showing a colume in the quriy i shouldnt have been, took it out made the report use a sub form with another qurie and it works Sweet now! Thanks for ya help though!!

 

[maxmangion]

i'm glad to hear that you sorted out your problem