Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access Report
Message
 
To
21/01/2002 14:42:07
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
00607940
Message ID:
00608176
Views:
30
>How to put in Acccess header report expression like
>
>Count (field1) for field1>10
>What is the right syntax?


I think (because I am not an Access expert) that you need to create a sub-report with a data source like "Select COUNT(Field1) FROM TableSomething Where Field > 10" and place this sub-report onto your main report.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Reply
Map
View

Click here to load this message in the networking platform