5 days into a report i cannot create!

aeckart

New member
Local time
Today, 05:05
Joined
Jan 29, 2004
Messages
5
I have created a form in which I have dissected magazine articles and ads by color, page number, publication, issue, etc.
I want to create a form in which all I have to do is pick from a drop down list one advertiser at a time, and see all of the other above noted information. I want to type in "Panasonic" for example and have all the information I need to know about Panasonic just 'pop-up'!
Can anyone, help me here?
Thanks so much!
 
How about using a Like "Panasonic" criterion for the target field in a query that is fed by the table containing the words of the articles?
 
still nothing

that will work, but than i have to build a million querries for all the advertisers.
 
You then can set up a parameter in the criterion:

Like "*" & [Who is the advertiser?] & "*"
 

Users who are viewing this thread

Back
Top Bottom