Recent content by aageorge

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

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

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

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

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

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

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

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?

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

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

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

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.

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

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.

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