Recent content by DNASok

It took a bit of writing out on scrap paper, but I finally figured out how to make the many-to-many relationship work. I know have three (3) tables: 1. Funds · Fund ID 2. Efforts · Efforts ID 3. Cost Junction · Fund ID (one-to-many from Funds) ·...

I thought this would be easy, but I was apparently incorrect. I am trying to create multiple one-to-many relationships, but it does not appear to be working. What I have is 2ea tables: "00 Funds" - This is a checkbook for various fund sources and their details - Primary Key = FundID "10...

OK, I'll try: There are currently 20 bananas "Awaiting" to be ordered The cost quantity break for bananas is: 1-4, 5-10, 11-25, 26-50, 51-100, and 101+ based on a given FY (FY14, FY15, FY16, etc...) A new order comes in for 10 more bananas, so the total bananas WILL BE 30ea On the form the user...

I was wrong, still not working! The issue appears to be when I sum/total the currently awaiting orders; works fine when I do not do this, but I need to!

I believe I have figured this out, I had to reorder how things were being processed/equated; I have the following now working: SELECT [Forms]![04c Test Query for ROM Support]![Quantity] AS [Requested Qt], [Current Orders]![Quantity] AS [Awaiting Qt], IIf(Nz([Requested Qt] + [Awaiting Qt])...

Any recommendations then? I originally had seperate columns for: - "Quantity Requested" Quantity Requested: [04c Test Query for ROM Support]![Quantity] - "Quantity Awaiting Order" Quantity Awaiting Order: [Current Orders]![Quantity] - "Total Quantity" Total Quantity: [Quantity...

Tried it; no joy! Gave me the same Expression not a part of an aggegrate function error!

I do not believe it can be that. I must turn nulls to zero on the sum/total of [Current Orders]![Quantity]. The recommended approach would not require the "sum" at all, and would not provide me the total of the [Current Orders]![Quantity]. Or am I likely missing something? I will try it...

Sorry, but I don't follow why you feel the second ")" is in the incorrect place. I assume you are talking about the IIf(Nz(Sum([Current Orders]![Quantity])). However, I thought the first was for the "Nz", and the second for the "Sum" expressions. "Sum" is required as it is summing the total...

Don't know how to do that!

I have 5ea columns: 1. Price: IIf(Nz(Sum([Current Orders]![Quantity]))+Nz([forms]![04c Test Query for ROM Support]![Quantity]) Between 1 And 4,[04b Pricing Products]![01-04],IIf(Nz(Sum([Current Orders]![Quantity]))+Nz([forms]![04c Test Query for ROM Support]![Quantity]) Between 5 And 10,[04b...

I have a query that will be assisting me find pricing based upon quantity ranges of specific equiment for a given FY. I'm no access expert, and I keep getting "You tried to execure a query that does not include the specified expression...as part of an aggregate function". I have tried...

While looking for that 02b I believe I found the problem. I tried several things while trying to make this work. One (1) of those things was adding a "Where Condition" to the button. Once removed, this appears to be working. Thank you very much for the assistance! My solution to this...

Crap...I know where that came from. Where did you see that reference?

Sorry, should have been more clear on what to do to recreat. Open "02 Update Order" In the subform, select "Contr Details" This will result in "Enter Parameter Details" for "Forms!00 Products Sub Update!Product ID"