Setting Variables for SQL

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Rob" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Sun, 2 Mar 2008 18:48:55 -0000

Hi, Using Access 2000. I have a statement in a Union Query that is
([DEBT]![BAL]/[SALE]![TURNOVER])*7 AS [Calc DOC] which works albeit I want
to round the result, I have added CINT but running the query now fails as
says the query maybe to complex, try setting variables
CANT(([DEBTMAIN]![CURRBAL]/[SALEMAIN]![TURNOVER])*7) AS [Calc DOC].

The CINT formula is shown 3 times in the SQL so a variable may work, albeit
I can't find how to set this up.

Any pointers would be helpful. Thanks Rob.

.

Follow-Ups:
- Re: Setting Variables for SQL
  - From: Marshall Barton

Prev by Date: Re: completing a query
Next by Date: Re: Enter date once only
Previous by thread: Re: Append Query Key Violation
Next by thread: Re: Setting Variables for SQL
Index(es):
- Date
- Thread

Relevant Pages

Re: sort report by year (weird format)
... what i primarily look at) -- i appreciate your response and your help, ... The quick and dirty fix using the query consists of adding ... record source to see if there is an invalid entry. ... the wrong function (CInt) - any other one you know of that will work ...
(microsoft.public.access.reports)
Re: sort report by year (weird format)
... Marshall Barton wrote: ... The quick and dirty fix using the query consists of adding ... record source to see if there is an invalid entry. ... the wrong function (CInt) - any other one you know of that will work ...
(microsoft.public.access.reports)
Re: sort report by year (weird format)
... The quick and dirty fix using the query consists of adding ... record source to see if there is an invalid entry. ... the wrong function (CInt) - any other one you know of that will work ...
(microsoft.public.access.reports)
Re: Setting Variables for SQL
... The query could contain 0 or be null. ... Microsoft Access MVP ... I have added CINT but running the query now fails as ... Thanks Rob. ...
(microsoft.public.access.queries)
Re: VBScript INT Type Mismatch
... You should post more of your script, include the part that is working (returning ... You need to run CInt against the results, ... Microsoft VBScript runtime error: Type mismatch: 'Cint' ... If I run the query in Query Analyzer it returns a numeric value. ...
(microsoft.public.windows.server.scripting)