ACCESS FEED: RE: [MS_AccessPros] UNION query "Too Complex"

Selasa, 01 November 2011

RE: [MS_AccessPros] UNION query "Too Complex"

Duane,

Many thanks for the step by step instructions. They were needed. I
have achieved the first step!

At 1/11/2011 09:44 AM, you wrote:

>I would create a table with fields like:
>
>tblWebFolders
>==================
>FolderName text for values like au/clubs/atoc/albury...
>FolderTitle text for values like "Albury"

tblWebFolders
FolderName FolderTitle
au/clubs/atoc/Albury/ Albury
au/clubs/atoc/Albury Hume/ Albury Hume
au/clubs/atoc/Albury North/ Albury North
au/clubs/atoc/Albury West/ Albury West
au/clubs/atoc/Alexandra/ Alexandra
au/clubs/atoc/Appin Park Wangaratta/ Appin Park Wangaratta
au/clubs/atoc/Beechworth/ Beechworth
au/clubs/atoc/Bellbridge Lake Hume/ Bellbridge Lake Hume
au/clubs/atoc/Belvoir Wodonga/ Belvoir Wodonga
au/clubs/atoc/Benalla/ Benalla
au/clubs/atoc/Bright/ Bright

>Then create a query with qStatsYTD and tblWebFolders. Set the
>criteria under Page to:
> Like "*" & Foldername & "*"

At this stage I failed.

SELECT qStatsYTD.Page, qStatsYTD.Visitors
FROM qStatsYTD, tblWebFolders
WHERE (((qStatsYTD.Page) Like "*" & "Foldername" & "*"));

produces no records.

What have I missed?

Regards,.

Robin Chapple