Search results

  1. J

    Showing results if yes/no is null on report

    I have a table that has 20 yes/no fields. When creating an error report to show the null values I'd like to create a report that shows only fields that return a NO value. I know how to set up in the query to pull only null values but when it rolls to the report I'd like to only see the fields...
  2. J

    Start as Long String for MID

    Ok, I know this is easy but I can't find the answer and hoping you all can pop an answer to me. I am reviewing a database with a number of MID string statements. I understand the first number is the location and the second is the length. What I'm failing to understand is how you calculate...
  3. J

    Updating Form from Query

    I have two tables that I've combined into a query. I want to pull from that query to update a form. Allow for some further input from the user and then save all fields to another table. In my Employee ID field I have a select query that has a search criteria of WeekEnding. Once the week...
  4. J

    Posting Date Criteria on Report from Query

    I have a report that pulls info from a query that has a set criteria of a date range using [Between]. How do I post that date range on the report? The date range changes from report to report so I'm hoping there is a way to show the range criteria on the report from the query. Any suggestions?
  5. J

    Overflow Error When Running Calculations

    So I have a form broken into three sections. First section is associate time oriented items (scheduled hours, absent, overtime, available time, production hours, production percentage). Second section is a set of 5 different environments were time is collected where associates work. (Mode...
  6. J

    Totaling field from multiple tables

    Ok so I hope this is easy so I can feel silly. I have 5 different tables where information is entered. I want to run a query that pulls from those 5 tables three fields (WeekEnding, UserID, TotalTime). Each of the 5 tables has a Time specific to that table but I want to total that time. So...
  7. J

    Updating content to form from multiple tables

    I am a novice Access user but have been tasked to create a form that links to a number of different tables and updates fields on the form from those numerous tables. At the top of my form is employee information: username, full name and week ending. Next section of the form has time worked...
Back
Top Bottom