Create Query to display three fields for every record in a table.

[AJRoad]

Each customer is required to make a 10 percent deposit for each job. I need a
query to display Job ID, Customer ID, and deposit amount fields for every
record in my Jobs table. The fields that are included in my table are:Job ID
(primary key), Customer ID, Job Description, Job Status, Completion Date and
Quote. I would also like to format deposits with a dollar sign and two
decimal positions.

I appreciate your help,

AJRoad

 

[Duane Hookom]

You are asking how to display a currency value but don't seem to have any
fields in the table you described that store a currency value. I'm not sure
how anyone can help you.

 

[AJRoad]

You are asking how to display a currency value but don't seem to have any
fields in the table you described that store a currency value. I'm not sure
how anyone can help you.

 

[AJRoad]

The Quote field is the Customer's cost for the job.

 

[Duane Hookom]

Try as query like:

SELECT [Job ID], [Customer ID], Quote * 0.1 As DepositAmount
FROM Jobs;