Show only the 5 left most numbers in a zipcode field

F

fgwiii

I not only need the syntax, but I also need to know where to enter the
syntax. Can it be done in the grid view of a query? Or, must I enter it
elsewhere? Exactly where does this need to be entered?

Thank you,

Fred
 
R

Rick B

Where do you want to show it?

If you want to show it in a query, add a new column to your query with...

Left5ZIP: Left([ZIP],5)


To do it in a report or form, add a new unbound text box and enter the
following in it...

=Left([ZIP],5)
 
K

KARL DEWEY

Can it be done in the grid view of a query?
That is where you do it. Add a column by entering this in a blank field row
of the grid --
ZIP: Left([YourZipCodeFieldName],5)
 
Top