Search results

You are absolutely and completely amazing and you totally and utterly made my weekend great! Thank you so much for blessing me with your time! I appreciate you so much! I will have no problem at all editing this to work for the other tables. Thank you so much! - Tiffany

BP- Thank you for your help. I self taught myself on just the basics so SQL seems a little out of my reach yet. Attached you will find my zipped basic db. I removed all the confidential info so many columns are blank on purpose. I can't tell you how much I appreciate your help...

BP- I've been trying to figure this out and haven't quite got a handle on it. I've got my tables transferred for the first database, my new column that's blank and my relationships established. But how do I get Access to recognize the old ID, match it with the new ID and put it in the empty...

Thank you! You just saved me HOURS!!!!

So I would enter the updated numbers one at a time in the empty field? (after doing the process you just explained?)

Good afternoon. I have a problem. Lol. Who doesn't? Alright, I have 5 different databases that hold the same information on different computers in different offices. We are finally going to move to a network style of operation so I need to turn all 5 databases into a single database. In...

Thank you very much for your help. I got it!

Hello! If you are willing to help a newbie I would very much appreciate it. What I'm trying to do is this: Table One: Volunteer Name Table Two: Volunteer Hours entered by two columns: date and hours The tables are joined by a volunteer id number. What I would like to do is have access give...

Oh my... I changed the join type on the table relationships, not in the query. (blush) I now understand what I did wrong with your pictures. Thank you very, very much for your time. May you be blessed today as you have blessed me.

Alright, here it is. I need to get the volunteer names and the processing data. VB Volunteers Query 2 is just the name query when I'm only getting 29 out of th 42 records and VB Volunteers Query is for their processing information as well, and again I only get 29 records in result.

I edited it as you explained above and only 29 of the 43 results returned. Maybe its something basic I'm doing wrong because I created another basic query (based on only one table) and only 29 results returned again. Thank you for you time helping me out, I really appreciate it. Oh, and I...

Yes, it is based on two tables.

Good Afternoon, I am very new to Access. I only create queries through the wizards or in design view. The problem: I've created a simple query that pulls data from two seperate tables. Yet when I look at the results about 10-15% of my entries don't come back when they should. I'm...

Wow! That's so easy. I'm a total newbie! Thank you so much. You have no idea how much you've helped me!

Thank you to all you who are willing to help! I'm new to Access. I have an old database (that I didn't create) with the following tables: Parents Children Lesson's Watched Purchases Visits I created a new database (empty currently) that has similar tables (and more new ones) but tracks...