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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query data with wizard
- Thread starter theinvid
- Start date
synapsevampire
Programmer
You'll be best served to provide example data and expected output for questions.
I haven't used the report wizard for quite some time, but I think that it has a record selection area, which would allow for filtering at creation time.
Once you've created the report, just go into Report->Edit Selection Formula->Record and place your criteria, such as:
{table.state} = "CA"
You can also create parameters and reference them, such as:
{table.datefield} >= {?MyDateParm}
-k
I haven't used the report wizard for quite some time, but I think that it has a record selection area, which would allow for filtering at creation time.
Once you've created the report, just go into Report->Edit Selection Formula->Record and place your criteria, such as:
{table.state} = "CA"
You can also create parameters and reference them, such as:
{table.datefield} >= {?MyDateParm}
-k
- Status
Similar threads
- Locked
- Question