Search results

Ok I asked a similar question on the reports forum but this may be the better location for it..... I have 3 linked tables all linked by a repair order number. The 3 tables are- RO number table which contains the RO number, the customer, and unit number......Inventory parts table which contains...

Ok guys here is what I need to do..... I have 3 queries with different segments of a repair order. all linked by a repair order number. each query may have anywhere from 0-10 entries attached to the repair order. I need a report to give to the customer that shows the totals for a specific time...

do you want to over write your existing inventory or do you want a history? if you want to overwrite you could have it pull up "last weeks numbers" and if it was not used no data entry is needed just move to the next item. If that is the case then you would not need the transaction table you...

I seem to be answering questions with other questions today but .... why would you need to save the value of you expresion back into your table? If you have the data in the table to create your answer there is no need to save it back to the table. It only makes your table more combersome. IE...

why go to all the work of creating all the pop ups. why not just build a form with all the ingrieds listed with a value box next to it. This way all of the fields are right there infront of you and all you have to do is enter your new value hit your enter button and move to the next field. Maybe...

brown ale is all I've ever seen here.

ooooohh yeah thats the stuff. Thats nectar of the gods compared to this stuff over here!

I tryed all of the suggestions and the Nz function did the trick!! Thanks Fizzio. And if you feel the need send me one of those sweet brown ales over here ;)

Ok guys I have a form with 3 subforms in the main form. all 4 forms (main and 3 subs) have calculations that I would like to total. I do have sums in each subform but not all subforms are used for each entry. When I use all of the fields my grand total works fine but if I don't complete all of...

got it thanks

Hi all very helpfull site!! I am designing a report for my company and I will have a list of odometer readings and I would like to subtract the lowest number from the largest number to get a total miles for the month. How do I select only those 2 values in my report? Thanks in advance. Nate