Search results

  1. R

    A Query that selects two other queries and subtracts them?

    I am trying to make monthly performance, year-to-date performance and quarterly performance reports. The idea is to take the raw data from March, save it in as a query called March, and I have the raw data from February saved in a query called February. I know I can create a new query and pull...
  2. R

    Making Fields Blank

    I'm trying to make certain fields that did have data in them now be blank. I created an update query: Field-Marketing Support Update to: [Marketing Support] = Is Null Field - Submission Date Update to: [Submission Date] = Is Null Instead of leaving the fields blank, for Marketing Support it...
  3. R

    Automatic Append

    I am tracking insurance referrals. I have only one table called Master. What I want to do is, when the Effective Date of a referral is equal to the current month minus a year (example: Any referral with an Effective Date in March of 2001) I want that referral to automatically duplicate and be...
Back
Top Bottom