Count statement 1

[Guest_imported]

For more than 0 records my output is:
Project Resource/Technology has & Count(*) &

For 0 records:
Project Resource/Technology has no records at this time.

I know it has something to do with how I am using this Count(*) part at the end.
Any suggestions?

[tt]
="Project has " IIf(Count(*)=0,"no records at this time. "," Count(*) &quot & ""[/tt]

 

[rgbanse]

try
="Project has " & Dcount("*","YourTablesName&quot & " records at this time."
RGB

 

[Guest_imported]

still no luck. Any other suggestions?

 

[rgbanse]

Carl
Assuming this is in a report and the report has a table as a data source, this should work.
="Project has " & IIf(Count([FieldInTable])=0,"no records at this time",Count([FieldInTable]) & "records.&quot
Should also work for a form.
RGB

 

[Guest_imported]

Thank you.