Recent content by semry

I found my answer from a 2010 post from Rural Guy who posted the following link http://www.granite.ab.ca/access/email.htm Thanks RG

I want to do it from the Excel Workbook (Assignments) it is stored in using a command button. I already have a button that sends a separet workbook via outlook with the code below. but I can't get it to send one sheet from the active workbook. Sub SendWorkbook() Range("B12").Select...

I need to Email a single Excel worksheet (Status) from a multi sheet workbook (Assignment) as a PDF attachment to multi recipients. Any ideas?

When using the Report Wizard their is a box with fields on the left, arrows in the center that allows you to move the fields from the left to the right so you can use them to build your report. What is that box called and can you build one in Access? I don't have a project for it yet but...

AccessMSSQL, The single quotes worked Thanks VbaInet, Got it working. just needed to join them by BatchType

I've tried that before and it does not work. The sum of AMB between 1/1/12 and 1/8/12 is 208 not 1034. Also I need the sum of BatchTypes not batch names. When I remove BatchNames from the query I get what I need as far as BatchTypes for each Date period but the sum of BatchTypes for...

I forgot the attachment

Ok I will try and be clear. My tables/Queries are attached ProductyRpt FromDt - Date field ToDt - Date Field BatchType - Text BatchProd IndexDt - Date (Yes, this is a date) BatchType - text NumBatches - Numeric BatchProd is acutally a simple query of tables Productivity and BatchCtrl...

Now I think your F***ing with me Thanks for not helping

ProductyRpt FromDt - Date field ToDt - Date Field BatchType - Text BatchProd IndexDt - Date BatchType - text NumBatches - Numeric I need to sum NumBatches for each batchType that falls between FrmDt and ToDt.

I'm trying to sum the number of batches by batch type in table B that fall between the From and To dates of Table A

I've tried the links again and attached is what I get

Tried re-naming all my Dates, nothing. Also my first choice was to display my results in a query but I can't figure out how to calculate it.

I couldn't get it work. I keep getting an data type mismatch error calling it from a query

I have 2 tables like this TableA FromDate ToDate BatchType TotalBatches TableB Date BatchType NumBatches Is their a way to update the TotalBatches in TableA with the sum of NumBatches from tableB that have the same BatchType and falls between the FromDate and...