Results 1 to 2 of 2

Thread: Grab particular data and output selected data?

  1. #1

    Grab particular data and output selected data?

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I am volunteering for work at an not-for-profit organisation that provides care and food for animals in shelters/pounds in which recently I was asked to assist them in managing their tasks...

    Given these tables:
    Click image for larger version. 

Name:	tables.png 
Views:	22 
Size:	28.2 KB 
ID:	2685

    If an employee wanted to produce a report of not only feeding tasks but also other related data (in other tables) for a particular date, how could this best be done?

    i.e. for 8/04/2014, listing the animal no, shelter held, extra info, food name (from FEEDING TASKS table), food amount, cost of food (from FOODS table), phone no. of the shelter concerned (from the SHELTER table),

    Now I forgot to put it in the sample data in the image above, but what if a particular feeding task also occurred on the same date, as say, animal no. 503, on 8/04/2014, how would I generate data for TWO feeding tasks? OR 3... if 3 feeding tasks occurred on the same date specified? Or 4... so on, so forth...

    Is the use of dynamic arrays and extending it (using UBound(array)+1) for each feeding task occurrence be the most efficient in catering to this, because you do not know what size to specify for a fixed array (since you do not know how many feeding tasks is present in a particular date)?

    Or what would be some other ways?

    Thank you

  2. #2
    I have attached the Excel file thanks.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts