RE: [MS_AccessPros] Using criteria to exclude

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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/