First off, sorry I know this is in the wrong forum but I didn’t know what other forum to place Access questions, plus I’m desperate so give me a break. By the way if one of the mods decides to move this I’d be grateful, thanks
Working on an access database and I’ve got a problem.
A query is used to generate information for a report. This query gets customer and order information from the tables and shows it in the report. However for each customer it displays things like name, order, balances, that sort of thing.
At the end of each customers details the balances are added up and shown as total figures for that customer.
Now my problem is that using that query I have to produce a report that will show all the totals and a grand total on one page, i.e. it can’t be spread over pages like it is now.
No idea where to start really. First off how do I alter the query and report so that instead of customers details being shown on individual pages and how do I add the totals together to get a grand total.
Struggling here & clients waiting…help, please.
Also having trouble with a combo box in a form. You see the combo box is populated by a query which the user then selects a customers id from. They then click go and the value from the combo box is used in an another query but I can’t get it to work…here is the code I’m using
WHERE ([Company Details].[Customer ID] Like [Forms]![Customer Drop Down]![DropID]&"*")
Sure this is the right code and pointing at the right form but it doesn’t work.
Any help, and I mean any help, would be appreciated :thumb:
