convert number to text

[Guest]

I am building a query from two tables. Of the two joining fields one is text
type and the other is number type. How can I create a join bewtween these
two fields. I need to change the number field to a text field temporarily
witin the query. I can't do this the other way around because my text field
contains leter as well as numbers. Any suggestions?

 

[Douglas J. Steele]

You can use the CStr function or the Format function.

 

[Guest]

I tried that and it didn't work. Discovered that I missed my brackets off.
Works now. Thanks

 

[Guest]

As an extra question, is it possible to use the CStr function so that instead
of using (Data.[Control Number])=CStr([Images].[id]) ,it would use a "like"
and wildcard rather then equals.

 

[Douglas J. Steele]

Data.[Control Number]) LIKE & "*" & CStr([Images].[id]) & "*"

If you're creating the SQL as text in VBA, be careful with your quotes!

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

As an extra question, is it possible to use the CStr function so that
instead
of using (Data.[Control Number])=CStr([Images].[id]) ,it would use a
"like"
and wildcard rather then equals.

You can use the CStr function or the Format function.