Search results

I have 4 Tables: (((* Means primary key) 1. User (*UserID, FirstName, LastName) 2. Docbase (*Docbase, *UserID) 3. Group (*Group, *UserID) 4. Proj (*Proj, UserID) a user can belong to none or more then one group, docbase, and project. I want to create a query that returns all the...

Is there a way that I can produce a report based on a user input.?

thank you for explaining. now it makes sense cause some of the items were on one table and not the other and my query was join query and didnt produce any results. Thanks again,

Hi, I tried doing that but the output doesn't produce what I really want. the four tables that I have are: Table 1 is the one side and other tables are the many sides of the table1. its one to many relationship. Table1: *UserID Location Table2: *UserID *Tabletwofield Table3: *UserID...

Hi, can someone tell me if there is a way to summarize a report based on a query? If so can somen tell me how to build a query that takes in information from 4 tables that have one field in common (User ID), and produce a report that summarizes all the information related to that User ID?

Thank you Thank you Thank you It worked. Now How would I create a form that opens up if no mathches of the record were found, just for the Add Mode.

Hi everyone, I am new to using access and have so many problems designing and implementing this database,,,,,anyways, here is my problem: I want to create a dialog box such that as soon as a user clicks on "enter new user" command button, a dialog box opens up asking for user ID(primary key)...