Search results for query: *

Thank you.

Ok, this is weird. When I first add the ERRORS_MADE table to the query and switch to Datasheet view, all of the PICKED_UNITS totals are totally messed up. However, if I sort the query by any field (example, employee's last name) then after sorting all of the values are correct. Huh???

Ok, here's the deal. I'm hoping it is something easy to fix and that I'm just a boob. I have three tables that are linked by a relationship. First: A list of employees with a field indicating each's unique employee identifier (CLOCK_NUMBER.) Second: A table tracking the number of units...

Thank you.

Awesome, thanks so much again for your help, it is really appreciated! Number of records per day would be 800 or less, so I'll try the recordset option first and let you know how I make out. Cheers!

Of course (my luck) the data for the reports is contained in a different recordset. In your opinion, which solution would be easier for a rookie to sort out? The SQL solution, or trying to work with the other recordset?

Success! I got it working by patching together a few different code examples by Remou (thank you yet again!) I've attached the code in case anyone else is trying to do something similar. I'm sure it's not the most efficient in the world, but it works so I'm a happy fella. My one last...

Awesome, thanks very much for the tips! I'll let you know how I make out.

Hi all, I have a multi-part question here. I have a database into which I import an Excel spreadsheet containing details of all of my day's shipping information. The table this info is stored in has a relationship to my master customer list which has a list of email addresses. Here's what I...

Hi guys, I borrowed the following code from a post by Remou (thanks!) which attaches an RTF document to an email as the message body: Sub RTFBody() Const ForReading = 1, ForWriting = 2, ForAppending = 3 Dim fs, f Dim RTFBody, strTo Dim MyApp As New Outlook.Application Dim MyItem As...

Hi guys, I'm a big of a VBA noob and I have a big task that I need to get going. Essentially, I have an Excel spreadsheet that contains shipping information for all orders processed in a day. What I would like to do is import that spreadsheet to my Access DB, have Access compare the customer...