Recent content by vgillis

  1. V

    Flatten Data

    Hi All. I have a table with giving history. Fields I need are 1. Gift Date 2. Gift Amount 3. Gift Designation A person can have 1 gift or multiple gifts. A vendor I am working with needs this data flattened The table would look like this: Gift1, GiftDate1, GiftDesg1, Gift2, GiftDate2...
  2. V

    Displaying field values vertically

    Hi all..I don't know if this is possible or not..but any help would be so appreciated. This is a scaled down version of my problem.. Two tables.. Person id number name activity id number activity A person can have multiple activities. Instead of the report printing a row for each...
  3. V

    Using a table in a query multiple times.

    Hi all. I have a question. I have a table...lets call it name1. I have another table called Restictions. This is a one to many relationship. What I want to do is have a record based on criteria pulled from the restrictions table so that each critieria is in a seperate field. This is what I...
Top Bottom