Need help with Report!

[erik71]

I'm making a report in Access. In the footer I'm tring to get a total # of rows in a field and I can't get the syntax right.

SELECTCount [RSCLIENT].[R/D] FROM [RSCLIENT] WHERE [R/D] = A

I've tried it about a hundred different ways. I thought I would stumble across the right way but I'm not having any luck. I know this is easier than I'm making it and I would appreciate any help. Thanks.

 

[HenryAnthony]

Hi,

When you say rows in a field, do you mean records in a report. If so search for help on "counting records".

Best regards,

Henr¥

 

[rgbanse]

erik71
Give this a try.
Within a Text Box, set your control source to
=Dcount("*","TableName","[FieldName] = 'Criteria'&quot
RGB