Query parameters held in separate table

[PD]

Greetings,

I am writing queries to look for keywords. I would like to have the keyword
criteria held in a keyword table to make it easier to update, find
duplicates, share, etc. I tried a couple of different ways but could not
make it work.

Any ideas?

 

[Klatuu]

Have you tried using a subquery based on the keyword table:
SELECT SomeField FROM MyTable WHERE SomeField IN (SELECT keyword FROM
keywordtable);

 

[piper]

Hi Klatuu,

I have a simliar problem, in that I have a table with about 15 "Categories"

I have set up a query to obtain the information I need from my "tbl
Inspections"

I have a report with is produced from that query.

What I want o try and do is when I click on the report name on my
switchboard the parameter box appears with a drop down list containing the 15
Categories for the user to choose which one they want, when they choose the
category it produced the report with only that category can you advise in
very basic step by step instructions if and how I could do this.

Your help would be very much appreciated

Yours Aye

Bruce

 

[Lord Kelvan]

heh default paramater queries cannot do that but you could try
building a custom one here is a link it is nice and long so have fun
reading it

http://www.fontstuff.com/access/acctut08.htm

 

[piper]

Thanks for that I have managed to complete it. My next problemn is how do I
add this to a switchboard so that it runs or produces a report? Any help
would be vey much appreciated

Yours Aye

Bruce

 

[Lord Kelvan]

try asking in the forms group as far as i knwo you do somethign like
docmd.openform "formname" but i am most likly wrong i dont work with
alot of forms

 

[piper]

thanks, I will play around with it.

Once again thank you for all your help

Yours Aye

Bruce