Calculations on data in one field

[mapondera]

Say each datum has a date e.g. if I have the fields 'Date' and 'Total Cakes Sold to Date' and my data is: Dec/11/01, 25 cakes sold to date; Dec/12/01, 32 cakes sold to date; Dec/13/01, 47 cakes sold to date; etc. (Where cakes sold to date is a cumulative tally i.e. whatever yesterdays number of cakes sold was plus today's number.)

How do I perform calculations on data in the 'Cakes Sold' field e.g. Cakes sold to date for Dec/13/01 minus Cakes sold to date for Dec/12/01 = 47-32 = 15

 

[TravelerOn]

You mean you want to know the total cakes sold between a given range of dates? Try a crosstab query...it should allow you to manipulate the totals.

Kate

 

[David R]

Naming a field 'Date' can cause problems for access. So do spaces in field names, but if you're careful with [] you can get around that on usually. Try renaming the other.

Look at this topic for some ideas on avoiding saving extra data in your table: http://www.access-programmers.co.uk/ubb/Forum3/HTML/002673.html

HTH,
David R