Recent content by matorme

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?