Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query result in Report

Status
Not open for further replies.
dhardie

dhardie

MIS
Apr 1, 2005
4
0
0
US
Please advise procedure to get a query result (accumulated field--result is correct in query) in a unbound field on a report. I am getting a parameter error and a #error. Please advise.

Don
 
Sort by date Sort by votes
Take a look at the DLookUp or DCount or DSum function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
If the result is in the query as you stated, then you will be able to add it to a report, unless your report is not tied to the query.

Do you know what your report's control source is?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
184
TheresAlwaysAWay
TheresAlwaysAWay
Bennie47250
  • Locked
  • Question
Report Crashes
Replies
2
Views
46
kray4660
kray4660
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
54
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Delete query takes FOREVER to run 1
Replies
11
Views
99
jedraw
jedraw
Trob70
  • Locked
  • Question
There is no object in this control 1
Replies
9
Views
173
Trob70
Trob70

Part and Inventory Search

Sponsor

Back
Top