Hello all - I have created about 6 individual reports that each function perfectlly independently. I am trying to figure out how to combine them into one report. i tried creating a blank report and adding 6 subreports with no data linking them together but they do not show up as they would if I...
Paul You Are By far the most helpful online friend I have ever met. I was able to play around with this last night and I have it working.
This has been a great learning experience and I thank you very much for your assistance.
One virtual beer heading your way~!!!!!!!
Ok I checked the Tools/References and DAO 3.6 library is checked
I removed the association with the query - the form is now unbound. Question should I have the field on the form something other than Store_ID?
Also do I have to enter a value in here before I pres the button?
Quote...
Recap I have one table with 6 fields
ID
Store_ID
Store Name
Item
Amt
Month
A query built on this table called test - with all fields
A report built on thsi query Called Commissions_Rpt
A form built on this query called Commissions_Frm
Thanks - so just to clarify on my report on event command...
Ok So here I my questions: I am good with making this an on open event
Me.Filter = "ShipmentsID=" & Forms![Select Load List]![LoadID]
Me.FilterOn = True
Would “ShipmentsID” be the unique ID that identifies my distribution channel or recipetient? In my case “StoreID” which is unique to each...
Hello I am hoping that someone here can help me I have an have a database with a very simple table with about 12500 records format is as follows
Example:
(here it s pipe delimited just for illustration purposes)
Dicks Sporting Goods | Widget 1 | $7,000 | Jan
Dicks Sporting Goods | Widget 2 |...