Error Message

C

carl

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

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

What am I doing wrong ?
 
K

Klatuu

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,"@@:mad:@:mad:@") As MessageTime
FROM BUQ;

Now your query will have an additional field named MessageTime.
 
Top