We just converted to SQL Server 8. Very new at this. When running in Access everyting work great, but when the migration took place I had to re write some of my querries. The one below is one that I can't figure out to make it work.

In Access it was running from a lookup field. Any ideas. I hope I gave you enough information.

Below is the code that is running. In the Close Out Items, I am getting the ID number only. not the text.

SELECT [QryClosedChklist Const].[Close Out Items], [QryClosedChklist Const].ChkBxPT, [QryClosedChklist Const].ChkBxCOR, [QryClosedChklist Const].ChkBxCS, [QryClosedChklist Const].ChkBxCO, [QryClosedChklist Const].ChkBxNA, [QryClosedChklist Const].date, [QryClosedChklist Const].Chk_id, [QryClosedChklist Const].ChkBxPM
FROM [QryClosedChklist Const];


Once again thanks

Sounds like you maybe using Table level lookups?

See: The Evils of Lookup Fields in Tables (Click Here) (http://www.mvps.org/access/lookupfields.htm)


You will have to add the lookup table to the query and join the Close Out Items tot eh lookup table and add the field from the lookup table you want. Have you tried that yet?

Coach, you hit it right on the nail. Finding out what works great in Access, does not work when migrating to SQL. This stuff just comes back and bite you right in the butt.

Thanks Coach