List

[leecsone]

HI


How can I set-up a report to give me a list of names like smith from out of a hundred different names.

Think You
leecsone
leecs@northrock.bm

 

[dcx693]

Base your report on a query that has the name field with a criteria like this:
Like "smith*"

That will find all instances of smith, smithson, smithfield, etc...

If you want to also catch instances of goldsmith, etc.... use this:
Like "*smith*"

 

[mark curtis]

Put the fields in the query and in the criteria under the surname field type smith abd it will return all with a surname of smith. Look up the Like statement and also criteria in expressions.

 

[leecsone]

list

HI
Ok that seems to work. But I would like to know how to find any name and see the entire same name Like Eddie, Mick, or Smith appear in a group. It don’t seem likely to Wright Like "smith*" to see any name I wont. Can this be done, or am I asking the imposable.


This might be the same kind of question, but is their a way to see different items in a report. I have switches for the user to tick. Is there away to see from a report the switches that are ticked and the ones that are not ticked. The switches are for to buy a hardback book or to buy a soft back Book. Some users might tick both some will tick one. Can you help me with this.



Thank You
leecsone
leecs@northrock.bm

 

[jfgambit]

If you add the following to the criteria of the Name in the Query you will be prompted to input a name:

Like "*" & [What is Name?] & "*"

If you enter "mit" in the prompt all records the following records would apear:

Smith
Smithers
Emitt
Mitton
Carmiton

Of course, i am making some of these up....

 

[leecsone]

list

HI

You have made me happy thanks.

Now about my second question. I have six first and last names with six check boxes. Three of the names and check boxes are ticked,and three are not. How can I see a report to just show me names and check boxes that are ticked and not the check boxes that are not ticked.


Thank you
leecsone
leecs@northrock.bm

 

[leecsone]

LIST

HI


I have six first and last names with six check boxes. Three of the names and check boxes are ticked,and three are not. How can I get a report to just show me names and check boxes that are ticked and not the check boxes that are not ticked.



LEECSONE
leecs@northrock.bm

 

[doss]

Create a query with your fields from you table. Under the field for the checkbox where is says "Criteria" type True to show items checked or False to show items not checked. Use this query as the source for your report.

There is alot of information on setting criteria for queries in the MS Help files.....