Help with Select Joins

V

visidro

I have a report where I would like list various fields from two tables. I
have joined these two tables by FirstName and assistant's names. I am unable
to get the billingrate using the select statement bellow:

SELECT Employees.BillingRate FROM Employees INNER JOIN [Work Time Sheet] ON
Employees.FirstName = [Work Time Sheet].[assistant's names];

I have tried different joins (left, right), I am not sure what I am doing
wrong, could you help please?

thank you
victor
 
K

KARL DEWEY

I have a report where I would like list various fields from two tables.
Your query only select one field from one table.
Why do you need to join these two tables?
 
V

visidro

Thanks for answering Karl.

I need to create a report that shows Billing Rate, Time start, Time Finish
and amount; the start time and the Finish time reside on the work time sheet
table; the billing rate resides on the employee table the amount is
calculated from these fields.
What should be the row source or control source on the billingrate field?

thanks again.

KARL DEWEY said:
Your query only select one field from one table.
Why do you need to join these two tables?

--
KARL DEWEY
Build a little - Test a little


visidro said:
I have a report where I would like list various fields from two tables. I
have joined these two tables by FirstName and assistant's names. I am unable
to get the billingrate using the select statement bellow:

SELECT Employees.BillingRate FROM Employees INNER JOIN [Work Time Sheet] ON
Employees.FirstName = [Work Time Sheet].[assistant's names];

I have tried different joins (left, right), I am not sure what I am doing
wrong, could you help please?

thank you
victor
 
K

KARL DEWEY

I recommend you create a query and base the report on it.
Seems to me using FirstName and [assistant's names] is poor as some will put
nickname instead of true name. What happens if you have two employees with
the same name? I would use EmployeeID in both cases.
I would use a left join from employees to timesheet as you will always have
employee but may not have a timesheet for them.
--
KARL DEWEY
Build a little - Test a little


visidro said:
Thanks for answering Karl.

I need to create a report that shows Billing Rate, Time start, Time Finish
and amount; the start time and the Finish time reside on the work time sheet
table; the billing rate resides on the employee table the amount is
calculated from these fields.
What should be the row source or control source on the billingrate field?

thanks again.

KARL DEWEY said:
I have a report where I would like list various fields from two tables.
Your query only select one field from one table.
Why do you need to join these two tables?

--
KARL DEWEY
Build a little - Test a little


visidro said:
I have a report where I would like list various fields from two tables. I
have joined these two tables by FirstName and assistant's names. I am unable
to get the billingrate using the select statement bellow:

SELECT Employees.BillingRate FROM Employees INNER JOIN [Work Time Sheet] ON
Employees.FirstName = [Work Time Sheet].[assistant's names];

I have tried different joins (left, right), I am not sure what I am doing
wrong, could you help please?

thank you
victor
 
V

visidro

Thanks Karl I'll try that.

KARL DEWEY said:
I recommend you create a query and base the report on it.
Seems to me using FirstName and [assistant's names] is poor as some will put
nickname instead of true name. What happens if you have two employees with
the same name? I would use EmployeeID in both cases.
I would use a left join from employees to timesheet as you will always have
employee but may not have a timesheet for them.
--
KARL DEWEY
Build a little - Test a little


visidro said:
Thanks for answering Karl.

I need to create a report that shows Billing Rate, Time start, Time Finish
and amount; the start time and the Finish time reside on the work time sheet
table; the billing rate resides on the employee table the amount is
calculated from these fields.
What should be the row source or control source on the billingrate field?

thanks again.

KARL DEWEY said:
I have a report where I would like list various fields from two tables.
Your query only select one field from one table.
Why do you need to join these two tables?

--
KARL DEWEY
Build a little - Test a little


:

I have a report where I would like list various fields from two tables. I
have joined these two tables by FirstName and assistant's names. I am unable
to get the billingrate using the select statement bellow:

SELECT Employees.BillingRate FROM Employees INNER JOIN [Work Time Sheet] ON
Employees.FirstName = [Work Time Sheet].[assistant's names];

I have tried different joins (left, right), I am not sure what I am doing
wrong, could you help please?

thank you
victor
 

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