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.?

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?

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)...