|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 19th, 2004, 02:59 AM
|
|||
|
|||
# character in queries
I need to edit mailing lists which contain # characters in their address
fields (e.g., 123 Easy St #567). The problem is # is a wild character. How can I write an expression to find records with #000 elements in them? 
|
|
#2
August 19th, 2004, 03:29 AM
|
|||
|
|||
|
Surround the # character with [ ] characters:
[#]000 -- Ken Snell MS ACCESS MVP "Hal Pratt" wrote in message ... I need to edit mailing lists which contain # characters in their address fields (e.g., 123 Easy St #567). The problem is # is a wild character. How can I write an expression to find records with #000 elements in them?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Slow queries | Michael S. Montoya | Running & Setting Up Queries | 2 | July 23rd, 2004 04:37 AM |
| Adding colored font to queries | wbfuga | Running & Setting Up Queries | 2 | July 15th, 2004 02:33 AM |
| Imported Queries & Field Names - Attn S.Clark MVP | Bruce | Running & Setting Up Queries | 3 | June 14th, 2004 12:14 PM |
| Queries in a Dropdown | Graham R Seach | General Discussion | 0 | June 4th, 2004 12:15 AM |
| Exporting Multiple Queries to 1 Excel Workbook with VBA | Anthony | Running & Setting Up Queries | 2 | June 3rd, 2004 07:59 PM |
Linear Mode
