Access 2000 question about the Count function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GirlyMay The Cat - 17 May 2008 14:47 GMT

I use Access 2000 at work and bought the software to practice at home. The
purchased software lets me use the Count function to know the amount of
records in a table. I use =Count([table name]) and the result is there. When
I use the same method with the same (supposedly) software at work, it won't
work. I get the "Error" message where an amount should be. What is going on?
Using the same area in the report where I am putting the tag in my home
practice report.

Reply to this Message

Rastro - 17 May 2008 18:37 GMT

I think it is because the "count" function doesn't counts tables. May be you
think that is a tableName but it is a FieldName. Check if there's a field in
your home table (the place where the function works) that is named like the
table. The function "count" counts, and sum if the value is numeric, the
values in a specific field of a given recordset (a form recordset, report,
etc).
At work change the "table name" for the field name you want count.

Rastro.

"GirlyMay The Cat" <charlottboren4335@comcast.net> escribió en el mensaje de
noticias:2padnc_tyZGvf7PVnZ2dnUVZ_ofinZ2d@comcast.com...

> I use Access 2000 at work and bought the software to practice at home. The
> purchased software lets me use the Count function to know the amount of
[quoted text clipped - 3 lines]
> is going on? Using the same area in the report where I am putting the tag
> in my home practice report.

Reply to this Message