Query troubles

[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

 

[mvdrumaboy]

Sorry I didnt realise this was the forms section.

Apologies.

Please ignore this.

 

[Guest]

Left([FlightID],3) & Ucase(Left([Surname],3)) & Format(Right([PassID],3),"000")