Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parsing Data for Queries

Status
Not open for further replies.

kken

Programmer
Jun 5, 2001
51
CA
I am triing to run a report based on a group. This group is decided by the user on-line. What I did was concat the particular ids and pass them into the report.
This worked fine to get the values into the repot, but if I try parse the data in a formula field I can only get the first or the last value.
Does anyone know how I could parse the string to link to a query to get only those results back.
 
Hi

A subreport should do this automatically

You should be able to link the Group id from the main to the subreport. The subreport will be restricted to all records which match that constraint, and can be added to the group header.

Geoff
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top