Search results

  1. B

    "Not like" except for one instance?

    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...
  2. B

    Output 2 queries in excel, combine then, and run a forumla!

    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...
Back
Top Bottom