hey,
i have a library database, that stores keywords from each book - i was wondering if it is possible to search based on more than one keyword i.e. have the ms query parameter box prompt as many times as required (when the user enteres nothing - null - the box will stop prompting) - if that makes any sense.
For example, i want to search on keywords 'job' 'bus' 'house' 'man' 'dog'
so i am prompted for the first, i enter job, second i enter bus etc til i enter dog, i push enter then a 6th box comes up asking for my next keyword, i push enter leaving it null and the query is executed.
is there any way of doing this? please keep in mind i am new to access
cheers
i have a library database, that stores keywords from each book - i was wondering if it is possible to search based on more than one keyword i.e. have the ms query parameter box prompt as many times as required (when the user enteres nothing - null - the box will stop prompting) - if that makes any sense.
For example, i want to search on keywords 'job' 'bus' 'house' 'man' 'dog'
so i am prompted for the first, i enter job, second i enter bus etc til i enter dog, i push enter then a 6th box comes up asking for my next keyword, i push enter leaving it null and the query is executed.
is there any way of doing this? please keep in mind i am new to access
cheers
