Query forms

[shapman]

Hi

I need to set up some sort of query form that allows a user to search for contacts from certain sectors and with certain interests to make a list of email address for a mailing which then transfer into groupwise... I'm struggling to work out how this is done...

greatly appreciate any help with this!

Thanks

 

[Dennisk]

It all depends on how user friendly you want it. You can start by creating a select query using the QBE. Add the table to top half of the query. Add the fields you want to see in the grid then specify your criteria.

If you want the user to enter the criteria at runtime then in the criteria cell for the column you wish to filter add

=[Your text prompt]

When you run the query a dialog box will be displayed with your prompt.

 

[shapman]

thanks Dennisk

its got to be very user friendly, what i have at the moment is approximately 20 yes/no check fields (each relate to a publication). When a contact is entered the publications they wish to receive are ticked off. I need to create a highly user friendly form for mail outs that lets th user check the boxes of the publication(s) they want to send and then this searches for a produces the names and email address of the contacts that want that specific publication (s)

This is proving a far more difficult task then i first imagined

Any ideas?

Thanks in advance