Recent content by Rummy

Thanks, I'll still work to improve the normalisation of the database anyhow. It's quite junior, and really made for proof-of-concept to show it could help in meeting the recommended monitoring intervals of these tests. I wish there was more available to put into the project really as the subject...

Ah, thanks guys. I see your rationale now. It's a database for lithium monitoring and as I said, it was previously made/designed for the express purpose of monitoring just these three tests as they're the relevant ones and what we collect data for. Its only real direct end user is me(to...

They're for three different types of test though? I left out the details to try and avoid confusion, but they're specific blood tests for specific things, each separate (thyroid function, renal function, and a blood level). The database's purpose is specifically to record these three types of...

Though I agree with the gentleperson above, I will say look towards the option of default values for a field :P

Quite! Thanks for pointing it out, I need to get into more of a logical mindset. I think I meant that any doctor CAN be a named carer, but not all named carers can be doctors? Anyhow, I digress. Thanks to all for the replies(and Alansidman's link was certainly a helpful read), wasn't sure if I...

Thanks for the reply. My current rationale for the tests being seperate tables is that Test Type 1 records more information than the other two, and the other two are unique tests, and the patient won't necessarily have had any or all of the tests. I've gotta head home now because we're shutting...

Hi all, hoping that I'm not asking too much. I'm currently in the process of trying to re-design a database that I didn't make so it's a bit more normalized, there's lots of redundancy in places and I remember being taught in A-level IT(basically extent of my knowledge plus what I've picked up)...

Pbaldy you're a genius, it was totally that! Something for me to keep an eye on in the future. Many thanks :)

Aye, sorry, I was at work and we were coming to close, got some screens printed, but no time to zip and post. Essentially it was just =Nz([Fieldname], "Unk"), removing the string didn't help either. I'll have a look at it tomorrow and also try and post the pics which could help. Apologies for my...

Hi all, I'm Rummy. Running Access 2002. I'll admit right now, I'm not too fancy with SQL and definitely not so with VBA, so mainly work through the simple GUIs of Access. I've come across a rather large/annoying sticking point however; I'm working on a database(not made/designed by me, though...