Search results for query: *

I'm using 2000/2003 and it works fine there. Can you copy the SQL into a new query (dont use the query wizard, just click Create Query in Design View, Cancel the box asking you to select tables etc, switch to SQL view and paste in) and try running the new query?

You need to enclose your dates in # so Access knows its a date, "" is text thats why its returning no result. Amend your SQL to SELECT DateDiff("ww",Now(),#1/4/1997#) AS Weeks; and it will work. You don't need a dummy table, you can save the query as an SQL query, you could also declare a...

Hi, yes I've tried CVar and get the same, DBSrrcv.dbo.recv_doc_line_tax.recv_doc_line_nbr is an integer. Thanks for replying.

Ok, thanks for trying anyway.

Thanks for the suggestions. Yes, I saw the comma and took it out,it still produced the error. I am not creating a report, I'm creating an information object so I don't have the option of overriding anything.

Thanks for that, unfortunately it produces the same error.

This is probably simple but I can't get it to work. What I need to do is convert a field from integer to varchar, so I can join it to a field in another table. I have tried to produce a Computed field using the Conversion function in Query Editor, however I get the following error...

Great thanks just what I wanted.

Hi, Is there any chance you could post an example of the code to do this? I'm new to coding Actuate and struggling with this. My situation is I have two columns and if the value of both are 0 I want to hide the row. Thanks