IF AND Statements

  • Thread starter Thread starter Larisa
  • Start date Start date
L

Larisa

Is it possible to have an IF and AND statements at the same time in the same
cell?

Thank you!
Larisa
 
You mean code in a module?? ..a Calculated Field in a query...

Private Sub GoEntry()
If (Not IsNull(txtDate) And Not IsNull(TheShift) _
And Not IsNull(DayOfWeek) And Not IsNull(List2) _
And Not IsNull(List5)) Then
cmdDataEntry.Enabled = True
Else
cmdDataEntry.Enabled = False
End If
End Sub
 
Bob is there a formula that I can use without using VBA? (I'm still in the
process of learning VBA)

Thank you!
 
If you're familiar with IIF, you can nest IIF(s) within a statement for a
Calculated Field.

Does that Help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Charts 2
Reusable statements in queries 2
If/And Statement 2
Spooler causes high CPU Usage on Windows XP Pro 1
Adding color to an if statement 2
Can I Build an Access Statement (in 2007) as a String and Execute 3
Excel Excel IF statement with 3 outcomes 1
Filtering between two columns 7

Back
Top