The Student Room Group
Uni students - Complete our survey >>
Uni students - Complete our survey >>
Uni students - Complete our survey >>

This discussion is now closed.

Check out other Related discussions

Need Help Urgently!!! Plz Look!

i need help from anyone that knows something about Microsoft Access.

1.) Need to know how to search a field(text) for a word, this word needs to be typed in by a user, so then i can show it on a report?
[i think i need to type in some code into the criteria place in a query..but not sure what code]

Im doin coursework, task1 OCR AS Computing. DUE tomorrow! :eek:
2.) This Q can only b answered by some1 doing or done the c/w so dont worry about this 1 too much.
i need to know what to type into the Cutting Keyword Table...do i just make up a keyword and link it with the corresponding cutting ID from the cutting table?

Thanks The DUMB Smart Guy
Reply 1
Avatar for gnpatterson
gnpatterson
Step 1 is to create a parameter query with the criteria

like "*" & [Word to search for] & "*"

Step 2 create report based on query
Reply 2
Avatar for DumbSmartGuy
DumbSmartGuy
OP
Thanks gnapatterson. Ill defiently try that today!

In the CuttingKeyword Table do you know what to write in the table which the query is based on? i know how to make the query and report but just dont know if i type in the keyword and the cuttingID that the keyword is in. but i think ill just try a few things and it might work.

Thanks for all the help.:wink:
Reply 3
Avatar for gnpatterson
gnpatterson
Sorry I do not have the problem you are talking about, if you post links or files I can look at them and tell you.
Reply 4
Avatar for DumbSmartGuy
DumbSmartGuy
OP
Thanks everyone you were a great help!
i got it working properly, figured out what to type in so thanks again :biggrin:
:tsr2:

Related discussions

Latest

Trending

Trending

Articles for you