If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Link table field format puzzle
I have one issue that doesn't make sense. Maybe some expert could help.
I have one table in MS SQL (2005), there are two fields. GrossCost Numeric(15,2) NetCost Numeric(15,2) When I did an ODBC link table inside MS Access XP, the format of the two fields are different. For example, GrossCost will show 16.00 and NetCost will show 16 I open the link table in design view and find out the GrossCost's [format] property are set to 'Fixed' while the NetCost's [format] property are blank. Why Access treat the two fields differently if they have exact the same format on SQL side? Anywhere I can setup on the MS SQL side to affect the [format] property on Access side? Thanks for any insights! |
Thread Tools | |
Display Modes | |
|
|