Search results

Once again thanks for the quick reply, I'll try this as soon as I get a chance and let you know if it works :)

Thanks for the quick reply, but this is not exactly what I'm looking for. The query that you suggest would give me the Address field only. That can achieve by a SELECT DISTINCT statement as well. I want to select FirstName, LastName, Address from a table, but in the case that 3 people live in...

This is another newbie question from your friend Fdisk... I have 2 tables with the exact same records. On has the addresses separated by house number, st, direction, type, etc. The other has the address in full. I want to select * but only households, not individuals. If I do SELECT...

Thanks! That thread worked, I guess you are much better at searching than I am :( Thank you for the quick reply, this is the best forum I have ever been to!

I looked through the forum and found similar threads but none that quite answers my question. I have a table with a birthdate field like 07/08/1973 for example, what I want to do is a simple query that will give me a list of the people whose birthdays are between 7/19 and 8/31 inclusive. I...

Thanks for the help hahahahaha you just made me laugh out loud. I'll be damned, I guess it was a freudean slip after all. I love databases, Access and SQL, I love it, and this database is one of my babies so I don't hate it, but I do hate this problem I've encountered. I'm the type of person...

I hate a database with a bunch of people and their address. Their address is divided as follows: House number, Direction (North West, South West, etc), Street Number, Street Type, zip code What I need to do is to create a query/report where I get a list of people that I need to go see...