Search results

Thanks for the reply. Tbh that seems like the most logical way ill see what he says a report back to you. Thanks

I know its driving me up the wall. The current database is in an excel spreadsheet and i have been given the lovely task of converting it into access. All of the other parts have been converted and this is one of the last things todo but i cant get my head around it. I would love to leave it in...

Yeah rainlover's seems a good staring point but my colleague has some really crazy ideas and always seems to want to change it. Above it what i got from what he sent me. Apologies. I am going to try Rainlovers suggestion today aswell as yours and i will post back my results. Thanks

Thanks you very much i will report back to you on monday because work dosen't allow me to download any attachments. Its sooo annoying. Also how do i PM you Thank you very much

I need a nested if or IIF or Dsum in a query. In a query i have 27 results and only 12 need to be added. i don't know how to go about this calculation. My colleague suggested checkboxes so if the checkbox is ticked on it will add the checkboxes that are ticked and the checkboxes that aren't...

Ok i will do any progress i make on it i will pm you or something. It says i only have 5 posts and i need 10 to view your link :( Thanks for your input today hopefully you can help me at some later point in this project Thanks

Yeah DSum but how do i put code for checkboxes because the user may also need to change the price but will this effect the nested if, IIF or the Dsum Thanks

Thanks For the reply. The main problem that i can see is that if we order 100 parts of the same products 95 are good but 5 are not how can i say that they are not alrite and only 95 have come in a 5 need to be sent back and 5 more new ones still need to be brought in the the major trouble we...

Hi guys hoping anyone can help me with any ideas they may have on helping me achieve the mammoth task. Have a button that can be pressed and all order in that table above will go to the table below. Another button that is on each line when the order has been sent down that can be pressed and...

Hi Guys I need some help :) I'm need some code either nested IF or IIF formula to add up the values if a check box has been ticked. I may have 1 item or 20 items and the formula needs to add them up aswell. I really don't know if this is possible but this is what my colleague wants. I'm sorry...

Hi Guys Need Some guidance here. I know this has been posted before but the ones ive tried haven't seemed to of worked for me. I tried using macros to save a .pdf and output to file but thats not what im after. Basically what I'm after is a button that you user can press on the report and it...