When I changed it to INT and go back to my old query, I get further than I did when it was varchar. The error I mentioned above went...

Sorry it took so long to respond! I tried the following:

strSQLStmt = "SELECT rptSupportJobsExtendedOptions.*, tblSupport.FirstName, tblSupport.LastName" & _

...

Alright, I've figured out how to pass the variable, but I can't grab the variable from the combo box on the form for some reason. Any help is appreciated....

Never mind. I just modified my reports to use the new names. Thanks for all the help!

When I use this format and change all of the names of tables to match the Alias, the Syntax Check is successful, but it does not rename the expressions in...

Do I have the alias in the correct spot to rename the Exprxxxx as the column heading for the joined column?

I GOT IT WORKING! THANKS FOR YOUR HELP!!!

Oops, forgot that. Now it gives the attached error.

OK, now I'm running the following and getting a similar error:

CREATE PROCEDURE usp_rptOpenTicketsByYard

AS

SELECT tblTickets.*, tblTicketStatus.status, tblTicketPriority.priority, tblCallTypeSub.Description, tblTicketCallTypes.CallType, tblUsers.First_Name, tblUsers.Last_Name, tblYardInfo.YardName, tblTickets.CreatedOn, tblTickets.Yard, tblTicketPriority.PriorityStatus,

CASE

WHEN tbltickets.ProjectTicketOption = 0

THEN 'Ticket'

ELSE 'Project'

END

FROM tblTickets...

Also, I'm looking to create an alias for my "CASE" statement, but I can't seem to get it to pass the Syntax Checker. I swear I look all over...

My joins worked when I left them in the SQL from the Access query and escaped "user", but when I tried to create aliases, I had a lot of trouble,...

Thank you guys for all your help! I've gotten the query working so far, but I'm trying to figure out Aliasing on Joins. I can't seem to find...

PS- This query will be a part of a stored procedure.