Search results

Hi forum, I have two input tables which are SALES and COSTS. Both have an invoice date in the form dd/mm/yyyy. Both these tables input based on a common field which is the Job Number. So to clarify I have Table 1 which is the sales table. The user enters the Invoice Date, the Job Number and...

just figured it out 2day, cant believe how stupid and easy it was lol. i just changed the total for the OrderDate from Grouped By to Max. this then shows me the max order date for each customer and then in the OrderDate i added the crit. <Date()-183 and it works. :D "sometimes the hardest...

:(( .......

i guess this doesnt have an easy solution goin on the reply rate! lol o well, guess i'll just have to skip over this query lol..

how and where would i put that into the query, in the criteria? that makes sense, because i only want the customers who's max (ie latest) order is 6months ago..

anyone have any idea how i can do this, if at all????

CustomerID,Name,Address,PostCode,OrderDate and at the moment i have got in the criteria for OrderDate: <=Date-183 And >Date() Is Null ..but that last bit 'Is Null' doesnt work.. the first part works, shows customers who have orders which are 6months or more old..but some of these customers...

i want a query that will show all records that are 6 months old but that also that is ther only record since then. eg: A load of orders for customers but i want to archive customers who havnt ordered in 6 months. iv been tryin to get the query to work so it wud be something like: >Date()-183...

answering my own thread lol...got it working :D i put this into the control source for my total:- =IIf([OrderTotal]>30,[OrderTotal]*0.9,[OrderTotal]) I then 'hid' the OrderTotal field and just used this one as the order total. So if the order does go above £30 then the order total will show...

not havin much luck..see i know it needs to be an IIF command on the lines of: if subtotal>30.00 then total=subtotal*0.9 if subtotal=<30.00 then total=subtotal but i'm terrible at coding and i dont know how to put that into a way the computer understands it lol..and where to put it..

yeah i see where ya goin with that, havin the discount on the form so the total will take the value from that txt box. k thanks for ya help.

hey, at the moment i have my total showing on my form but i need to take 10% of this IF the order is over £30. So what i would have is a sub total which for the most part will show the same as the total EXCEPT when the sub total is over £30..then the total would show the 10% discount. Its prob...

yeah, i didnt fink anyone wud of noticed i spelt it wrong n cudnt be bothered to edit the post lol.

thankyou for that link georgedwilkinson!!! got it working now, glad im over that hurdle. i now have the order total tallying up on the main form as i enter new items in the subform. Thanks for all the help ppl :)

yeah so the field i what to tally up into a grand total is called SubTotal. ther are a number of these as this is the item cost * the qty. so in the footer, in the text box i now have a textbox =SUM([SubTotal]). how do i then have a textbox on my main form that 'points' to this?

thanks for you quick reply RuralGuy. That sounds, logically, that it should work. I'll go try it out and hopefully end my troubles lol.. ..sorry but im unsure what you mean by 'YourSubTotalControl' not sure how to add controls? thanks for your replies...

I currently have a sandwhich shop form (a-level work). on this form i have a subform which is the orderline, ie its where the clerk enters the sandwhich's and qty for the order. Each product has a unitcost within its base table. im having trouble on how to add up all the subtotals shown in the...