Cannot filter in a table and query

**jenncivello** · 03-24-2015, 06:27 AM

I have 1 table that has a query created from it and in both the table and query I cannot filter. When I click the down arrow to apply a filter it is blank, the list does not show up to select what I want to filter on. But the other tables and queries are working fine. Please help.

If I do try to sort ascending or descending it says record is deleted?

**orange** · 03-24-2015, 08:29 AM

Please show the table design, and the SQL of the query.

**jenncivello** · 03-24-2015, 09:02 AM

I think I found the problem. There are 2 records that are deleted. How can I fix this?

Click image for larger version.

Name: Deleted Records.jpg
Views: 5
Size: 214.2 KB
ID: 20134

**June7** · 03-24-2015, 02:27 PM

Very odd. Those records should not show after the datasheet display is refreshed.

Cannot filter in a table and query

Thread Tools

Cannot filter in a table and query

Similar Threads

Filter Query Name Listed in Table that lists if employee has access.

Filter Form based on Table with Combo based on Query?

Access Query to filter out list based on multiple row criteria from another table

creating an advanced listbox filter with multi-table query

Query drop down filter list has data that is not in table.

Posting Permissions