RE: Create Query to display three fields for every record in a table.
- From: Duane Hookom <duanehookom@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 26 Apr 2008 13:48:01 -0700
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.
--
Duane Hookom
Microsoft Access MVP
"AJRoad" wrote:
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
- Follow-Ups:
- References:
- Prev by Date: Re: Queries & calculations
- Next by Date: RE: Create Query to display three fields for every record in a tab
- Previous by thread: Create Query to display three fields for every record in a table.
- Next by thread: RE: Create Query to display three fields for every record in a tab
- Index(es):
Relevant Pages
|
