Recent content by buffettjr

Oh. Right. I tried this once and i got all blanks...but it turned out I was searching December 2009 rather than December 2008 so of course it would come up blank (it is currently July 2008!). Sorry, and thanks for the help. The code worked perfectly!

First off, thank you all so much for the help you provide. I'd like to write a query were I exclude a row any time a project number starts with 9CT with the except of the one instance where it says 9CTAT So lets say we have data like this: 7CTmisc 9CT01 9CTRJJ 9CT45 9CTmisc 9CTAT 10CT11 I...

Wow, many thanks for your reply. I'll give this a try and see how far I get :D

Hi everyone, thanks so much for helping on these boards. What I am wanting to do may be too complex. I want to run two queries in access, output them into excel (the results of each query goes into its own worksheet) and then I want to do an "average" calculation on certain fields. Can all of...