Re: Query to find just alpha chars?

"Rodney Wise" <NSpamPlease_rodney1@xxxxxxxxxxxxx> wrote in message
news:460d3438$1@xxxxxxxxxxxxxxxxxxxxxxxxxxx
Joe,

Using the Delete Query (as Steve has told you) is the best way to go.

However... be very careful... These items (with the Alpha characters) may
be linked to items in other tables. Once you delete them, the link is
broken and their children will be lost. (still exist, but not linked to
their parent item).

Unless you are absolutely "sure" that these items are NOT linked to other
items in other tables... I wouldn't simply delete them...

But if you do, I would recommend that you immediately rename the
"Answer.db" table which will be located in your Private directory to some
other name... such as "save.db" or something.... You may discover that
you'll need to add them back to their original table.

No links.


.

Relevant Pages

  • Re: Query to find just alpha chars?
    ... Using the Delete Query (as Steve has told you) is the best way to go. ... table which will be located in your Private directory to some other name... ... You may discover that you'll need to ...
    (comp.databases.paradox)
  • Re: query for multiple results
    ... SELECT yourFields from yourTable WHERE ... Steve D ... "Tom Ellison" wrote: ... When i run the query, the parameter query dialog box opens. ...
    (microsoft.public.access.queries)
  • Re: on input form showing error message for duplicate entry.
    ... Steve, If you know so much, why don't just help her?? ... check for duplicates. ... proceed with your insert query. ... form to have any sql statement on one line (my opinion). ...
    (alt.php)
  • Re: Halting a Repeating Macro on Not Found
    ... > Hi Kathy, ... > It was the Update Query using the Replacefunction that I was referring ... > Steve Schapel, Microsoft Access MVP ... >> Therefore, I feel this repeating macro solution is not the way to go, ...
    (microsoft.public.access.macros)
  • Re: filtering by month
    ... Steve S ... (I came; I saw; I stuck around.) ... Would you post the SQL of the query? ... you suggestion along with the criteria. ...
    (microsoft.public.access.queries)