thanks for your help.
crystal ver is 10 standard.
using access db
master table has a social security number and info like name, address, phone, etc. key field is social sec number
linked table 1 is vacation days used. foreign key is social security field from master table. all it really has in...
3 tables - employee, sickdays_used, vacationdays_used
key field is social security number.
i would like to group by ssn. in one detail section show vacation days used. in a second detail section, show sick days used. the report would look something like the following:
ssn: 222-33-4444...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.