Search results for query: *

In the same red FLC field. There is an flc code "0" or zero, when I want ALL flc records to appear. How can you program it to show me all records when I pick zero? None of the records will have a zero, so i suppose that you need a vba statement to say that zero means ALL.This way, i can be...

Maj to the rescue again. I was so close yet so far. Thanks for the answer. It works. Molly.

I have a main form with 3 subforms. The forms all worked well where the subform 1 is all our products, subform 2 is the customers who take a product in subform1, and then subform 3 is the order qty by location. It works great. However, I just added a new dimension which kills me now. I...

Solved. I found the answer. I put a greater than sign .... > into the Format line in the field on my report. All answers came out uppercase as i wanted them to. glen

How can I automatically make each record's data capitalized in each report field? Molly

Thanks Duane. It worked. I should have known to use the control line. =Format([CallDate],"dddd") Molly

I have a date field named CallDate. I have this field in a report header. I would like it to show the day of week. EG Monday or whatever the date converts to. I tried in the field on the Format row: =Format([CallDate],"dddd") but i received an error. It came back as...

Never mind. Figured it out after reading deep in the Tek Tips. They gave me an idea. I made a query of just the formulaID and the MonthID. I put on totals, and put MAX on the monthID total row. Then i went to the main query and added this new query. I put a newer version 2 file if you need...

As a check, I should get the following 2 records back. formulaID monthID Total Fixed Cost 692030 200908 935.14 692744 200909 2200.40 If I put MAX on a TOTAL, the dollar fields are incorrectly summed up. I just want the 2 records above to show up. I tried concatenating...

I need a way to choose records based on the last monthID and the associated FormulaID. Maybe like a 2 field MAX problem ?? Attached is a small file to try. I need to records to show up in the query 8510Qry-P05 Total Fixed Cost The 2 records would be for: 692030 for month 200908 692744 for...

Could you point me in the right direction regarding the following. Maybe their is a white paper or an example. Or at least the terminology to help me search the internet. I would like to pick choices from 3 groupings that are on a form. The combination would be the basis for a query to run...

Perfect. Purchases YearMonth: Format([PO Date],"yyyymm") Molly

I am trying to take a date like 5/31/2009 and convert it in a query to 200905. The following does not work for me. Purchases MonthYear: Format([PO Date],"mmmm" & " "&"yyyy") gets me an answer of 2009 May I desire 200905. Thanks for your help.

RG - You figured it out. This sample uses QuoteID as an autonumber junctionId in tblQuoteMain. Then I added QuoteID into tblQuoteDetail and took out soldtoID-shiptoID-FormulaID from the detail table. Then I made the main and subforms child / master refer to QuoteID...

Funny that you should say that. I was considering using a JunctionID for both the Main and Detail forms. And then I could take out soldto and shipto and formula ID's out of the detail form. What do you think? Molly

HI. All the time. Not to mention, my boss sometimes picks the wrong soldtoID and formulaID and works on the costs. And later, he needs to fix the soldto or shipto. Last spring, a major customer had a flood problem and closed a plant. So we had to revise quotes. In my real file, I have...

Yes, that what it seems. A need for some After Update deal. I don't know how. Molly

Hi and thanks for your nice help. In this example, pretend that I worked up a price quote only to find that i inputted the wrong soldtoID. So before we send the price quote to the customer, I need to fix an existing records soldtoID. Or it could be a shipto error or change. The data in the...

Hi, you are correct. I looked at my old models and the same thing was occuring. I didn't know this. Unfortunately, I cannot base the sfrmQuoteDetail on only FormulaID. The 3combo (formula, soldto and shipto) makes each price level quote unique to 1 customer. I cannot have 1 formula price...

I know that this already works on a new record. The problem is when i change an existing record's say SoldtoID. The subform data goes away. I have this working perfectly on 2 of my other models. So I will keep looking to see what I am missing. Thanks