Search results

Not exactly what I'm looking for.

I'm using the following code to check if a number exists. How can I change it so it looks in the other fields too? Other fields: Msamplenumber2, Msamplenumber3 and Msamplenumber4 Private Sub Msamplenumber1_BeforeUpdate(Cancel As Integer) Dim lngLookup1 As Variant lngLookup1 =...

Looks like Query4 did the trick. Thank You!

This is what I'm looking for... Seems like it's still not clear. Sorry. In my query, I don't want to see records that have ALL three fields with a value. If ALL three have a value in those fields, I do not want that record returned. All other combinations I want to see those records.

yes

Yes, that brings back records that have a value but I want to exclude those all from view if all three fields have a value.

In a query, how can I exclude all records where field1, field2 and field3 are NOT null? All three fields must have some value in it to be excluded. Thanks

Can you show me in the report? I still don't see it.

So, I would like the report to have the current month on top (ascending) and the rest of the data ascending. Some way to have them split if possible. Thanks!

I will have to create an example db with that data to send.

I run a report every month that shows me records that are due based on a due date. So, for next month, I will change my query to be <=4/30/22. The entire report is descending on the due date. Anyway to have the current month (April) be ascending and the rest of the report descending? Thanks.

Perfect!

Can this be created using the query wizard? I basically don't want to show any records where field1, field2, field3 are all blank. Attached is my data.

Thanks for all the suggestions.

I have a query that returns the following records. I would like it to show Field1, Field2, Field3 (no records where they are all blank and records where a value is in either field1 and/or field2 and/or field3) I'm using the query wizard but can't seem to figure out the correct sequence.

But this does not give me the opportunity to select a printer?

The report is already open to specific record, not sure that works here.

And it's happening on a few other workstations too. Windows update? Virus protection update?

Yes, I do have a default printer.

I have a print button on a report. Just recently, I'm getting an error when I click the button. When I click it a second time, it prints just fine. Anyone experience anything like this? This just starting happening in the last week or so...