Recent content by CharlieC

Hi I've attached a simplified version of the relationship between some of the tables I would like to use in a database but am having trouble creating the form(s) for data entry. Basically I have a sales order table where one sales order can be made up of many batches of a product. Each batch...

Hi I've attached a simplified version of the relationship between some of the tables I would like to use in a database but am having trouble creating the form(s) for data entry. Basically I have a sales order table where one sales order can be made up of many batches of a product. Each batch...

Sorry cross posted, can't believe I was actually pretty close! Thanks again!

Thanks for not just laughing me out of town, that makes complete sense. It is fab that you guys are willing to help complete beginners like me. Hopefully one day I will be able to give something back!

=IIf(IsNull[Pen25])" ", ([Pen25]<=50 Or [Pen25]>=70,"FAIL","PASS") ????? Am trying hard (and surprisingly enjoying myself!) but clearly haven't got a clue what I am doing!!!

That works perfectly thank you very much! Just wondering if it is possible for it not to automatically display "pass" on a new record? I think I would be able to do it now but don't know what the expression is for no value entered (an empty box)?

Ok that's good I did - by luck rather than judgement though!! Have tried your revised version (thanks again) but it is returning a syntax error?

Thanks so much for your quick reply, stupid question though - where do I put it?!

Hi Am very new to access so please go easy on me, I am sure this is pretty easy to do but I am now completely confused! I am basically trying to set up a box on my form where when you enter a value it tells you next to it whether the value falls between specified limits (PASS) or outside the...

Thanks so much for your detailed reply (and sorry for the delay in thanking you, have been on holiday.) I have now revised the layout and separated out the Tests table from the Testresults table. You were right in pointing out that multiple batches per Salesorder would mean that it won't work...

Really sorry, had written a big explanation of what I was trying to do but ditched it because I was worried it sounded daft (how ironic!!) I am supposed to be creating a way to store lab results, the ultimate aim being that you enter the results and find out whether the product is within some...

Hi everyone Have been reading for days and have finally braved an attempt at some tables. I would be very grateful if anyone could give me their thoughts on them as I have learnt the hard way that if this bit is wrong, there is no point carrying on! Please let me know if I've not provided...