Expression Builder question...

[lgalumbres]

I created a make table query that joins two tables together in relation to account numbers. The query works perfect except for one of the fields. When the query is ran... it will ask to enter a parameter... which is in text format. When the query is finished the table is created. The field where it ask to enter a parameter should be in text format... but intead it gets created in binary format. I need it in text format because the application im exporting that table to does not read binary.. I know I can go to the design view on that table and change the field to text but I dont want to be doing that everytime I run the query... Any suggestions?

 

[The_Doc_Man]

First question: Did you WANT it to ask for a parameter in the first place?

If NOT, then the problem is that the spelling is wrong on one of the fields in your query.

 

[lgalumbres]

yes i wanted it to ask for a parameter... its wierd because i rewrote the query in 97 access the same way i did for 2000 access and that field comes out as a text field... but in 2000 access it comes out as binary... I want it to be in access 2000 because all the desktop in our department runs access 2000 and other people need to run that query....

Ive also tried converting it from 97 to 2000 and it still does not work... I might just have to find another way to query the data....