Hi all,
New to the forums as far as posting but been a long time reader. Im relatively new to working with Access on the design side - used to using forms and reports already made...
So here is my question...I can't figure it out (and am not 100% up to par on VB Coding)...
I have a form that will open when the database is open. It asks for a date range and then will display the data based on a query.
What I would like to do is have a button that would spit out the raw data that the form is compiled of using the data range already entered by the user.
So, for example... the form will list the below...
Number of transactions: X
Average amount of transactions: $XXX
Amount of Discount: $XXX
Transaction Date: XX/XX/XXXX
Now, what I want is a button that will display each of the transactions that the form is compiled of, but have no clue how to do it. I have a duplicate query that will list the data without any grouping, but the user still has to enter the date range again, which I am trying to avoid.
Is this even possible?