Search results for query: *

Ok brilliant thanks. I'll give it a go

Thank you all for your help. I will have a go with tblPakingFee. Meantime can I confirm that LostFocus is the right event? It is also an unbound txt box (a calculated one)

I am stuck on something here and losing hair. I have an unbound text box called "packingfee". I have another text box with a total value in it, let's call it TotalSale. I have 4 PackingFee prices which are based on values in TotalSale. If the value is <1 PackingFee = 0, if it is between 1...

That's done it. I didn't know you could have Group Footers. You'd almost thing someone had thought this through! Thanks again

Sorry, but could you possibly be a bit more clear? I delve in an out of access. I am looking at the Sorting and Grouping as I write this. The only sorting I have is on QuoteCategoryID at the moment. I am not clear how to do what you suggest. I mean the =1 one bit and how that relates to...

The issue is that in the Report footer I have a Grand Total. I put the Terms and conditions subreport into the report footer (under the Grand Total)and inserted a page break just before it. For some reason I cannot fathom, the grand total is pushed to the top of it's own page, even though the...

Ok that works great. I had to add a TermsID to my Quote Table and simply default it to one. This then forms the parent child relationship. Unless there is a better way? Is it also possible to suppress the page header information on the pages with the terms and conditions? Obviously it...

Ah yes! Thank you. I will do that tomorrow when I am back in the office. I appreciate your help

Hi I wanted to add some Terms and Conditions to an access report (a quotation). However, these run to two pages and I wanted to simply tack them on , and force a new page for each. However, I don't know how to add them. I tried simply adding a Label for each and filling it with the text but I...

These are bound forms. Five key tables are: Enquiry Estimate EstimateVersion EstimateProductService zmtProductService Relationship: one Enquiry to many Estimate one Estimate to many EstimateVersion One EstimateVersion to Many EstimateProductService One EstimateProductService to Many...

Once a project is "won" I need to create an Order Confirmation. I want to do this by duplicating the information contained in the "frmEstimate" and it's subform "frmEstimateProductServices" which is a continuous form with many records (items). I have seen Allen Browne's code for duplicating a...

I should have known that. Thank you

Something just cropped up. Where Quantity >=1, Markup and UnitPrice are calculated as they should be, the formatting goes. I have them set for Currency, 2 decimal points but this seems to be overidden. This seems odd?

I modified this slightly as follows in order to avoid the need for a RateOnly field. IIf([Quantity]=0,"",[SalesPrice]/[quantity]) AS UnitPrice The same for Markup. The reason is that it removes the "Error". SalesPrice comes out as "0" anyway if quantity is "0" I was then thinking I would put...

Brilliant thanks. It applies to all fields really. Sometimes the client wants a rate only in case the quantity is variable. That will do it though!

Ye Ha! Thanks. Actually I wasn't already linked to tblEstimate. But when I did, that worked great. Pushing my luck now because I already owe you several crates of beer: Some of these price items will be rate only. So, I don't really want them to be totalled up. Just the Unit Rate shown. I...

Did that but when I run the query it asks for the RentalPeriod. This is what I did. Obviously I dun something wrong! SELECT Estimate_Plant_Rental.*, Estimate.RentalPeriod, zmtCostCode.CostCode, zmtUnitType.UnitType, zmtCurrency.CurrencyName, ([rate]-([rate]*[discount]))/[currencyvalue] AS...

Yup here it it SELECT Estimate_Plant_Rental.*, zmtCostCode.CostCode, zmtUnitType.UnitType, zmtCurrency.CurrencyName, ([rate]-([rate]*[discount]))/[currencyvalue] AS DiscountRate, [DiscountRate]*[quantity] AS TotalCost, [TotalCost]/(1-[Margin])-[TotalCost] AS MarginValue...

Ok this looks like something I can play with. Especially as for the fittings I may have 50. I don't want all 50 listed so I need to group those under types with a Subtotal for each(lets say a, b, c, and d). I can do that easily with an aggregate query, putting in null as values for missing...

I think I may know the answer to my last question. Perhaps in all the qrySubforms SalesPrice remains the same. For the two rental ones should have a TotalSalesPrice which is SalesPrice x Rental Period? On the other hand the union query based on cost codes would then not include those...