**Microsoft Office Access 2007**
Looking to replace my Excel 2007 issues tracking list with one in Acess.
Select Project (from list)
Select Report type (from list - it meeting, phone conversation, shop drawing, ect....)
Default meeting number = date/meeting number for day. Example 20091214-01 would be the first meeting I had today.
Location (from list, IE Architect's office, Engineer office, PGM' office)
Maybe a 3 line area for notes where I can write objectives or introduction.
Select Atendee (from list? - includes name, company, email, phone)
Select Distribution Cc (from same list as atendee)
Then for each item I can write:
Each item defaults to number = meeting number - item. Example from above: 20091214-01-01
Area (from list - ie Site, Main House, Pool, Dock...)
Responsible Person (from list above)
Status (from list).
Resolution box below comment
I would like to have 3 or 4 pre-set reports that I can filter.