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?