|
 |
access thread: Run-time Error 3075
Message #1 by "Marcelo R. Lopez, Jr." <mis@p...> on Tue, 20 Aug 2002 00:26:45
|
|
When I'm trying to execute an update query:
DoCmd.RunQuery("ApplyDecimalPoint")
Run-time Error 3075
Function is not available in expressions in query expression
IIf([CLAIMSDUMP]![Char_Amount]<>0,(Mid([CLAIMSDUMP]![Char_Amount],1,Len
([CLAIMSDUMP]![Char_Amount])-2) & "." & Right([CLAIMSDUMP]!
[Char_Amount],2)),0)
This expression is executed on the entire table on the "Char_Amount" field.
When I try to execute this query via code ( or apply it via the "!" in the
toolbar ), I get this error pop.
I've tried to repair my Office 2000 installation, and nothing seems to
help. Does anyone have an idea of where this error emanates from, and what
I can do to correct it ?
As always, any and all suggestions, will be greatly appreciated.
Marcelo R. Lopez, Jr.
Message #2 by "Marcelo R. Lopez, Jr." <mis@p...> on Tue, 20 Aug 2002 00:28:33
|
|
>
> When I'm trying to execute an update query:
> DoCmd.RunQuery("ApplyDecimalPoint")
>
R> un-time Error 3075
F> unction is not available in expressions in query expression
> IIf([CLAIMSDUMP]![Char_Amount]<>0,(Mid([CLAIMSDUMP]![Char_Amount],1,Len
(> [CLAIMSDUMP]![Char_Amount])-2) & "." & Right([CLAIMSDUMP]!
[> Char_Amount],2)),0)
> This expression is executed on the entire table on the "Char_Amount"
field.
W> hen I try to execute this query via code ( or apply it via the "!" in
the
t> oolbar ), I get this error pop.
> I've tried to repair my Office 2000 installation, and nothing seems to
h> elp. Does anyone have an idea of where this error emanates from, and
what
I> can do to correct it ?
> As always, any and all suggestions, will be greatly appreciated.
> Marcelo R. Lopez, Jr.
Message #3 by "Marcelo R. Lopez, Jr." <mis@p...> on Tue, 20 Aug 2002 00:30:26
|
|
I'm sorry for using up so much space...but before someone chastizes me
about my code....I caught a mistype on my part, even though the underlying
issue remains the same. Thanks...Marcelo
>
> When I'm trying to execute an update query:
> DoCmd.RunQuery("ApplyDecimalPoint")
Should read:
DoCmd.OpenQuery("ApplyDecimalPoint")
Message #4 by "Amy Wyatt" <amyw@c...> on Tue, 20 Aug 2002 14:23:35
|
|
First I am assuming that Char_Amount is text and if it is, this would be
the easier way to update it. The SQL is as follows:
UPDATE CLAIMSDUMP Info SET CLAIMSDUMP.Char_Amount = Format(Val
([CLAIMSDUMP]![Char_Amount])*0.01,'#.00')
WHERE (((tblLabelInfo.Char_Amount)<>'0'))
If Char_Amount is a number then you can just multiply it by .01 to move
the decimal.
Hope this helps.
Amy
>
> When I'm trying to execute an update query:
> DoCmd.RunQuery("ApplyDecimalPoint")
>
R> un-time Error 3075
F> unction is not available in expressions in query expression
> IIf([CLAIMSDUMP]![Char_Amount]<>0,(Mid([CLAIMSDUMP]![Char_Amount],1,Len
(> [CLAIMSDUMP]![Char_Amount])-2) & "." & Right([CLAIMSDUMP]!
[> Char_Amount],2)),0)
> This expression is executed on the entire table on the "Char_Amount"
field.
W> hen I try to execute this query via code ( or apply it via the "!" in
the
t> oolbar ), I get this error pop.
> I've tried to repair my Office 2000 installation, and nothing seems to
h> elp. Does anyone have an idea of where this error emanates from, and
what
I> can do to correct it ?
> As always, any and all suggestions, will be greatly appreciated.
> Marcelo R. Lopez, Jr.
|
|
|
View Cart
