Tracking Newsletter Reads in Access - Unable to figure out best way

[perpetual55]

Hello all!

I'm needing some help creating a query or something to help me track who and when reads our company newsletter.

For example:

I sent out the letter on Decemeber 1st, 8th, 15th, 22nd, 29th.

Person A read the 1st, 8th, and 22nd
Person B read the 8th and 29th
Person C didn't read any

I also want to be able to calculate the percentage of read newsletters. E.G. for Person C the percentage would read 0%.

---

I currently have a query that pulls information from a table to list to whom from our customer database we actually send the letter to. (Not all customers receive it.)

I'm having difficulty being able to take the information from this query and combine it with something that will display the dates the letter was sent out so I can e.g. make a crosstab query. Right now, I have a table that lists the dates but since the table is unrelated to all the rest of our data, I get an error message saying Access can't merge unless the data has a relationship.

--

Hopefully that makes sense. :)

[Rabbit]

The percentage would be calculated using the number read divided by number sent.

If sounds like you have a query that returns the letters sent. Aggregate that to get the number sent. Then do the same query on the "letters read table" to get the number read. Join the 2 result sets and you can divide one number by the other to get your percentages. After that, you can create your crosstab. Although I'm unsure why you would need a crosstab since you're not doing a x factor by y factor comparison.