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 Chriss Miller 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. aageorge

    Problem transfering totals from Form 1 to Form2

    Hi, I have a main form that pops up a form depending on what Line you select. The popup form is where the user puts in counts for different part numbers. I setup the following vbcode in the on close event of the popup form: Forms![Main Form]![Pieces Run] = (Part1 + Part2 + Part3) When the...
  2. aageorge

    Trouble writing an IIF statement

    I have the following control source for a textbox in my report footer: Sum(IIf([Shift]='Aft',[Expr1],0)) It very simply sums up Expr1 for Aft shifts. The problem is a few lines don't run Aft shifts and the text box returns a value of 'Num#'. How do you I write an expression that returns '-' if...
  3. aageorge

    Linking Databases: Query Problem!

    Thanks guys, I used the left join property and it worked like a charm.
  4. aageorge

    Linking Databases: Query Problem!

    I created a query involving two tables from two different databases. The following are my tables: Database 1 Database 2 Date Line Production Date Line Scrapped_Qty. 8/14 A 1000 8/14 A 100 8/14 B 900...
  5. aageorge

    Crosstab query?

    Duane, Just make things clear, I start with these tables: T1 T2 T3 Date A B C D Date B C Date A C 8/1 10 10 10 10 8/2 20 20 8/1 30 30 8/2 10 10 10 10 8/2 30 30 8/3 10 10 10 10...
  6. aageorge

    Crosstab query?

    dhookom, these are my tables on which the above union query is based. T1 T2 T3 Date A B C D Date B C Date A C 8/1 10 10 10 10 8/2 20 20 8/1 30 30 8/2 10 10 10 10 8/2 30 30 8/3 10 10 10 10...
  7. aageorge

    Subform problem

    I have a form that opens up a subform based on a selection on the main form. The fields in the subform are automatically filled in based on a value in the main form. The user can change the values on the subform or just accept the default values. I have a problem, if the user just wants the...
  8. aageorge

    Subform addrecord command

    How do I configure my form so that when I click the addrecord button on the main form, the record on both the main form and the subform are added?
  9. aageorge

    Crosstab query?

    I have a query that gives me the following output(Thanks Norris68): Date A B C D 8/10 100 100 100 100 8/11 50 50 50 50 I am trying to use a crosstab query to get the following output: Part 8/10 8/11 A 100 50 B 100...
  10. aageorge

    Union Query help!

    Norris 68, I am setup the above query for my database. But when I tested it with some numbers it returned the field names instead of the counts. In my database the fields A, B etc are part nos. like 1324, 4245, 6353 etc. So instead of getting the output as Date Total1324 Total4245...
  11. aageorge

    Union Query help!

    Norris68, Thanks a lot, worked like a charm....
  12. aageorge

    Union Query help!

    Leslie, You are right, the union query won't sum it up. I was planning to sum it up after it does the union. The biggest problem is getting all the fields into one table.
  13. aageorge

    Union Query help!

    I need to combine a couple of tables having one or more similar fields. For eg: T1 T2 T3 Date A B C D Date B C Date A C 8/1 10 10 10 10 8/2 20 20 8/1 30 30 8/2 10 10 10 10 8/2 30 30 8/3...
  14. aageorge

    Help with Dsum

    Bob, I messed up I was placing the textbox in the page footer and not the report footer. It works fine now. Thanks for the help.
  15. aageorge

    Help with Dsum

    Bob, That gives an error too. After some more experimenting, I figured out the dsum expression for some reason takes the last piece entry and multiplies it with number of enteries in the report. For eg: it the last entry is 20 and number of rows in the report is 3, it gives out 60. I trying...
  16. aageorge

    Help with Dsum

    Bob, I tried out what you said but it gave me an error. I did some trial and error and found that DSum([Pieces],"Production Query") gives a number but it is not the correct sum. I am kinda stumped with this one.
  17. aageorge

    Help with Dsum

    I have a report based on query. I need to sum the total of one column called Pieces. I tried putting a textbox in the report footer with the following expression in the controlsource Dsum("[Pieces]","[Production Query]"). It gives me an error message. I can't figure out what...
  18. aageorge

    Problem summing fields from 2 tables

    jfgambit, I tried your approach, but it just has date entry but with no counts, i.e; the output is 8/3 - - - another problem is that either table can be missing a date entry, so the join statement will not be correct in every situation. rolliee, can you give me an idea on the type of...
  19. aageorge

    Problem summing fields from 2 tables

    I have two tables: T1 T2 Date A B C Date A C D 8/1 10 10 10 8/1 20 20 20 8/2 15 15 15 8/2 10 10 10 8/3 20 20 20 Then I have a query based on these tables with the...
  20. aageorge

    Crosstab Query Help

    How can I use this table: Date A B C D 7/22 10 20 15 30 7/23 0 19 0 40 To run a crosstab query to get the following: Line 7/22 7/23 A 10 0 B 20 19 C 15 0 D 30 40 Thanks.

Part and Inventory Search

Back
Top