Inconsistent number of records

[MarcieFess]

I'm not an Access developer...but I'm becoming one quicky.

I have split the database, with the back-end residing on the server. Only 1 other person is working in Access right now; she's verifying the data. Today she's working directly in the back-end so someone, please tell me if this could be the problem. If it is, I'm going to have to create a front-end for her quickly.

My problem is this...I'm working on queries and forms so that the scientists who will ultimately be using this application, won't be able to go in and inadvertently change something in the tables set-up. When I'm in the back-end main data table, it says I have 2723 records.

When I create a front-end query to query all the records in that table, it says I have 2160 records.

The input form that I created with most of the same fields as the query (created BEFORE I created the query...I'll have it pull from the query now instead of directly from the table) also says we only have 2160 records.

Can someone point me in the right direction? Thanks!

Marcie
Using Access 2010

 

[boblarson]

1. When you open the table directly in the Frontend, what does it show?

2. Does the query contain more than one table? if so, it may need an outer join since matching data may not be in the other table.

 

[MarcieFess]

The Product Query shows 2184 records.

I've included a screen shot of the Design View...I hope I did it right.

The Product data table has 2732 records.

Marcie Fessler

 

[MarcieFess]

Here's the shot of the Form in Design View...

 

[boblarson]

The Product Query shows 2184 records.

I've included a screen shot of the Design View...I hope I did it right.

The Product data table has 2732 records.

Marcie Fessler

Change your link in your query to be an OUTER JOIN. Double click on the link and select the option which reads something like "Select All Records from Product and only those records which match in Store Products."

 

[MarcieFess]

That was it!

I went into the form and did the same thing...now it all matches.

THANK YOU!!!!!