Beginner Question With Make-Table Query

  • Thread starter Thread starter dave!!
  • Start date Start date
D

dave!!

I have a make-table query which consists of all the fields of an existing
table plus an additional 10 columns. Each of the additional 10 columns has
a custom defined minimum function. The function works fine, except in the
table that gets produced everything is in text format. How can I get the
output in number format?
 
I have a make-table query which consists of all the fields of an existing
table plus an additional 10 columns. Each of the additional 10 columns has
a custom defined minimum function. The function works fine, except in the
table that gets produced everything is in text format. How can I get the
output in number format?
Click to expand...

One question:

WHY make a table?

You have a Query returning the correct data. That query can be used as
the recordsource for a form, for a report, for export, for mail merge
- pretty much anything except for editing your function values.

And you don't WANT your function values to be edited, do you? If
you're calculating a minimum from some other fields, that calculation
should simply be redone as needed; if you *store* the result, then
either the result or the fields upon which it is based can be edited,
causing our calculated values to be WRONG with no way to detect that
fact.

That warning said - wrap your calculation expression in a call to
CLng(), CCur() or some other conversion function to explicitly force
it to a Long Integer, Currency or other appropriate datatype.

John W. Vinson[MVP]
 
Back
Top