Recent content by DaneS

I just figured it out thanks to another user's help. I needed to change the Group By option to Expression on my calculated field. Thank you though!

Hi, I have a query that contains the fields: Earnings | Hours| Efficiency: =[SumofEarnings]/[SumofHours] (the = is only here on the forum to prevent a smiley face from occurring) Now, when I run this query, access doesn't recognize SumofEarnings and SumofHours and it asks me to input a...

That was it. Everything works perfectly. Thank you!

Currently trying to figure out how to move the copied cells down one row. xlWS.Cells(lngRow, 1).CopyFromRecordset rst copies them to the last row of pre-existing data.

It's exporting the data now, but it's not copying the column headers. It also overwrites the first line of existing numbers each time I run the macro. Edit: I don't want it to copy the column headers. Hah! Half of that problem solved.

Hmm, I seem to be getting this error when I call the function with a button: The debugger highlights this part of my code and says xlCellTypeLastCell = Empty lngRow = xlWS.Range("A1").SpecialCells(xlCellTypeLastCell).Row

Great, thank you very much :)

Will this work if I want to code it into an On-click button command on one of my forms? ex. Private Sub Button1_Click() I'm looking into it now..

Ah, sorry! I'm trying to export the results from a crosstab query named "Kronos" to an excel spreadsheet named "Variance". The data is a single row of 6 columns that I want to append to the spreadsheet once a week, which means I want all of the previous data to remain unchanged.

Anyone?.... Bueller?

Is there a way to do this?

So I've managed to create the query I wanted, but I'm still having trouble exporting the table to an excel sheet while keeping the previous data on that sheet. Any ideas?

Maybe this belongs in the Query section?

Hello, Here is my setup. I have one Master Table containing data from multiple departments. I have 5 queries, one for each department, that sort my data. My goal is to take the average of one column from each query and export them to an excel spreadsheet. The spreadsheet would look something...

We don't have leaders leading, we have zombies following.