same name calculated fields

  • Thread starter Thread starter mate
  • Start date Start date
M

mate

I have a query with multiple tables. Two of the tables
are: Shipper and Recipient

Both of these tables contain a ZipCode Field. I want to
be able to use the following calculated field:
Left([zipcode],5) for both zipcode fields but because of
the same name i run into trouble. Is there any way to
make this work without renaming one of the zipcode
fields? Any help is much appreciated as always. Thanks,
mate.
 
Back
Top