make table query

S

Sam

when the query creates the table it makes the data type of my expr1: field to
binary and I can't export it like that i need a text field to create bar
codes. Any help out there.
 
J

John W. Vinson

when the query creates the table it makes the data type of my expr1: field to
binary and I can't export it like that i need a text field to create bar
codes. Any help out there.
Click to expand...

Why use a maketable query AT ALL? They're very rarely necessary or
appropriate. You can export from a Query just exactly as easily as from a
Table; just use a Table including the fields and records that you want to
export.
 

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

Split data in field on character return 0
Creating :Null field in Make Table Query 1
Make table query: [Enter 1] AS Test 1
New Field Data Type Question 3
Make-table query with around 2 ml records taking too long 0
extra field for a table as Text from table qry ? 5
Populate a field in a query with the value of record 4
Binary field won't take dates 10

Top