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 strongm 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. abourg

    grand totals

    I have 4 tables with like data from different facilities. I need to pull each like field for that month from each table and get a grand total to put in a report.
  2. abourg

    union query

    Is there a max # of select clauses that can be used in a union query.
  3. abourg

    Pull in 1 month at a time from a crosstab query

    I'm sorry it was MaxOfTime Wkd. When I made the union query then it took the values of 10 fields and placed it under the date. The expr1003 was the names of the fields. My report looks like this. Name expr1003 d0 d1 d2 ... d29 d30 total John Time Wkd 06-14 06-4 06-14...
  4. abourg

    Pull in 1 month at a time from a crosstab query

    Is there a way to sum the rows in Expr1003. There are 10 rows per name. I need a total of each row for the month.
  5. abourg

    Pull in 1 month at a time from a crosstab query

    I have a report that was made from a union query and then put into a crosstab. I follow the tip FAQ but my problem is each month has different # of days. At the far right hand end I will end up with Totals for each row. I'm using D30-D0 as the dates. Here is the SQL Statement: PARAMETERS...

Part and Inventory Search

Back
Top