• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

Access Query

This is just weird.

Look at the two images attached. When I put a description in a field with a number after it I can set the field to Fixed. If I take the number out of the end of the column description it assumes it's a text field and won't let me set as a number field. In Data view the second example formats to the left and with a number in the description it formats to the right.

This cannot be normal. Is it corrupt?
Capture.JPG
Capture2.JPG
0
DatabaseDek
Asked:
DatabaseDek
1 Solution
 
Dale FyeCommented:
Use of the NZ( ) function will return a string, no matter what you do.  if you want this value to be a number, you need to use the Val(NZ(..., 0)) or any of the explicit type conversion functions (cint, clng, cdbl ) to convert it to a numeric value.
0
 
MINDSUPERBCommented:
I may recommend to close the query and save the changes you made. Then, open it and try to remove the numbers. You may delete those spaces as well in between the colon sign ":" and the Nz.
0
 
DatabaseDekAuthor Commented:
Thank you!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now