Search results

My db tracks supplier cost changes for our annual deadline. I use Dsum in text boxes to calculate the COGS * the % in/decrease. I have a textbox in the header that will give Total COGS. dsum doesn't work, I found that out and I don't know how to get sum to work. Current controlsource for...

Hrmm, lets see if I can explain this. I have a query that outputs to a continuous form. Because of how this query is made I'm unable to edit the data on the continuous form. I will have to make an "update form" and wanted to know if there was a way to view the table that needs to be updated...

I have a form displaying cost increase data by supplier for our PM's. We send out templates to be filled out. I want to have 4 buttons total, maybe 5. Merchandise where templates have been sent Merchandise including suppliers where no template was sent Parts where templates have been sent...

I have a main form with 3 Combo Boxes and Submit Button. Combos are: Team Product Manager Supplier Current setup: User chooses Team Requery done to qryPM User chooses PM requery done to qrySupp User clicks submit All information under chosen PM is displayed. The value of the cboPM is used...

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.

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

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