Re: Tim F, Please help with address query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Iwilfix (iwilfix_at_monmouth.com)
Date: 02/06/04 

Date: Fri, 06 Feb 2004 08:22:39 -0500

Steve

Thank you for your simple instructions.
As I followed them, it turns out that I did
do exactly what Cheryl had instucted me to do previous.
but syntax errors kept appearing and i was just getting frustrated.
As I explained to Cheryl, when I clicked down to he column.
the table name was entered in its box, and thats where
the problem was of course.(only tookme 2 hours to figure out)
But now it works perfectly.
Thank you so much.
                                Jeff V.
( and I did of course thank Cheryl as well )

On Fri, 06 Feb 2004 17:47:47 +1300, Steve Schapel
<schapel@mvps.org.ns> wrote:

>Jeff,
>
>Hope you don't mind a non-Tim jumping in here. Personally I don't think
>I or Tim could explain it better than Cheryl did in your earlier thread
>on this question. But anyway, try this...
>
>1. Make a new query based on your table.
>2. Put the Address field in the first column of the query design grid.
>3. In the Field row of the next column of the query design grid, type
>the following...
>StreetName: Mid([MyAddressField],InStr([MyAddressField]," ")+1)
>4. In the Sort row of this column, select Ascending.
>5. In the Show row of this column, untick the checkbox.
>6. Run the query.
>7. Post back here and announce your success.
>8. Post back in the other thread and say thank you to Cheryl :-)
>
>As mentioned by Cheryl, this assumes that *all* entries in you Address
>field follow the pattern: number-space-street.

Relevant Pages

  • Re: Tim F, Please help with address query
    ... Hope you don't mind a non-Tim jumping in here. ... I or Tim could explain it better than Cheryl did in your earlier thread ... Put the Address field in the first column of the query design grid. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Tim F, Please help with address query
    ... but did Tim have a thread going on this ... Cheryl Fischer, MVP Microsoft Access ... "Steve Schapel" wrote in message ... Put the Address field in the first column of the query design grid. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Proposed 2006 ASP Zippo Extra
    ... > Cheryl, if I understand it correctly, you are the ... >amount and who to make the check out to as ... you'll find the easy instructions on how to get one. ... Bert Olton, the guy who started this thread, is the person who ...
    (alt.smokers.pipes)
  • Re: Good Directions was - Kims LeMoyne Star directions are great
    ... I would follow your instructions without hesitation Patti! ... Cheryl & the Cats ... This makes me *very* nervous, Cheryl. ... :>does not make a good quilter, ...
    (rec.crafts.textiles.quilting)
  • OT Manx Quilting was Re: Victory!
    ... have class notes and instructions that I am happy to pass ... : Thanks for sharing that Cheryl:) This was new to me. ...
    (rec.crafts.textiles.yarn)