Search results for query: *

I have a need to find only the records were either of 2 + 2 fields don't match. Example: Record1, field1 and field2 values don't match OR field3 and field4 values don't match then show record. This query is only pulling from 2 tables. the fields 1 & 3 are from one table and fields 2 & 4 are from...

I have a form that looks up records on a subform. The problem I am having is if I have used the Combo Box to filter the records multiple times on the Subform and then close the Form it changes the record that had focus on the table to be the value now selected in the combo box.

I have a simple query that now shows part number and each day it is required. I would like to only show the earliest date that each part number is required (filtering out all later dates) (should result in only unique part number and the earliest date required). I am new at Access so it is...

I have a continuous form with a pop up form with a calendar when the Field is selected. For some reason it always focuses on the first record in the field no matter which record in the field is selected. I need it to focus on the record I select.

I have a Pop up Calendar that works great in Form View on my form but I need it to work in datasheet view. How can I get the Calendar to work in datasheet view? If it makes a difference this is on a subform.