Search results

I'm using the following code in a query but can't seem to get what I need... Date: IIf(Not IsNull([Manalysisdate1]),[Manalysisdate1],IIf(Not IsNull([Manalysisdate2]),[Manalysisdate2],IIf(Not IsNull([Manalysisdate3]),[Manalysisdate3],IIf(Not IsNull([Manalysisdate4]),[Manalysisdate4]))))...

Damn, thought I tried that. Thanks!

I'm working with a datesent field in a query. I do not want records from today and less than 14 days. So, I don't want to see records from 3/18/22 to 4/1/22 Not Date()-14 like this?

Well, the code I'm using now works perfectly. When a user inputs a value in that field and it already exists, I get a message. I'm not looking to redesign, just to want to know if I can make it look at the value in the other fields too.

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?