Forum home » Delegate support and help forum » Microsoft Access Training and help » access courses in london - Alpha-numeric fileds
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access courses in london - Alpha-numeric fileds
Resolved · Low Priority · Version Standard
Reply Wed 25 Jul 2007, 14:24Delegate Sandra said...
Sandra has attended:
Access Intermediate course
Alpha-numeric fileds
I'm trying to clean data that had no input mask. The variable is supposed to be surname but I have blank fields, number codes, alphanumeric codes and surnames.
Is there any query that I could do that could categorise these ie make a new field that states the type of surname entered?
If it can't be done in access can it be done in excel?
Thanks,
Sandra
For upcoming training course dates see: Pricing & availability
RE: alpha-numeric fileds
Hi Sandra
Could you post some examples of the data.
You can do a update query, once you have obtained the dataset that you want to categorise.
Add a new field to the table, can call it something like SurnameCategory
Once you have the basic SELECT query in place (ie. IS NULL for blanks), then change the query type to UPDATE. (you will find this next to the Red Exclaimation mark on the toolbar).
In the query you will need to have two fields:
The one that you are filtering (surname), and the one you will update (SurnameCatagory).
Simply specify what you want to update the SurnameCategory field to (ie: "BLANK"), and then click the RED EXCLAIMATION mark to run the Query.
I suggest that you backup or make a copy of your database before doing this, as the results are not reversable.
Let me know if this works out for you.
Regards
Richard
|