Select statement to vba

[Jake55923]

I cannot figure out how to transfer this sequel statement into vba code. I know the syntax for the overall select statement, but the count portion is giving me trouble.

SELECT [tbl Safety].Department, [tbl Safety].Status, Count([tbl Safety].Status) AS CountOfStatus
FROM [tbl Safety]
GROUP BY [tbl Safety].Department
HAVING ((([tbl Safety].Status)="Completed" Or ([tbl Safety].Status)"Incomplete"));

Thanks in advance
Jake

 

[ghudson]

I believe that you can only run "action" [update, append, delete] SQL in VBA, not a "select" SQL.

 

[dcx693]

What do you mean translate SQL into VBA?

You have a syntax error in the last line of the SQL:
Or ([tbl Safety].Status)"Incomplete"));

Also, what other Status entries are possible besides Complete or Incomplete? Just wondering? I guess it could be Unknown.