Search results for query: *

Leslie, Thanks I think your code will work, but I am evidently leaving something out. Could you take a look and let me know if you see anything? SELECT DISTINCT Q891666.PART_NUMBE, Q891666.DESCRIPTIO, Q891666.QTY, Q891666.OP, Q891666.WORK, Q891666.CENTER, Q891666.BASE AS [Old Base]...

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 looked at this and the combo Box control source is a table while the subform is based from a query. It sounds like you can help me, if only I can explain it well enough for you to understand. (I am fairly new at Access so please overlook my lack of understanding) Everything work exactly as I...

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.

Thanks Remou, That has gotten me a lot closer, but I am still returning "some" multiple results on some part numbers. I posted my code below, if you could provide a little more help it would be appreciatted. SELECT DISTINCT ORtg.[Part Number], Prmspm.Description, Min(MRP.[Due Date]) AS...

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.