PDA

View Full Version : How to grab particular data and output data?



Restricted
09-27-2014, 07:05 PM
Hello,

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:
https://hostr.co/file/970/haHvBMcQZUs1/tables.png

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

pike
09-27-2014, 07:41 PM
Restricted
please read
http://www.excelguru.ca/content.php?184-A-message-to-forum-cross-posters

http://www.mrexcel.com/forum/excel-questions/808236-best-way-grab-output-data.html

http://www.ozgrid.com/forum/showthread.php?t=191154&p=727591#post727591

Restricted
09-27-2014, 08:32 PM
Restricted
please read
Post denied. New posts are limited by number of URLs it may contain and checked if it doesn't contain forbidden words.

Right, ok thanks. In light of that, could responders respond to a single thread where there have been replies already, thanks.

Restricted
09-28-2014, 01:56 AM
I have attached the Excel file thanks.

Aussiebear
09-28-2014, 02:40 AM
Restricted, you are obviously not taking any notice of the cross posting issue at all given that you have uploaded your workbook here, as well as OzGrid. This thread is now closed.