Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in posts by highbulp only
Search
Advanced Search
Forums
Product Launch
Updates
Today's Posts
Member List
Calendar
Home
highbulp
User Profile
Collapse
Profile Sidebar
Collapse
highbulp
Last Activity: Oct 17 '06, 03:05 PM
Joined: Oct 11 '06
Location:
Subscriptions
1
Subscribers
0
Activities
About
Media
Subscribed
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Source
All
highbulp only
Visitor Messages Only
Advanced
Filtered by:
Clear All
new posts
highbulp
started a topic
Problems with reports, functions, and queries with parameters
in
Access
Oct 11 '06, 08:50 PM
Problems with reports, functions, and queries with parameters
I'm trying to use the DCount() function in the Report Header of a new report. The ReportSource for this report is a parametered Query. My DCount call looks like:
DCount("[fieldname]","[QueryName]","[fieldname]=1")
where QueryName is the name of the parametered Query. However, when I go to Print Preview, instead of giving the count Access simply displays "#ERROR"
I'm pretty sure...
See more
|
Go to post
No activity results to display
Show More
Working...
Yes
No
OK
OK
Cancel
👍
👎
☕