Query to work out which rate should be inserted

L

Leanne

Im not sure if this is the right way to go about this but I would like a way
to get the computer to automatically input the correct rate.

I have 3 tables, 1 has invoice details (invoice, job number, hours charged,
type, customer) 2nd has Engineer details (job date, job number, time paid,
pay rate, engineer name) and my last have customer rates (customer, callout
rate, job rate)

my job number and customer fields have lookup relationships

I would like a query to display
Invoice, Job number, hours charged, type, customer and a new field Rate

For the rate heading i need the query to look at what customer is selected
and what job type is selected in order to display the correct rate

is this possible?
 
K

KARL DEWEY

Your [customer rates] table does not include job type so as to select the
correct rate.
 
M

Miranda

You would create your query and add both tables Invoice Details and Customer
Rates. You would add all fields from Invoice Details and the rate field from
Customer Rates. Since you say your tables are linked by job number and
customer, I assume they hold equal information. However, when you link two
tables by a common field, you really should keep the same name from table to
table to make it less confusing.
--
Miranda


KARL DEWEY said:
Your [customer rates] table does not include job type so as to select the
correct rate.

--
Build a little, test a little.


Leanne said:
Im not sure if this is the right way to go about this but I would like a way
to get the computer to automatically input the correct rate.

I have 3 tables, 1 has invoice details (invoice, job number, hours charged,
type, customer) 2nd has Engineer details (job date, job number, time paid,
pay rate, engineer name) and my last have customer rates (customer, callout
rate, job rate)

my job number and customer fields have lookup relationships

I would like a query to display
Invoice, Job number, hours charged, type, customer and a new field Rate

For the rate heading i need the query to look at what customer is selected
and what job type is selected in order to display the correct rate

is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top