Search results

To get the formulas in the totals rows without doing it manually (though this is only semi-automated) I wrote a short macro in excel that would call the address of the cells where I want the totals as PayTotal1, FringeTotal1, etc for example. Then the formula would sum everything in that column...

Hello, I wasn't aware of a way to get the results of these queries into an excel template that is already created other than by creating these successive recordsets in a loop that reads of the task string and passes it to the sql string. How could I paste the results without resorting to...

Hi Bob, thank you so much for your reply! To explain my resoning behind inserting a range of rows before pasting: the reason I wanted to grab and insert the entire strSQL2 recordset into inserted lines is that the way I have the template set up, the second section of the report starts right...

Hello, I am working in Access and Excel 2003. Here is my goal: to create a copy of an existing Excel template in vba from access, paste results of a vba-defined query recordset into the Excel workbook and open the workbook. My entire code is below. To give a little detail: the macro is supposed...

Thanks jdraw! I will test out your solution on dummy data too.

Hi jdraw, No, this is a simplified version of the sql I used. But other than the missing commas- please tell me what other syntax issues you see. I figured I wrote that correctly in terms of syntax, so it would be good for me to get your corrections for future reference. Thanks! After...

Hello, I have googled this extensively, but couldn't find the answer, so decided to post here. I am working in Access 2003. I have a long MonthSalaries table of each employee's daily earnings, a main Employee table with employees' main attributes, and a Fringe table that details their alloted...

Hi jdraw, yes- I ran your query and it returned the expected counts and the correct number of records in the Task table- 210. I agree that I am having corruption issues, though no one seems to be able to figure out how to fix it...

Thank you for following up! To answer your questions: 1. There are no nulls in first or last names. 2. The spelling is identical. All the names in Employee_Temp are lower case and in the EmployeeTask they are a mix of lower case and upper case. However, the records that were successfully...

Hi AccessRookie, I tried the select statement with an inner join and the it's not giving me the expected results: it shows only 21 people as non-nulls in the Employee_Temp Last and First name fields. There are over 40 people who I KNOW are both in the Employee_Temp AND the EmployeeTask tables...

There are no blanks in LastName or FirstName- I am using LastName, FirstName and TaskSubcategory as the primary key (several tasks for each employee). So the update query that I tried is strange in two ways: 1- when I try the left join (because there are some people in the Task table that are...

Hello, sorry- I am missing the from clause of your query. Thanks.

I just tried it with an inner join, and it doesn't solve my problem- it updates a slightly higher number of records (21) but still not all of them. Any ideas where I could be going wrong? Thanks!

Hello, I am working in Access 2003. I am trying to run a simple update query: update employee ID based on last name and first name. The problem is that the query updates 7 records out of over 300, leaving the rest null. I can't figure out why that is. All the first and last names come from the...

Thank you for your reply. I have resolved the syntax issue in a somewhat similar manner. However, the issue with code being randomly erased was caused by a network problem associated with my account- the IT folks are checking up on that. It seems that it had little to do with the application itself.

You are most welcome. You should be able to produce a sample yourself with the example you gave me. For example, if you have it Items table two entries: Item1 Item2 and in Withdrawals table three entries: Item1-- 2 Item1-- 4 Item2-- 8 the query I gave you should give you the following...

You need to have a table that stores all the unique Items in your Withdraws table. This table (call it Items) needs to be in a one to many relationship with the Withdraws table (that is, for every unique item in the Items table, there can be more than one entry in the Withdraws table). Then you...

Select sum(FieldName) as SumofField from TableName where FieldName like '...' or FieldName like '...'; Am I misinterpreting- are you looking for something that is not a simple sum? Please explain.

Help! Something wacky is going on with the query sql editor. I write a query, save it, run it. It runs fine (doesn't give me the results that I expect, but that's because I'm probably doing something wrong with the functions I'm using- but that's my own problem and I know it). Then, if I close...

Well, my problem is more or less solved via the method I mentioned two posts ago: the ultimate goal of this query was a vendor profile report, so I am simply using the two subqueries as subreports and summing the fields on the main report. However, I left the post open to see if anyone could...