USING FORMULAS WITH REPORTS FOR SUM
Tech-Archive recommends: Speed Up your PC by fixing your registry
Date: Thu, 17 Feb 2005 00:23:18 -0600
I am trying to create a report in access 03 that allows me to total
all balances in the [total_balance] field for all those that have
been customer for >5 and <11 in the [days] field and then for
those customers that have had accounts for >10 and <21 [days]
and so on.
I have been trying to do this in the control source and have had no
luck. I also have created different queries for the different days
open, but when I try to design a report with more than one query it
tells me that wizard can't connect try choosing fields from only the
table or only the query.
Any help here would be wonderful.
Thank you,
Jocats1
Relevant Pages
- Re: Help ... Creating an invoice
... So what you will want is a query that will return the required information ... for a report to use. ... for just the records for that customer. ... > if I want that order to be placed on the invoice? ...
(microsoft.public.access.forms) - Re: Help ... Creating an invoice
... That query should use the customerID value to filter> for just the records for that customer. ... >> if I want that order to be placed on the invoice? ... My original answer was that you would> automatically generate a report including all orders for that customer. ...
(microsoft.public.access.forms) - Re: Report / Sub-Report Problerm
... the customer account in the mainform, so equipment that does not match the ... It might be easier to do this with just one report instead of a report and ... Create a query using just tblCustomers and tblProductGenerics. ... this combination of customer and product exists in the tblCustomerEquipment ...
(microsoft.public.access.reports) - Re: move data from list box or combo box to another list
... employees is because each employee gets paid commission on the service they ... The customer and dates are ... Lets address your problem with your report which seems to be your main ... Oh yeah and also you should/could have a filter in your query so that your ...
(microsoft.public.access.forms) - Re: move data from list box or combo box to another list
... Hey Roger! ... Lets address your problem with your report which seems to be your main ... Oh yeah and also you should/could have a filter in your query so that your ... report will only show the data for one customer and one order. ...
(microsoft.public.access.forms) |
|
