Search results

Thanks plog, I'm not exactly sure what it is you need, probably down to my inexperience with access / sql. I did accidently upload two sets of screenshots, apologies. I'll leave it there thanks and see if I can find it somewhere else. Cheers

Thanks for the response, I'll give the lookup table a go. I have added a couple of images from Access as Plug suggested AE Table shows the FieldID and Text Value columns I'm trying to query Results shows the two lines per employee. Ideally I would like one line per employee that has the EMP...

Hi all, A quick introduction from me. I've been a member for 5 months but not yet posted. The help on the threads has been more than enough to answer everything I have needed up to now and is greatly appreciated. I am asking for a little help on a query I am running. It uses half a dozen...