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...
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.
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.