We help IT Professionals succeed at work.

Check out this week's podcast, "Dairy Farms to Databases: Community's Hand in Technology"Listen Now

x

MS Access Report

snhandle
snhandle asked
on
401 Views
Last Modified: 2014-08-05
I have report in Access where I am using "dlookup" formula(report footer) to get the data from another table. Now I am using parameter for the report. I want "dlookup" formula to use the same criteria that I use in the parameter. It should return only that that i use in the parameter.
Comment
Watch Question

Hamed NasrRetired IT Professional
CERTIFIED EXPERT

Commented:
You mean parameter in query for the report!

Just add the parameter as a field in the query, and will be available as a field in the report based on the query.

PARAMETERS x Short=100;
SELECT a.f1, x AS Expr1
FROM a
ORDER BY a.f1;

For further discussion, upload a sample database demonstrating the problem.
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Since you did not post your existing Dlookup, or post what the new parameters are, or how you are gathering them, or how many there are, ...
 ...it is difficulty to give you an exact solution.

This is why it is always helpful to post a sample database

Author

Commented:
Attach is the database. When I run the Report2, it ask for criteria and I put "Source2" and the report Start Amount give me "Source1" Start Amount from 'Start Amount" Table instead of Source2. The start amount should match what I put in the parameters. thanks
Test-Report2.accdb
Retired IT Professional
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
What if I use dropbox for the parameters, where I can select the source from drop down menu. Then what would be the dlookup formula. thanks
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.