Hello All,

To explain my table setup better, here's what I have.

tblFunctions: (2 fields)
- FunctionID(AutoNumber)
- FunctionType

For Example:
FunctionID(AutoNumber) = 01
FunctionType = This is a test

Query:
qryfunctions:
THis works:
Criteria: "01"

THis Doesn't
Criteria: "This is a test"


How do I use the FunctionType as the criteria rather than the FunctionID?

Thank you,

The criteria needs to be under the correct field.

The criteria needs to be under the correct field.

Bob,

I forgot to mention. I actually have another table called tblActivities.

tblactivities has FunctionsID and this is connected to the FunctionsID in tblFunctions.

My query is based on tblactivities since I want to query other results other than the functions type.

I did, however, try adding the tblfunctions in the query and dragging tblFunctionstype but it was showing all functions in the tblfunctions rather than just the once with the entry.

Not sure if that made sense?

sample of the database can be found here:
here (http://www.access-programmers.co.uk/forums/showthread.php?t=146281)

Thanks

http://downloads.btabdevelopment.com/screenshots/12a.png

http://downloads.btabdevelopment.com/screenshots/12b.png

http://downloads.btabdevelopment.com/screenshots/12a.png

http://downloads.btabdevelopment.com/screenshots/12b.png

Thank you! :D:D as always, it worked!

http://downloads.btabdevelopment.com/AWF/GladWeCouldHelp.png