Query form getting 1 of 0 records...

[Xterra14s]

So a form that I have is pulling 1 of 0 Records when using this code: ="Record " & [CurrentRecord] & " " & "of " & Count(*)


It's counting a blank record as 1 when there are no records. Any idea how I can get it to say 0 of 0?

Thank you!

[ranman256]

iCnt = Dcount("*","table/query")

[Xterra14s]

iCnt = Dcount("*","table/query")

That gave me an error

[Xterra14s]

The code I have does work except for when the table is blank. If I search a number and it shows 2 or 3 for example its working fine and same with 1 of 3. The only time it doesn't work is when there is no records to show. It states 1 of 0 because it's counting the blank form as 1 record.

[Xterra14s]

Hows this look?

=IIf([CurrentRecord]>Count(*), "0" "of " & Count(*) ,(="Record " & [CurrentRecord] & " " & "of " & Count(*)))