Type mismatch in expression

[CharlotteR]

i keep getting the message "Type mismatch in expression" whenever i create a query, either through the wizard or manually. its on a simple select query.

any ideas?

CharlotteR

 

[dodge20]

Do your datatypes match between tables? Make sure you don't have a date with a text, or something like that.

Dodge20

 

[lespaul]

What is the query you are trying to write?

Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

 

[CharlotteR]

i want a query to produce all the different passwords throughout the database - FTP Username & Password, Email sername & Password, Dial In Username & Password.

ive made sure they are all Text, but its still yelling at me! grrrr!

CharlotteR

 

[lespaul]

Again, what is the query (SELECT Password1, username1 from somewhere) etc.