Search results

Thanks for your quick response. It does help thanks but only if I take the date criteria out. If I put the date in and want to run the query >#01/01/2012# And <#31/12/2012# with the between 2 dates options I get the results all separated again. Help!

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...

Ok, figured it out thank you. I hadn't put the brackets in the right place hence the error.

Yes, but how do I put it all together in a query. I can get it to do one name eg.... Labels: Left([First Name],1) But am not sure how to word the whole query with ...Mylastname, N. & L. I can do a code that gives me Mylastname, Firstname & Secondname but I only want the first initials for both...

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.