Search results

  1. R

    Using Not Equal on conditions

    I have created a scheduling database for my department at work where people put in requests. Unfourtunately someone is messing with other peoples schedules so each individual record needs to be password protected To do this I have created a seperate field in the table containing vital...
  2. R

    Sorting multiple subreports into 1 report

    So here is the deal. I have a database built that tracks patients in a hospital. Each patient has up to 8 reports possible but only 1 report will be used at a time. So the report is built and at this point what happens is each patients information which takes up half a page has been printed...
  3. R

    Select query limitations

    So here is my issue. I have one table full of employees 64 to be exact. then I have them electronically place schedule requests by choosing multilpe options for what kind of shift they are going to work. One of the codes is ED. I now want to be able to run a query that will allow me to see...
  4. R

    Multiple IIF and Null values in dates

    So i am trying to create a box that will display whether a new care plan is needed for patients. Right now waht I have the background doing is i have one box that displays the current date. A second box where you place in the date of the last care plan and a third calculated box. that words...
  5. R

    being able to choose field in update query

    I am trying to create an update query that when run will simply ask in a seperate box similiar to using this line on the criteria line of a select query Like "*" & [Enter any char to search by: ] & "*" When i run the above code in a select query it asks me what records i want to pull. I...
  6. R

    text field that needs calculation

    So here is my problem i am semi access savy but i have having trouble with one thing. At work when we make a schedule there are 5 possibilites for how you want to mark your day. I have created a field using text as my parameters since my possibilities include both letters and numbers. At the...
Back
Top Bottom