Search results

Hi there, Hope you can help. I want to create a query (to base my report on) that totals up the amount of money a client has paid over the year. My table is simple, client id, date, and amount they paid. I can run a report/query by date ie. yearly but can't figure out how to just get the total...

Hi there, Really could use some help here. I may have the whole thing wrong. I'll give an outline of my database first. I have 3 tables. 1) Clubber contact info 2)Leader contact info. 3)Leaders who call....That means I have the list of Leaders again and use Their names to supply the emergency...

Hi there, I want to make labels. (That much I can do and can cantonate the first and last names ok thanks to previous helps from this site). I need to be able to have lastname, Firstname with only the first name initial not the whole name & secondname again with only the first initial like...

Hi there, have searched the forums and got some ideas but am totally new at this. I have built a database but it's not doing what I need because I'm not sure what structure, how many tables to use. I'll tell you what I need a database for. Hopefully you'll have some suggestions (I know you will)...

Thanks for help in advance. I am trying to write a query which would look like this....LASTNAME, firstname & secondname. However, if the secondname is blank I only want LASTNAME, firstname to show. I've tried using the build and all kinds of things but had no luck. when I run the query it pulls...

Hi All, I want to have a query that creates address labels from my contact list. How do I do that without duplicate labels? I have 2 or 3 children in one family and a separate record for each child but only want to send one mail out per family. Thanks for your help.