Search results

I feel special. I completely overlooked the wizards. I have the difference and feel bad for wasting your time.

I have a 2 tables. I need to find out the items that exist in 1 and not the other. I'll be using the Where function. I'm unsure how to apply this though. Help if you can please.

No, but I just created a new continuous form from the query again and copied over my objects. So it's back to working. Damn computers. I'm having trouble getting the "SUM" to work with COGS. It's coming up blank. I'll look into this one some more tomorrow.

Man, this is great, the query is not working any longer. It's returning blank results for some reason. Bah, I hate debugging.

Thank you for the quick reply and your response makes sense. I'll just sort it how it should look and leave it at that.

I would like to know if there's a way to create a button that would sort the query on a continuous form. I am putting together a database for my Product Managers and I want them to be able to sort by the supplier and by their relationship identifier. Need: Button to sort query on...

I'm back again. What is a way I can make the COGS update when I close out of and reopen a form? If I change the PM the COGS don't change from the initial load. I tried putting the code in "gotfocus" but that didn't do anything. I'm also trying to have the ability to edit fields, like the %...

I think I'm in love with you. Thank you for your help. I will be back shortly :-p

Great, I'll try that when I get in. As for making the summary at the top. Should I just create a duplicate query and change how it ouputs? Making the values that it ouputs go into the textboxes or labels?

Well I'm creating a database at work for my teams for our yearly cost increases from our suppliers. This database will have a field for Supplier #, Prod Mgr Code, Rolling 12 COGS, Proposed % Increase, Revised % and Accepted %. I have created some fields in a query to produce the $ Impact...