I have a 'make-table' query in which I have several calculated IIf expressions. I need the resulting fields in the table to be formatted as number fields rather than text - so that I can add the fields together in a report. For some reason I can't seem to achieve this...it's driving me mad!!
Can anyone help?
Many thanks.
Can anyone help?
Many thanks.