Formatting in Access

[Buckeye342]

I need to know if I can get Access to round numbers/currancy to the nearest
nickle? Also, I have put these formulas into Excel and they work fine but
when I import the excel spreadsheet into Access the formulas are lost, Can I
get Excel spreadsheets into Access with the formulas intact?

 

[Allen Browne]

See:
http://allenbrowne.com/round.html#Round5c

Access tables cannot contain formulas like Excel spreadsheets. In Access,
the calculation formulae go into queries. Here's a basic explanation:
Calculated Fields
at:
http://allenbrowne.com/casu-14.html