Reports

[rgreen]

Hello. I have met a stumbling block. Any help is greatly appreciated. My issue is creating a report that will display information about all employees whose last donations were >= 58 days ago. ??

[orange]

Readers need to know more about your tables and relationships, and what your database is about.
You mention Employees and Donations - that's a start.

Have you tried getting the info you need via a query?
Then use that query as the recordsource of your report.

[rgreen]

Okay, here's what I have so far.Blood Donor1.accdb

[orange]

You should have an EmployeeTable and a BloodDonation table
Employee table like you have.

But the donations should be something like

DonationId PK
DonationDate
DonorId <--------FK to Employee

The tables have this (1 to Many) relationship

Employee----> BloodDonation

You know the Bloodtype from the Employee table. You set up the relationship on EmployeeID and DonorID
You do not record the FirstName LastName etc in the BloodDonation table

You can have as many Donations as you want. When you name fields Donation1, Donation2... it's a flag saying this is probably not normalized(structured properly).

You do NOT make firstname the primary key of a table. You want a field whose value will be unique in every record in the table.

Good luck.

[orange]

Here's a revised database.
2 new tables MyEmployee and BloodDonation
Append queries to Populate the tables
Select query to show BloodDonationsByEmployee

Look at the table structures, and the relationship in the relationship window.

If you have not done so, spend 30-45 minutes with this tutorial. You'll learn more in that 45 minutes than in a month of "playing with access".

Good luck.

[orange]

I'm expecting a response to the PM info here. You should work through the tutorial mentioned in previous post.

[rgreen]

Thanks for the help Orange. I think I'm back on track now.

[orange]

Spend some time with that tutorial. It will put things into perspective.
Post back with questions if they should arise.

[rgreen]

Okay, I will. Thanks for your help.