Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sandygo

  1. sandygo

    form/subform filter

    I have a form with a subform. The main form is by project and for every project their can be multiple subform entries. Upon opening the database, I have set up a macro that opens the form and filters by person so that the users can see just their records for editing and can add new records...
  2. sandygo

    query one to many tables w/aggregate functions

    Swamp Boogie, Thanks for you response, still not working. I tried grouping by Hours quoted. Problem is it groups by the value in Hours Quoted. For instance, I have three projects with a Service Type of Reporting, each has 1 Hours Quoted. When I group by Analyst, by Service Type, the result...
  3. sandygo

    query one to many tables w/aggregate functions

    I have a table called Projects and another table called Project Details. The Projects table contains the overall hours quoted for each project. The Project Details table allows the user to have multiple entries per project and specify hours worked for each entry. Here's a simplified sample of...
  4. sandygo

    one to many solution needed

    I have three tables. One with old system report names and info, one with data elements, and one with new system report names and info. I built a form to get info from both system report names and info. Each report can contain several data elements. I need to identify all the data elements...

Part and Inventory Search

Back
Top