Using Access as a magazine subscription database

[kashrus]

I am using Microsoft access for a magazine subscription database.


I need help with the following:
1. When I enter a start issue# and number of issues for a subscription, I need Access to calculate the end issue#
2. I need the end issue to then be converted to a date (I have a list with all issue numbers and their corresponding dates)
3. I want the subscription expiration date from the "subscriptions" (child/sub) table to appear next to the subscriber's name on the "subscribers" (parent/main)

[June7]

1. see reply in your other thread

2. build query that joins tables on the issue numbers

3. probably same as number 2