Posted on 2002-05-13
Warning : I am a newby!
I created a form that is accessable via our corp intranet. When the user fills it out and clicks the SUBMIT button it is posted into our Notes DB (@Command([FileSave])).
This db currently has about 300 posts to date.
The form has many fields but in particulary there are DATE, SERIAL NUMBER, LEVEL fields.
I want to provide some sort a query option that allows a manager to punch in a starting date and a SN range or wild card (ie. sn= 7***** to get all sn starting with 7) and generate a report that looks something like this:
SN: 732344 DATE: 04/02/2002 LEVEL: 126.96.36.199
SN: 732345 DATE: 04/03/2002 LEVEL: 188.8.131.52
SN: 732346 DATE: 04/05/2002 LEVEL: 184.108.40.206
I am very new to all this so as much detail and hand holding would be greatly appreciated and rewarded.