Search results

Hello I have a query to find only the unique clients that have attended an event during a time period I can only get the event and client for each event So i want a query that returns the clientID for any client that attended any event. havr tried using the return unique values in the property...

hello I just need a simple method to prevent a member being imput twice on a form I have two fields firstname and surname ( this is necessary) I want to stop duplication of the same person being entered when staff use the form How do I stop this? I have seen other varyations of this but I cannot...

hello i am trying hard to produce a report that gives me the actual name of a field if the selected option is "yes" using a y/n combo box. I have 12 different fields with y/n options and i dont want to print every field name in the header as well Just the actual name of the field in the...

Hello As a beginner I want to produce a report that gives me a total number of our clients, like Total number of current clients ...XX Total number of current male clients ...XY Total number of current female clients... YY Total number of discharged clients.....ZZ plus a few more totals I have...

I am trying to make a query that looks for a particular word in a text field, and gives me a list of people with that word only I work in a community organisation so I dont have much training, so its probably an easy way to do thanks for any help A:confused:

Hey guys new to Access so bear with me please. :confused: I want to add in a feature that will send an email or mesasage to outlook to remind us to do a follow up on clients after a period of time. ie. client makes contact and one month later we have to call them back... we need to be reminded...

hey sorry but real novice here :eek: and I would like to know where and if I can get a template I can use for client registrations? We need names, addresses, sex, email, plus other fields. We are a community group and I dont have the expertise or time to set it up from scratch. I tried...