Array beginner

[cath_hopes]

Hi there

I want to build a report (based on a query) and think that using an array is the best route except I've not done one before. The report is to list the days of a month down the first column. Each subsequent column is to hold diary details for an individual clerk (which are held in my database). A user would select the report for a particular month's details.
It would look something like this:

Worksheet for May 2008:
Day/ Clerk: Sally John Bob Jane

1 wrkgdtls jjj hh jkl yuoyo

2 hhh dgf tyu ruo j

3 kkkk ,,.

4

I've got a Dummies Access 2007 all-in-one reference book but would like some more help in understanding what I need to do. Can anyone recommend any websites/ online tutorials that could help? Or is it straightforward enough to explain within this forum?

Many thanks in advance,
Catherine










I've got the Dummies books

 

[jzwp22]

It sounds like you could probably use a cross tab query to get the format you want and you could set the record source for the report to the crosstab query.

As you mention, you can also use an array but you will have to load the array using a recordset which is generally based on a query & is done with Visual Basic for Application (VBA) code. The problem with using an array is that you cannot base a report on an array directly. So what I have done is to dump the array data into a temporary table and then use the table as the record source for the report. There is a good book out there: Access VBA for Dummies, but I'm not sure if there is a 2007 version yet. If not, a previous version should be just as helpful.

 

[cath_hopes]

I've now read up on cross tab queries and created one for my report and it all works a treat. Very straightforward. **Thank heaps** for pointing me in the right direction - I've been scratching my head for a few days over this one. I've some filtering issues for when it loads so I'll probably start a new thread for that.
I have also got Access VBA for Dummies and it is the 2007 version.

 

[jzwp22]

I'm glad the cross-tab query worked out for you. Good luck on the project.