How can I store data as a negative number in Access?

C

Cookie

I need to store longitude as a negative number in Access 2002. I know how to
display it as a negative number, but the GIS database I am linking to does
not recognize it as a negative number.

My data type is number, field size is decimal, 5 digits to the side of the
decimal, input mask \-00.00000.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
What data type should I use to store latitude and longitude? 10
Copy previous record into form field 0
Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
Forcing data to be a negative number 2
Best Data Type for up to 12-digit Accuracy (up to 9 after dec poin 4
Number format issue Access 2007 2
how do i format the group totals in report to show thousands etc? 1

Top