Recent content by november

I'm going to have to go back and retype my initial post. Dsum isn't giving me Aggregate COGS at all. Dsum is only calculating the COGS per line displayed by the query. I have a textbox in the header of this form and I want to display an aggregate/sum of all cogs for that product manager...

I have a textbox in the header, I'm unable to make it display the SUM of COGS in the continuous form below.

I believe with Dsum originally I was getting ?Name# But when Summing I got it to display the sum of whatever value I clicked on, I guess that's progress, but not enough.

My mistake, that was the forumula I was originally using. I really don't know how to get it to sum to all fields showing from the query.

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

What about using a make-table query to compile the data that each PM should represent, then updating that information in the continuous form and later updating the preceding information accordingly. Does this sound like something that can be done?

Elaborate on said linking please.

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 can but for one display I want to view a the people that fall under the director.

To test it out and go to it quickly. but once the form is visible with the data I have buttons that I want to switch between the "items" and their "parts". So I'll need to use a var to populate criteria for the division(items or parts) and then requery to show the values. Make sense?

I figured out how to not have to use multiple queries by just changing the variables via buttons. I have an issue with that though. If I run the query without the form loading the value I get prompted and I cannot leave it blank or use * as a wildcard because it returns no results. Is there...

Well I may be using the same query and just change criteria in it via variables. I tried using * as a wildcard but it doesn't work. Currently in my query I have it referencing a combo box value. So if I open the form manually I have to type in the data. How can I use a wild card like this...

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

So I got all that figured out. I wanted to know, also. If I have multiple queries that will produce outputs to the same field names, can I use VBA to change the control source of the items? IE, I want to use the same form the display different query information when a button is clicked. I...

Right, but that's not a route. Should I have a bunch of separate queries, or is there a way for me to utilize one? Would it be smart to use 1 main query or multiple?