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