Count Function

[ddrew]

I wonder if someone could help me with the count function,being as I've never used it. I have two forms, one with a number box called:

Form1![CR2]

The other is called:

Form2![[TotalCR2]

I want to add all the records from Form1![CR2] and put them into
Form2![TotalCR2]

I know its going to be simple and I'm pretty sure I should be using DCount or DSum but I am unable to access the help files on my PC at work for some reason. Thanks!

 

[DavePem]

I would suggest you use a query and cout the records....

HTH

Dave P

 

[ddrew]

Cant do that as CR2 is a number and could be ny number as entered by the user, TotalCR2 are all the CR2 numbers added together from all records

 

[goldmedallist]

I am hazarding a guess but since I presume all your CR2 are from the same table?

If so then a query should work as below

SELECT SUM(CR2)
FROM "name of your table"

Hope this helps somewhat

 

[ddrew]

OK I tried this but to no avail! I'm sure this is what I should be doing, but! Should it be table or form?

SELECT SUM(CR2) FROM "tblSimulatorTotals"

 

[goldmedallist]

Hey ddrew,

What is the error message or what is the result giving you? It should be FROM table since after all your data in the forms are all populated from the same table