Search results

Thank you, I'll give it a try! Regards, Scott

I understand your answer better now, that I did some homework. Won't the query you suggested only be limited to new records? I also want to update the records in the original table with the data from the new table. Thank you for the help!

Thanks for the response Galaxiom, That is something I will have to look into. You gave me a new approach... My databases are fairly simple, I will have to look into the outer join relationship. Scott

Hi all, I have a spreadsheet that contains PC replated information, such as hostname, last logon date, last user login, BIOS date etc. I imported the spreadsheet into Access 2007 making the hostname field as my primary key. This is my master table. A couple of weeks later, I receive an...

Mihail- I used the answer provided by Perlfan. Thank you again, Scott

Perlman and Mihail, Thank you both again for your suggestions. My report now works correctly! Regards, Scott

Perlman and Mihail, Thank you for the suggestions, I will give those a try and report back. Much appreciated! Scott

Hello all, I am trying to add text to a report, and am having some difficulties. I am using Access 2007. My report is tied to a query. The query contains 2 fields- Hostname and MAC Address I want run a report against the query, but need to add several commas. So the output of the report...

Hi Polly, I would think based on the information provided the query should work. I have a couple of questions that might help the group answer your question. What error are you.getting if any? What results are returned? What type of query are you running (select, append e.g.)? Scott

Hello, My name is Scott. I am looking forward to chatting and getting to know everyone. I use Access 2010 at work and consider myself somewhere in the average user area. I look forward to learning much and meeting people.:):):) Scott