Hello, I have a report that has a record source of Query 1. I have another query (query 2) which only spits out ONE value. Is it possible to display the value of Query 2 in the report with the record source of Query 1? thanks
nvm.solved.
Display Value of another QUERY into a Report
Competent Performer
Windows XP 
Access 2000
Hello, I have a report that has a record source of Query 1. I have another query (query 2) which only spits out ONE value. Is it possible to display the value of Query 2 in the report with the record source of Query 1? thanks
nvm.solved.
Administrator
Windows 7 64bit Access 2010 32bit
Do you care to share your solution so others that read these forums can benefit?
VIP
Windows XP Access 2010 32bit
I suspect the solution was to nest the queries. I.e., query 2 would be an expression that created a new field in query 1.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Query for Report, display only if condition is met, multiple conditions
Report control of a field display/no display
Posting Permissions
Reply With Quote