Error Message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am getting "InValid Argument" when trying to name this query

SELECT BUQ.*,Format([TimeOfMessage],"@@:@@:@@")
FROM BUQ;

What am I doing wrong ?
 
What is it you are trying to accomplish? Is [TimeOfMessage] a field in BUQ?
If so, then you need to give it an alias like this:
SELECT BUQ.*,Format(BUQ.TimeOfMessage,"@@:@@:@@") As MessageTime
FROM BUQ;

Now your query will have an additional field named MessageTime.
 

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

Back
Top