Search results

  1. J

    Totaling field from multiple tables

    I apologize. Didn't know if I gave enought information or not. I'm currently using a Select Query but of course don't know if that's the correct one. I'm finding it only pulls results that are found in ALL of the tables. So if for example I have entries in 3 of the 5 tables it wont pull...
  2. 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...
  3. J

    Updating content to form from multiple tables

    Ok so first things first normalization. I'll have to fight that battle. Considering I understand that to mean creating more tables from one source. Next thing you are saying that for my form to pull from multiple tables it must have multiple sub-forms on it? One form can not pull information...
  4. 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