Question Filter a sub string value

[amerifax]

I figured it out, I found the Linked Table Manager. I am going to look at everything and I'll let you know if I have any questions.

Regardless we thank you so much. This takes us one step closer in our change over to Access. That substr command in dbase is something we use daily so understanding it in Access is obviously very important for us!

Thanks so much again!

Bob

 

[amerifax]

OK , I have one more thing...again I can't thank you enough for your help. That really does give us the basis more most of what we will do in Access.

How would I add a command to the query using the per_date field for...

1. per_date month equal to November or 11
2. per_date month equal to November or 11 and Year equal to 2010
3. per_date month equal to November or 11 and Year equal to 2000-2009

What is the best way to do these, if possible?

Bob

PS
This is the SQL with a change we added in case it would be easier to just add to this format.

SELECT Left([SC],2) AS SCLink, PERMITA.*, PERMITA.SQ_LIVE
FROM PERMITA
WHERE (((Left([SC],2)) In (40,45,51,67)) AND ((PERMITA.SQ_LIVE)>3000))
ORDER BY Left([SC],2);

 

[boblarson]

I would use a form for input and then just refer to it. What datatype is your month field and your year field?