If statement with select query

  • Thread starter Thread starter Stephen Lynch
  • Start date Start date
S

Stephen Lynch

Cab I use a select statement as part of an if, then statement?

For example

If

SELECT Count(tblRetireHQImportTEMP.ErrorMsg) AS CountOfErrorMsg FROM
tblRetireHQImportTEMP HAVING (((Count(tblRetireHQImportTEMP.ErrorMsg)) Like
'Error*'))>0'"

Then

DoCmd.OpenForm

Else

Whatever!


I want to count the number of records with an error message and if greater
than zero open form1 otherwise form2..

Thanks

Steve
 
Stephen said:
Cab I use a select statement as part of an if, then statement?

For example

If

SELECT Count(tblRetireHQImportTEMP.ErrorMsg) AS CountOfErrorMsg FROM
tblRetireHQImportTEMP HAVING (((Count(tblRetireHQImportTEMP.ErrorMsg)) Like
'Error*'))>0'"

Then

DoCmd.OpenForm

Else

Whatever!


I want to count the number of records with an error message and if greater
than zero open form1 otherwise form2..
Click to expand...


No, but you can use an equivalent Domain Aggregate function:

If DCount("*", "tblRetireHQImportTEMP", "ErrorMsg Like
'Error*') > 0 Then
 
Back
Top