Search results

I need to create a report that is similar to a pivot table. The pivot table function itself is not working for me because it does not look very professional. Basically I need to have a header (with a single value), then a subheader (With three values - min, Avg, Max) with row data and values...

This link on this forum is talking about what I need, but they did not post their solution - http://www.access-programmers.co.uk/forums/showthread.php?t=130382

Sorry about that, I was hoping to get an answer back form the people who worked on this specific issue. I will start a new thread.

May I ask what code you finaly came up with. This is very similar to an issue I am attempting to resolve. Thanks so much?

This code worked for me: Public Sub CreateYears() Dim rst As Recordset Dim rsttemp As Recordset Dim x As Integer Dim mydate As Integer Dim lastamount As Variant x = [EndYear] - "2000" + 1 y = 0 Set rst = CurrentDb.OpenRecordset("select * from tbltable1 order by id") Set rsttemp =...

I am working on a database tracking job costs and future projected costs. So my form has (and these are user defined so they will change, but I am using queries to update my table to that is OK): Filter for multiple jobs Beginning date (User Defined, will change) = 2004 Ending date (User...