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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AJRoad - 26 Apr 2008 18:57 GMT

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

Reply to this Message

Duane Hookom - 26 Apr 2008 21:48 GMT

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.

Signature

Duane Hookom
Microsoft Access MVP

> 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
[quoted text clipped - 6 lines]
>
> AJRoad

Reply to this Message

AJRoad - 26 Apr 2008 21:53 GMT

> 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
[quoted text clipped - 10 lines]
> >
> > AJRoad

Reply to this Message

AJRoad - 26 Apr 2008 21:56 GMT

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

Reply to this Message

Duane Hookom - 26 Apr 2008 23:15 GMT

Try as query like:

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

Signature

Duane Hookom
Microsoft Access MVP

> The Quote field is the Customer's cost for the job.
>
[quoted text clipped - 12 lines]
> > >
> > > AJRoad

Reply to this Message