Re: Ignoring Punctuation
Aaaack! One more thought ...
You could actually design an update query, using that function to "Find and
replace" all of the titles that had the quotation marks.
If you decide to do that, though ... please make a backup copy of your table
FIRST, so that I don't have to feel bad for telling you something that
results in disaster if it doesn't work correctly. :)
.
Relevant Pages
- Re: Database Design & Normalization Question
... Products, Other Titles, Title Types. ... However, oftentimes bad design will kill performance, no matter ... Normalization would dictate that these dates would depend on the KEY, ... > didn't have to change the database design to store new ...
(microsoft.public.sqlserver.server) - Re: How to prevent duplicate entries
... user has already saved the record once, that saving a second time would only ... run an Update query, ... and use the Edit method rather than the AddNew method. ... And design the properly normalized tables FIRST, ...
(microsoft.public.access.formscoding) - Arcade Novelties Feb 2009 Update - Pinball T-Shirts, Apparel & Gifts
... What's New In-Store ... titles and 16 Hot Selling titles so you can see "What's New" and ... Each of these classic pinball machines ... coasters and more featuring that design. ...
(rec.games.pinball) - Re: Update current record information to a separate record status reco
... Take a look at an Update Query in Access. ... My original design suggestion still holds. ... but creating a "summary record" in a separate table only introduces the ... of synchronization with what is contained in your "details" table. ...
(microsoft.public.access.forms) - Re: Separating Fields in Access
... Then create an update query that will update both fields ... Open the table in design view and delete the original TrackingNumber field. ... How are we to know which of the 7 characters goes where? ... I would like the "Traking Number" to be broken up into two fields ...
(microsoft.public.access.gettingstarted) |
|
