adhoc query facility

[cmowbray]

Hi I hope someone can help

I have created a parameter form (adhoc Crisp/Non-Crisp Committed Report) which is referenced from a query qry_Crisp/Non-Crisp Committed in the criteria field for two fields Prog Status and Position. On this form I have a button to reset the parameters, Open the query and run the report (rpt_Crisp/Non-Crisp Committed).

This works great no problems. However, the problem is that my users what to be able to enter more than one parameter in each text box on the form eg instead of UDP 08, they want to enter UDP 08 and UDP 03, etc...

Also how do I get this facility to work if only one of the text boxes has a parameter entered?

 

[jtvcs]

Worth a try if the user enters UDP08 or UDP03 (with the or as shown) your query should pick it up properly. Just a matter of training the user. HTH JT

 

[cmowbray]

HI jtvcs

Thanks for replying. I'm afraid I have tried that and it does not work. It will work if I type in UDP 08 in the prog status box and PC in the position box but it will not allow any more than one, it just returns no results.

Thanks Cathy

 

[jtvcs]

Cathy

Could you post the necessary objects. Maybe can identify a way around your problem. JT

 

[cmowbray]

Hi jtvcs

I am sorry I have not replied sooner but I have been on a course.

I have tried to attach a very cut down version of my database but it is still too large.

Do you have an email address and I can send it to you that way?

Any help you can provide on this matter would be gratefully appreciated.

Thanks Cathy

 

[jtvcs]

If still interested, send to vcs.jack@erols.com, preferably WinZipped JT

 

[st3ve]

You could try a construct something like this:-
SELECT [Customers].CustID
FROM [Customers]
WHERE ((([Customers].CustID) In ([ENTER CUST ID1],[ENTER CUST ID2],[ENTER CUST ID3]))); if you need more entries then just keep adding parameters. NB Parameters in the [brackets] must be different. I've used id1,id2 etc. If less entries needed then userswill just have to hit return to skip remaining entries. Not the whole story, i know, but this may get you started.