Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Need Access database help
Now, there is a form that was created based on this table (and some others for the subforms) that the entry person enters info into, including that zip code.
Here is the problem: When I run a make-table query based on zip code (and other criteria), some of these zips show up without the dash...like this ....301612992. That, then, effects the sort ascending process.
When I look at the form, it shows the dash...when I look at the Members table it shows the dash...when I look at the table created from the query...the dash isn't there.
I have tried deleting the zip and re-entering it in a number of different ways but I get the same results. The strange thing is this is only so on a few of the records (@ 150 of them) and not ALL the records (@ 2000).
When I created the input mask I checked to save the dash.
I have tried everything I can think of and I am truly stumped. Does anybody have any ideas as to what could be causing this or how I could fix the problem? The worst part is I have a deadline on this!
Let me add that I can go into the table design (the table made from the query) and add the input mask and the dash is then there. However, this is not feasible because this query has to be run on a regular basis with the entry person entering criteria into a text box. This would be an item I would add to the menu for the end user. In other words, the entry person would not be able to or know how to update the input mask in the table created from the query. The entry person (end user) works strictly off the menu and does not do any programming.
Thanks in advance!