B
Bongard
I am having problems with some append queries that I have adding data
to a table. The append queries when run on their own will work just
fine. However, I have a macro that runs about 10 of the append queries
together and whenever I run the macro I get the "Numeric field
overlfow" message on the first query in the macro. I have tried
rounding some of the fields before adding them to the table but that
doesn't seem to work. I have also created test macros containing just
one append query and that doesn't work either. I don't understand why
these append queries would work if run by themselves but no as part of
a macro. Also I used to have the field types in the destination table
as number-double. I then tried currency but that didn't seem to change
anything.
Any help would be much appreciated.
Thanks,
brian
to a table. The append queries when run on their own will work just
fine. However, I have a macro that runs about 10 of the append queries
together and whenever I run the macro I get the "Numeric field
overlfow" message on the first query in the macro. I have tried
rounding some of the fields before adding them to the table but that
doesn't seem to work. I have also created test macros containing just
one append query and that doesn't work either. I don't understand why
these append queries would work if run by themselves but no as part of
a macro. Also I used to have the field types in the destination table
as number-double. I then tried currency but that didn't seem to change
anything.
Any help would be much appreciated.
Thanks,
brian