Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 479
  • Last Modified:

ACCESS 2003 sql statement in query

I have an
Complete Hour Status: IIf([CompleteProcessHr]<13,"Completed By 1 pm",IIf([CompleteProcessHr]<14,"Completed By 2 pm",IIf([CompleteProcessHr]<15,"Completed By 3 pm",IIf([CompleteProcessTime]<#4:31:00 PM#,"Completed By 4 pm","Completed AFTER 4  pm"))))
 ACCESS 2003 query where I need a stmt to  group by the hour except for one of the IIF which groups by hour and minute.   See my stmt below.  it results in #ERROR.  

Help.  I know the issue is with IIf([CompleteProcessTime]<#4:31:00 PM#,"Completed By 4 pm" as if I remove this portion of the stmt the query works.

HELP  Thank You
0
eyes59
Asked:
eyes59
1 Solution
 
eyes59Author Commented:
I have an
 ACCESS 2003 query where I need a stmt to  group by the hour except for one of the IIF which groups by hour and minute.   See my stmt below.  it results in #ERROR.  

Complete Hour Status: IIf([CompleteProcessHr]<13,"Completed By 1 pm",IIf([CompleteProcessHr]<14,"Completed By 2 pm",IIf([CompleteProcessHr]<15,"Completed By 3 pm",IIf([CompleteProcessTime]<#4:31:00 PM#,"Completed By 4 pm","Completed AFTER 4  pm"))))


Help.  I know the issue is with IIf([CompleteProcessTime]<#4:31:00 PM#,"Completed By 4 pm" as if I remove this portion of the stmt the query works.

HELP  Thank You
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now