I have the input box in the report's vba code. When I run the accees report, it is populated by a query and the summary data are calculated on the report. I close the report and then go back to the application and click the 'Export' button, which exports the data from the access report...
Hi,
I have an access application with a report. I allow the user to enter some foot notes using an input box before opening the report. If the user enters some notes into the input box, it is displayed at the bottom of the access report. Since the report has summary data, I export it to Word...
Hi Roy,
It worked ! Thanks for your help and I really appreciate it. I am new to access reports and thanks to experts like you, I am picking up !
Thanks again,
Alex
Hi.
I have a report which displays drug records with fields such as drug name, rebate price etc. For a particular drug name "ABC", I want to display "N/A" for the rebate price field. How do I do this on the report? and where do I write the conditional code that checks the value of one field and...
Hi lupins46,
Your query and suggestion helped me to write a query that fetched the correct results ! Thanks a lot. I used the following query:
SELECT tblROROutput.*
FROM tblROROutput INNER JOIN [SELECT TOP 10 tblROROutput.HIC3
FROM tblROROutput
GROUP BY...
Hi,
I have a reporting issue. In my report, drug details are grouped by Class names. Each drug record has details like prescription count, price etc. The report groups the drugs by their Class. So, under each Class Name, I have the corresponding drug records with summary information. The...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.