Problems moving database info into report

[stanger1]

I need some help with moving some database information into a report. I have a main database set up with all the required fields that I need. I have a form set up to enter one field - tax year. Tax year is set up as an extra field that I need to use to compare with 3 tax year fields. (year 1, year 2, year 3) From tax year, I want to be able to find records that have this particular year in fields year 1, year 2, year 3 and dump this information into a report. So far I can only find one record out of several that I need to find.
Any help would be greatly appreciated

 

[paulbent]

You first create the report to display the data (for all records) as required. Then you create a named find to restrict the displayed records to those that match the find conditions.

The tax year field should be a variable field, say you name it vTaxYear. Create the named find on a form in Browse; from the menu, Create - Named Find/Sort - New - View. Click in one of the year fields and enter this condition, substituting your own table and field names which must be enclosed in quotes if they contain spaces:

If(Tablename.Year1 = vTaxYear or Tablename.Year2 = vTaxYear or Tablename.Year3 = vTaxYear)

Hit Enter, type a name for the find and OK out.

You can now define a macro to switch to the report, run the named find and sort as required.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[stanger1]

Thank you for your help!