Search results for query: *

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

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.

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

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

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

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.