Calculation

[k11ngy]

I have the following problem
My database has a table containing customers and their cleaning schedules
For example
I have set a query that has a parameter (Which round) and the user types in
for example “Monday 1†and this will bring up customers for that round so
that the driver can go and do his cleaning jobs
The same customer can also appear on for example “Tuesday 1†for a different
type of clean
On each round there is a total due column for that customer but I need it to
show what is owed in total for both rounds by that same customer. Adding
Monday 1 & Tuesday 1 together no matter what parameter is involved.
The details are in the same table but with the parameter working I can’t
seem to get a calculation to work. I have tried “Monday 1†and “Tuesday 1â€,
also tried the “OR†statement but no success.

Hope I sound clear enough?

Kind regards

Steve

 

[Wayne-I-M]

Hi

If it was me I would not try to use the same query for the 2 tasks -
printing work loads and running off invoices. Of course you can - but whats
the point. If you create a new query you can add lots of other "stuff" into
it that will not need just to see the Rounds for that day.

Create a new query with the information you need to work out the costs for a
specific person. Create a report from this. You can eitheruse a prompt to
get the invoice for the person or (better) use a form to apply the filter (a
little like a prompt) and then (using the same button press on the form)
print off the invoice.

You need to give more details to get more than a very general answer but I
hope this helps a little

 

[k11ngy]

Thanks for reply Wayne, sorry for late response, been away for a while

Not the most expert database user and still cannot work out a solution for
this.

At the moment driver takes his round sheets based on parameter query (IE
Monday 1) which contains for example an address - 3 High Street and shows
what is owed by that person. he also cleans for same address but on say
Thursday 2 and that will show on thursday 2 round what client owes for a
totally different clean. he can have a full statement of account which
groups the 2 same address together and he will refer to that statement of
account to show the total but of course he would like the 2 totals added
together and shown on round whether it be Monday 1 or Thursday 2 when he goes
off to work. Confusing myself now I think

I will battle away but if you come up with any ideas I would be grateful

Thanks again Wayne

Kind regards

Steve