Finding a percentage in a query. Newbie

[Guest]

I have a table with Customer Id, Job ID, Job Status, Completion Date, and
Quote. If each client is to make a 10% deposit for each job, and I can only
display job ID and Customer ID, how can I figure it out? I have tried many
expressions, and can't get it. PLEASE HELP.

 

[Wayne Morgan]

I don't follow. If you aren't using the quote, then how are you going to
calculate 10% of the quote? If you add another field to the query, you could
make a calculated field that would show you what 10% of the quote should be.

Example:
In the Field box of the query designer, try something like,

DownPayment:Format(

/10, "Currency")

This will create a field in the query called DownPayment and the value
displayed in the field will be 1/10th of the quote.

 

[George Nicholson]

I assume that your problem is that there is really only 1 quote per JobID
but that the value repeats in your table (i.e., your data is not fully
normalized). If so, you need to do this in 2 steps (and if that's not the
problem, please ignore...):

Query1: Based on your table: Group on CustomerID and JobID. = TotalQuote:
Max(

)
(I assume only 1 quote per JobID.)

Query2: Based on Query1:
CustomerID, JobID, Deposit: = TotalQuote* 0.10

HTH,