asked on Add a field from main report with a field from subreport
I was wondering if it is at all possible to add together a field that is in my main report with a field that is in a subreport? I need to add those two fields together and then use that number on the main report to see if it is greater than another field. If it is greater than the other field it is removed from the report. Any suggestions would be appreciated!
Thanks
Thanks
Microsoft Access
Last Comment
PatHartman
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for the suggestion! How about if I just wanted to add together two fields in separate query? One field is in my main report and the other is in a sub report. How would I go about adding those and having it output the number?
That will not be easy, neither can I see the purpose.
/gustav
/gustav
If you are performing the operation in the main report, exactly which record from the subreport do you think you are referencing? You can only reference the current record of a continuous or ds view form/report and most of the time current is actually the first row in the recordSource.
I see you have accepted an answer. Make sure you understand exactly what subreport record you are referring to.