Multiple Where Condition Filters (Open Form Macro) (1 Viewer)

EdMasto

New member
Local time
Today, 18:46
Joined
Oct 13, 2021
Messages
2
I am trying to set multiple where condition filters on Open Form Macro.
CustNumber = CustNo And OpenQty >= .01

The field OpenQty is on the Form to be opened

I currently have this in the where condition

="[CustNumber]=" & "'" & [CustNo] & "'" And [OpenQty]>=0.01

Any Help would be greatly appreciated!
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 15:46
Joined
Aug 30, 2003
Messages
36,118
Try

="[CustNumber]='" & [CustNo] & "' And [OpenQty]>=0.01"
 

EdMasto

New member
Local time
Today, 18:46
Joined
Oct 13, 2021
Messages
2
That Worked AWESOME. I get very confused by the quotes and single quotes sometimes.

Thanks for the help. I am very new to Access but love it. Hope MS doesn't discontinue this software!
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 15:46
Joined
Aug 30, 2003
Messages
36,118
Happy to help! They still have a development team, so I don't think it's going away anytime soon.
 

Users who are viewing this thread

Top Bottom