Make table queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a new table that has fields from two different tables.
The common field between the two tables is name_soc (employee's name
concatanated with the last 4 digits of their soc). Off one the Employee
table I need name_soc, and hrs (number hours off for vacation). Off the
second table I need the date, time off code, and holiday. The date is used
to select the desired day for vacation or a holiday's date. Time off code is
a single character for time off (H = holiday, v = vacation, etc.) Holiday
just displays the holiday if its a holiday or the user can type in a small
description of the time off. Any suggestions?

Matt
 
Matt

Can you create a Select query that connects these two tables together and
returns the rows you are after? If so, you could convert that query to a
Make Table query. But I'd ask "why"? If you can return the rows in a
select query, maybe you don't need a new table.
 
Back
Top