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!

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

Search results for query: *

  1. ThePixelMines

    Date Range - From form to report

    This is a newbie questions so I hope it will get answered quickly. I searched the posts but couldn't find the answer I was looking for. I have a report that relies on date ranges. What I'd like is a pretty little form that asks for the date ranges and has a button to call up the report with the...
  2. ThePixelMines

    COUNT(DISTINCT <expr>) is a report or its equivalent.

    This has been driving me crazy. It seems so simple. I've got a class roster (report) that totals tuition, number of students per class and total students. I want a total of families. Right now, I have a table for families with a one-to-many relationship to a student table. The result I'm...
  3. ThePixelMines

    Format and Display month in Header

    I've created a monthly summary report to summarize my invoices. It's based on a date range. I want a header that displays the month and year based on the [End Date] of the requested date range. For the sake of this example imagine I'm using the date range of 4/1/2007 to 4/30/2007. To do so I...
  4. ThePixelMines

    Subreport in Report Header won't grow

    I've got a subreport in my report header that will only display the first entry of the subreport. To see the relationship among tables click here. My report works like this: The report header is to have a monthly summary of my department's billing. At the end of the header I forced a new page...
  5. ThePixelMines

    Calculations in a subform from another table.

    I'm preparing a database to manage billing and assets for various projects and clients. Specifically, I'm trying to calculate billing charges in a timecard subform. Right now I have a subform that details the project, hrs/qty of service, and a serviceID that links it to a another table that has...
  6. ThePixelMines

    Combo Box: Display Values from 2 tables and enter onto a 3rd.

    I'm a newbie. Please be nice.... I'm setting up a database to manage a list of Clients, their respective projects, and the billing of said projects. See the relationships here: http://www.thepixelmine.com/forumfiles/tektips/ProdRelation.jpg In a Time Card form I have a subform managing the...

Part and Inventory Search

Back
Top