Carole- If the goals change and you need to keep a history, I suggest a SalesPersonGoals table:
SalePersonID, GoalType, GoalDate, GoalAmount Primary Key is the first 3 fields - and make sure the date is always a month end date. You could even easily add quarterly goals without having to change your table structure. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Carole Drake Sent: Friday, November 25, 2005 1:37 PM To: [email protected] Subject: [ms_access] Sales Report I am trying to make a report in the format my boss requires it, for salespersons, activity compared to goals for month to date and year to date. I have created the tables for salespersons, jobs, divisions, and products. Where do I put the monthly and yearly goals? I'm guessing in the salesperson table? Carole Drake Homewood Building Supply 3243 Rippey Road Loomis, CA 95650 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] 916-652-4655 phone 916-652-3860 fax [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/u8TY5A/tzNLAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
