how to calculate the records that is in a table

[Hokis]

Hi, the question might sound very simple but i'm very confused.
I have a table that would have mulitple records, like 1000 or more or less,
i have a report i need in that report to show me, how many records there is, in that specific table, how do i do that????
thank you
Alice

 

[TheAceMan1]

How are ya Hokis . . .

Have a lookat the agregate function [blue]DCount[/blue] . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[JerryKlmns]

Or

SELECT Count(*) FROM yourTable

as the report' s record source