Running two SQL Statements

[jo15765]

I have one query, where I added the leading "0's" and the SQL statement I used to do this was:

SELECT =Format([SKP B],"00000") AS Expr1
FROM Sheet1;

Then from this query, I want to combine the SKP B (with the leading zero's) and SKP A into one row in Access, and use the following SQL statement to do that:



SELECT [Field1] & "-" & [Field2] AS Field1_Field2
FROM Sheet1;

The problem that I run into is that when I run the 2nd SQL statement the leading "O's" are dropped.

I know that you can do this in two separate queries but I would much rather do it in one if that is possible.
So my question is, is there a way to run two SQL statements in one query?
OR is there a way for me to combine both of these statements into one SQL query?

[HiTechCoach]

SELECT [Field1] & "-" & [Field2] AS Field1_Field2
FROM Sheet1;

The problem that I run into is that when I run the 2nd SQL statement the leading "O's" are dropped.

You are not telling it to add the leading zeros:

Try:
SELECT Format([Field1],"00000")[Field1] & "-" & Format([Field1],"00000")[Field2] AS Field1_Field2
FROM Sheet1;

[jo15765]

When I try this code, I get a syntax error (missing operator)

[HiTechCoach]

Try:

 
SELECT Format([Field1],"00000") & "-" & Format([Field2],"00000")[Field2] AS Field1_Field2
FROM Sheet1;