Thanks,

Is there any chance you could help me with my ealier thread. Trying to compile a single record of many records. I have a vacation table and each person can have several entries. I want to have a table with one entry per person and the fields as vacation1, vacation2, etc. For charting purposes.