Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Currency field type

Status
Not open for further replies.
BasicBoy

BasicBoy

Programmer
Feb 22, 2008
156
ZA
A table in my Access database has a few fields which are formatted as currency. This field type is only called Currency in Access.
However, when I do a query of this table, the field type returned with DAO is the number 4 (dbLong) and not the number 5 (dbCurrency)
How could that be?
Thanks
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
339
strongm
strongm
JayRo71
  • Locked
  • Question
Unable to sort date field
Replies
4
Views
135
JayRo71
JayRo71
mhshane
  • Locked
  • Question
Query to find keywords in description field and give count
Replies
4
Views
134
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Find records containing another field value 1
Replies
9
Views
172
Andrzejek
Andrzejek
supportsvc
  • Locked
  • Question
How to limit the number of records based on the quantity in a field? 1
Replies
8
Views
198
supportsvc
supportsvc

Part and Inventory Search

Sponsor

Back
Top