cbyte() returns integer

  • Thread starter Thread starter bronson
  • Start date Start date
B

bronson

Hi,

I'm using a make-table query to create a table used as data source for a
report. In order to ensure the data types are correct, I use convert
functions in the make-table query. However, the data types in the created
table weren't what they were supposed to be. For example, I only got integers
where I used cbyte(), even though I couldn't figure out a single conversion
type error nor range violation (all values between 0 and 255). This problem
was encountered using Access 2003. Any thoughts on this anyone?

Thanks!

Bronson
 
Create a table with the data types you want.
Then use an Append query to populate it.
That's the only way to guarantee you get the table set up the way you want,
with the correct properties set on the fields (e.g. AllowZeroLength.)
 
You must log in or register to reply here.

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

Access 2002 Append Query Problems 1
Make Table Query Truncating Memo Field at 255 Characters 2
Save Bitmap 1
Convert a Number data type to Text using a query 3
Running into error while writing Append Query 2
Split data in field on character return 0
Query field size quandry 2
Using a combo box as a criteria for a query 1

Back
Top