Query troubles

M

mvdrumaboy

I am trying to build a query that uses the following to generate the
query:

UniqueID: Left([FlightID],3) & Left([Surname],3) & Right([PassID],3)

Which generates an output like "773wat1"

I would like to know how I can make the 'wat' into caps ('WAT) and how
I can force the '1' to become "001"

Your help is most appreciated
 
M

mvdrumaboy

Sorry I didnt realise this was the forms section.

Apologies.

Please ignore this.
 
Top