Why won't access show all my data?

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

Guest

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?!?!
 
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".
 
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.
 
Please provide a description of your table structures, and the SQL of the
query which is not working the way you expect.
 
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.
 

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

Back
Top