Why won't access show all my data?

M

Monkey_bum

I'm having a problem with access where I have added in new tasks and who they
are assigned to, but once i do a query for who they have been assigned to it
does not recognise any new data. What do i do?!?!
 
B

BruceM

You will need to provide some details of how your database is constructed,
and what you mean by "added in new tasks and who they are assigned to" and
"once I do a query for who they have been assigned to".
 
M

Monkey_bum

The database is used to capture any job within the company. This means we
enter the task description, due date, allocated to, status fiels etc.

When a new task is entered we allocated to someone within the company.

If i do a search for all the tasks assigned to a certain person the database
only brings up a select few jobs rather than all the jobs assinged to that
person.
 
T

TedMi

Please provide a description of your table structures, and the SQL of the
query which is not working the way you expect.
 
B

BruceM

How are you searching? You can use the combo box wizard to set up a combo
box that will find records that match what you selected in the combo box.
To do that the combo box row source will need to be the EmployeeID, or
whatever you are using as the primary key.
 
Top