"help in generating invoices using access"

[kashu]

Hi there!
i have developed a payroll program to generate payslips for four different companies ,two of them weekly and two of them biweekly.My program works fine now i have to customise the user interface ,from main swichboard i need to call a invoice form ,from thatform i need to enter the weekending(which i can do)and then i have to choose the the company(which i have put in option groupform)to print the invoice,i have two query(weekly & biweekly) for all four companies i need to know how to connect every thing together so that i can print the invoice for all four(in there report there is different percentage of adminstrative fees) and for one company we pay them biweekly but we invoice them weekly.little complicated???//// i am too confused desparetly looking for a solution anybody listening????????HELP!!!!!!
thanks
galaxy

 

[Trendsetter]

A simple way would be to have a different version of the invoice (with the various administration fees) coded against each of the option buttons that can be selected.
Or
You could use Case statements to specify the content of specific invoices dependant upon the option button selected