ACCESS FEED: RE: [MS_AccessPros] Using criteria to exclude

Sabtu, 24 September 2011

RE: [MS_AccessPros] Using criteria to exclude

It looks like you only want to return characters to the right of the space. Is that correct? If so, the Instr() function can return the character number of the space and Mid() can return a set of the characters beginning at a specific number of characters.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: robinski@mymail.net.au
Date: Sat, 24 Sep 2011 15:05:08 +1000
Subject: RE: [MS_AccessPros] Using criteria to exclude

Thanks Duane,

Any clues for me on the second problem?

Cheers,

Robin

At 24/09/2011 02:50 PM, you wrote:

>Change the OR to AND.
>
>Duane Hookom
>MS Access MVP
>To: MS_Access_Professionals@yahoogroups.com
>From: robinski@mymail.net.au
>Date: Sat, 24 Sep 2011 13:22:09 +1000
>Subject: [MS_AccessPros] Using criteria to exclude
>
>I have a statistical report from our server as a CSV file. I have it
>linked to my database
>
>I use this query to provide the data that I need:
>
>SELECT Downloads.File, Downloads.Visitors
>FROM Downloads
>WHERE (((Downloads.File) Not Like "*robot*")) OR (((Downloads.File)
>Not Like "*total*"));
>
>This page shows to end of the query in 'View":
>
><http://www.rotary9790.org.au/test/test.asp>http://www.rotary9790.org.au/test/test.asp
>
>
>i) Why are the 'robot' and 'total' showing? (robot is not in the image)
>
>ii) is there any way I can loose the domain from the description?
>
>May thanks,
>
>Robin Chapple
>
>
>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>