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
>
>
>
Jumat, 23 September 2011
RE: [MS_AccessPros] Using criteria to exclude
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar