Greetings to All!
I am writing a report entitled, "EQUIPMENT LIST". In this EQUIPMENT LIST, I'm including such fields as: Equipment Number, Description, Model Number, Serial Number, and Project. Yesterday, I was able to create a report based on these fields and sorting on any ONE of those fields.
I have been trying to revamp that report now to allow the user to choose to SORT/GROUP BY on either the PROJECT field (with many choices under this field) or the LOCATION field (also containing many choices). Although, what I would REALLY like to do is set up a report that would allow me to choose a PROJECT (ie, ABC-123) and choose a LOCATION (ie, 00015) and only return me information from PROJECT 'ABC-123' and from LOCATION '00015' and give me a choice as to which field (DESCRIPTION, S/N, or even MODEL NUMBER) to sort by. (And of course the rest of the fields populate, accordingly.)
I hope that I haven't confused anyone. I have been playing with this report for most the day only to become upset and not produce anything.
PLEASE HELP! I'm so frustrated right now.
Thanks,
Cherrel.
I am writing a report entitled, "EQUIPMENT LIST". In this EQUIPMENT LIST, I'm including such fields as: Equipment Number, Description, Model Number, Serial Number, and Project. Yesterday, I was able to create a report based on these fields and sorting on any ONE of those fields.
I have been trying to revamp that report now to allow the user to choose to SORT/GROUP BY on either the PROJECT field (with many choices under this field) or the LOCATION field (also containing many choices). Although, what I would REALLY like to do is set up a report that would allow me to choose a PROJECT (ie, ABC-123) and choose a LOCATION (ie, 00015) and only return me information from PROJECT 'ABC-123' and from LOCATION '00015' and give me a choice as to which field (DESCRIPTION, S/N, or even MODEL NUMBER) to sort by. (And of course the rest of the fields populate, accordingly.)
I hope that I haven't confused anyone. I have been playing with this report for most the day only to become upset and not produce anything.
PLEASE HELP! I'm so frustrated right now.
Thanks,
Cherrel.