Search results

I'm creating a query to breakdown timesheet hours by activity, this much I can do: TRANSFORM Sum(tbl_Timesheets.Duration) AS SumOfDuration SELECT tbl_Activities.Activity FROM tbl_Employees RIGHT JOIN (tbl_Activities RIGHT JOIN tbl_Timesheets ON tbl_Activities.Activity = tbl_Timesheets.Activity)...

I must be missing something basic here. I'm looking for today's date, but when I run this, Msgbox Date I get yesterday's date. I've checked that the system date on the computer is definitely correct, so what else could be affecting it? I've already searched for answers, but no luck

I've trying to produce a crosstab query with employee numbers as the row headings, billed activities for the columns, and duration sums as the values. When I run the code below, the output is correct and shows all activities, even activities with no hours billed to them: TRANSFORM...

This was working yesterday, but I've obviously changed something that was seemingly unrelated.:banghead::banghead::banghead: When using an SQL string with .OpenRecordset, I can use "WHERE [COLLATEDATE]<=Date();" without issue, but when I use "WHERE (Month([COLLATEDATE])<=Month(Date()));" my...

I've been beating my head against this one for a while now, and I'm sure I'm not the first person on the planet with this issue. I'm using a query to create a table. I then perform some VBA manipulation before outputting the modified table to an excel spreadsheet. The issue I have is that one...