If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating Top 10 in linked subform
I've created a customer database that contains customer info and sales
history. I have a customer form that on one of the tabs is supposed to show the top 10 products purchased based on total revenue. This is a subform with CustomerID fields linked. The underlying query in the subform contains CustomerID, Partnumber, Description, Quantity (summed), and Revenue (summed and ascending). When I open the main form and go to the tab, my subform is blank. The query works if I manually enter a filter for a particular CustomerID. (It will show that customer's top 10 products). But when I try to run it form the form, it doesn't. Any suggestions? Thanks, Adam |
#2
|
|||
|
|||
Creating Top 10 in linked subform
Figured it out.
Put the following in the Criteria of my query for CustomerID: [Forms]![frmCustomers]![idsCustomerID] "Adam C." wrote: I've created a customer database that contains customer info and sales history. I have a customer form that on one of the tabs is supposed to show the top 10 products purchased based on total revenue. This is a subform with CustomerID fields linked. The underlying query in the subform contains CustomerID, Partnumber, Description, Quantity (summed), and Revenue (summed and ascending). When I open the main form and go to the tab, my subform is blank. The query works if I manually enter a filter for a particular CustomerID. (It will show that customer's top 10 products). But when I try to run it form the form, it doesn't. Any suggestions? Thanks, Adam |
Thread Tools | |
Display Modes | |
|
|