Show only the 5 left most numbers in a zipcode field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Macro Repeat Expression using value of a field in table 0
Error message on left function 3
Left function query error 2
ZipCode AutoComplete 3
Using comma diliminated option in one parameter of query 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Retreive a Record in a query 2
show the most recent payment 5

Back
Top