G
Guest
Using the LIKE and [PROMPT] Features together.
====
I am currently designing a pretty standard database. It contains three
tables, a customer details, sales details and Product details.
I am currently creating a set of queries for my end user (This is for my
GCSE coursework) to use. I will be using them to find information regarding
certain criteria and using the outputs for mail merge.
I have been experimenting with using the [Prompt] Feature, whereby when I
run the query it asks me for the value to use. Eg. If I wanted to search my
customer data base and return all records that have a YES value in a
particular field, I can create a query which contains [Do the want to have a
garage?] and it will ask me if I wanted to display houses WITH or without a
garage.
This I am very happy using and am finding that it's much better to create a
dynamic query than one that returns answers to the same "question" each time.
I am also using the LIKE function to find something. Eg. If I have a field
where the whole address is stored, and I want to find houses that are in
RAMSEY, I can in the criteria for that field type:
Like "*Ram*" and it will return and records that have the three characters
in that order in my chosen field. this is also usefull.
I have tried combining to the two, with no success. I would like to create a
query that asks/prompts me for the Ram bit in the
Like "*Ram*"
But I can't work out a way of doing this. I've tried Like "[Please enter a
search]" but it doesn't seem to return any values, unless I type *ram* into
the prompt box.
If anyone could tell me of the appropraite way to carry this out, I would
much appreciate it.
Thank's for your time
Daniel
====
I am currently designing a pretty standard database. It contains three
tables, a customer details, sales details and Product details.
I am currently creating a set of queries for my end user (This is for my
GCSE coursework) to use. I will be using them to find information regarding
certain criteria and using the outputs for mail merge.
I have been experimenting with using the [Prompt] Feature, whereby when I
run the query it asks me for the value to use. Eg. If I wanted to search my
customer data base and return all records that have a YES value in a
particular field, I can create a query which contains [Do the want to have a
garage?] and it will ask me if I wanted to display houses WITH or without a
garage.
This I am very happy using and am finding that it's much better to create a
dynamic query than one that returns answers to the same "question" each time.
I am also using the LIKE function to find something. Eg. If I have a field
where the whole address is stored, and I want to find houses that are in
RAMSEY, I can in the criteria for that field type:
Like "*Ram*" and it will return and records that have the three characters
in that order in my chosen field. this is also usefull.
I have tried combining to the two, with no success. I would like to create a
query that asks/prompts me for the Ram bit in the
Like "*Ram*"
But I can't work out a way of doing this. I've tried Like "[Please enter a
search]" but it doesn't seem to return any values, unless I type *ram* into
the prompt box.
If anyone could tell me of the appropraite way to carry this out, I would
much appreciate it.
Thank's for your time
Daniel