zip code formatting
The problem is the dash is on the field of the 5 digit zips. So the shortest zip is 6 characters. When putting the data on reports we do not want the dash to show on the 5 digit zips. But do want it do show on the 9 digit zips.
I am not sure how to code that. I am thinking I need a new field that is created from the original and drop the dash some how
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The field that has the zip + 4 is titled Receiver Zip. The field with the 5 digit is Zip 5. I tried using an update query but it didn't work.
For the City, it looks to zip.column(1) and state looks to zip.column(2). After updating the Zip Code field, the City updates automatically, but the State does not.
If the Canadian postal code is filled I would like to skip over the US zip code automatically. Can this be done without writing code?
Also, I need the bottom 10% to sum the discharges and be represented in the last row instead of individual zip at that point.
With the Return feature, it seems to only be able to return the top 55%.
when I test 60% it returns all the records, because there are a lot of 1 counts for zip codes at the bottom. I suppose some sort of top-down cumulative count is needed and if expression to denote the zip codes.
One particular aspect that is needed is to include the last zip code in the top 80% to be the first one crossing into the second range. (Soif the cumulative fourth zip code is top 76% and the fifth adds 8%, it is still included in Top80%).
This is what I have so far.
DoCmd.DeleteObject acQuery, [Zip]
But the program name that I am referencing is on the form, and I want to delete any query that is associated with that zip. The query will definitely have the zip in the name, but it may begin with query_, qry_, Q_, zip_Query, etc.
Is there a wildcard that I could use to isolate the zip from my form, regardless of what comes before or after it on the query?
Street Address City St Zip
Nothing is standardized accept the order. There could be a comma between city and state and there may or may not be a space between the state and zip. The zip also varies in size (#####, #####-####, or #########). Sometimes the zip is not there at all. I am looking for a way to identify the State or at least the position that is starts at. Any help would be awesome
DLookUp("[City]","[Zip Codes]","[Zip Code] =" & [Forms]![CompanyInfo]![Zip Code])
When I use the form and it enters the city field, I keep getting an error 2950. The database is trusted so that should not be the problem.
As a side note, each patient has several addresses, so I would like the zip code finder to impute cities for each address.