Replies

Lagare thank you for your assistance. This did exactly what I had asked, however, I had not given it a thought until I ran this Macro that each sheet has to have a new fortnight starting date at cell N3. This being the same date as the Worksheet Tab.

Also a starting amount of hours (Positive or Negative) is carried forward from a sheet called the Master and form there on carried forward to the next worksheet. Is it possible to include these two actions into the same routine?

I have attached the file in the hope that what I am describing will make more sense.

I have also considered that perhaps the Master and Template could be one in the same.

Opinions are welcome.

Thankyou – too easy!

Much appreciated.

Yes that does explain it and I have done it on my report. I hadn’t ever looked at this area in a crosstab before, so you have taught me something I will surely never forget.

I am on my way now and my database is really taking shape thanks to your assistance. I may come back here at some time in the future if I come across any new hurdles.

Keep well

Regards Kerry

Thankyou Charlotte – you are a marvel! You really have me on my way now. I have managed to get a pretty good looking report with your crosstab idea.

One question though … can you eloborate a little more on this statement?

You would need to preset the column headings property to the particular courses to make sure you get all the courses in the query even if no one has taken that course.

No quite sure what you mean by this.

Also I take your point on the colors. It is a bit Yuk, but I was a desparate woman!

Thankyou.

Kerry

whoops – hopefully this has the attachement – Told you I was new!

Thanks Charlotte – FK – PK – so obvious now.. I feel like a real dope! SSN … I can be excused for as it isnt such a big deal in Australia.

I have attached a Word Table showing what I envisioned the end result would look like. This is the best way of trying to explain. You may have better ideas. If this is not possible then it isnt worth pursuing any further with a database.

Your feedback is appreciated.

Kerry

text

Thankyou Charlotte for your reply. To assist with understanding your response can you tell me what “FK”, “PK” and “SSN” stand for?

I have actually set up tables pretty much as you suggested. I am finding that I can enter the information in correctly, however the retrieving of information in a report showing a summary of what is NOT done is causing me a headache.

I am starting to wonder if I would be better to use Excel and have a worksheet for each course and one for staff then link it altogher in on summary Worksheet.

I can send you what I have done and the view of the desired report if you wish.

Regards Kerry