summaries in value lists

[pensive]

Hello all,

please forgive me, as i have done my 'searching' and seem to have found 30 people with the same question as me, and about 30 different answers. all of which seem to confuse me. sorry i'm a newbie.

i have a value list for medications. listing off 30 meds. and i need to make script to submit a report showing all of the 'medications' in the value list 'medications' along with how many times each of them occurs throughout the records.

**Please keep in mind, these values show up in a portal** as i'm sure that has to do with the problem.

ie.

Accupril 18

Actos 4

Altace 0

Clarinex 6

etc.

I would also like to eventually select a range of dates for them to count for... letting the user enter the dates she would like the report to include.

is this something i can do with calculation fields, or summary fields? or do i have to make a report?

can someone please help me.

you guys are the best, and have always come through in the past.

i'm forever indebted...

pensive...

[pensive]

okay, so i think i may have figured out the summaries issue. however, is there an easy way to let a user specify the 'date range' for the report to be run?

here is the script:

Go to Layout ["Medications Report" (Medications)]

Sort Records [Restore; No dialog]

Enter Preview Mode [Pause]

Enter Browse Mode

Go to Layout [original layout]

i have time stamps on all the records. so i think i might be able to use that.

any ideas???

thanks in advance.