make table query

[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.

 

[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.

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.

 

[Sam]

Your solution worked ! thanks for the help.