Search results

dont worry...sorted. thanks anyway people

doesnt seem to work...or were you just being sarcastic?

I have hit a total blank. When you run a query for blank fields i.e. "is null" or "". It will return all the records with no data in the selected field... basically i want the opposite to that. I want to search for any records that have data in...and leavoe out the blank ones. Any idea...

can i post it up here somehow and see if someone could take a look...still not really getting this. Im sorry for being such a beginner, but need to try to sort this out. Thanks in advance

Thanks for all comments so far. I am trying to create a junction table, as you were rightin saying that many people can do many events on many different dates. Can anyone shed any more light on this? I have created the relationships, but do i need to create a form for all this data now...

Hello, I am trying to create a query in access. Its been a long time since ive done all of this, but maybe someone on here can help. I have two tables, a "Care Ambassador" Table, with Name, job title, address, contact number, employer name, employer address etc. On the other table, "events" i...