Whoa! SQL Advice needed 1

[nat1967]

HI everyone,

I have hit an interesting problem. I hope someone has run into it before and can offer a suggestion.

IT has set up two databases which share information. I need to pull a query with an Inner Join between the two databases.

The inner join fields are FormID and ObjID. For the life of me I couldnt figure out why I couldnt get my query to work. that is until..... i figured out IT setup one of the databases with a text field and the other with a double.

Needless to say, I cant create a join on these two fields or I get data mismatch. Go figure...

Since I dont own the databases (IT does), I cant make the field changes needed to make this query work.

If I import the queries into new tables in my A2K database, I can change the fields to the same type and the queries work fine.

Does anyone have any suggestions or ways to work around this problem without manually importing and changing tables? The only fields that "match up" are FormID (text field) and ObjID (double integer).

TIA

Have A Great Day!!!,

Nathan
Senior Test Lead

 

[jrbarnett]

Changing the data type of the field will obviously be faster and the preferred method but on the text field, use CDbl(Fieldname) to produce a double version of the value.

John

 

[nat1967]

John,

THANK YOU!!!!!!!!!!!!!!! I wish I could give you more than one star.

"You have chosen to recognize jrbarnett for a helpful or expert post! Thanks for letting jrbarnett know their post was helpful."

You deserve it!!!





Have A Great Day!!!,

Nathan
Senior Test Lead