Access Query

I am making an Access database to keep record of vacation schedule.

The tables I set up are:
Personal_Days
Sick_Days
Other_Days
Employee Name

To set up the database I do create a unique key for each table named:
Personal_DaysID
Sick_DaysID
Other_DaysID
EmployeeID

I put the EmployeeID field in each table and link the Employee table to all the othet tables.

I bulid one query using all the tables and then a form using all the fields from the query.

When I look at the form in the form view it is completely blank.

If I use the tables individually I see the fields but not when I use the query.

Could someone help me as to what the problem is.

Thank you








Comments

  • Well, what's the query you're using?


    : I am making an Access database to keep record of vacation schedule.
    :
    : The tables I set up are:
    : Personal_Days
    : Sick_Days
    : Other_Days
    : Employee Name
    :
    : To set up the database I do create a unique key for each table named:
    : Personal_DaysID
    : Sick_DaysID
    : Other_DaysID
    : EmployeeID
    :
    : I put the EmployeeID field in each table and link the Employee table to all the othet tables.
    :
    : I bulid one query using all the tables and then a form using all the fields from the query.
    :
    : When I look at the form in the form view it is completely blank.
    :
    : If I use the tables individually I see the fields but not when I use the query.
    :
    : Could someone help me as to what the problem is.
    :
    : Thank you
    :
    :
    :
    :
    :
    :
    :
    :


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion