Report of only one entry
- Thread starter capsula4
- Start date
- Local time
- Today, 12:31
- Joined
- Aug 30, 2003
- Messages
- 36,157
You can either add a criteria to the query or use the wherecondition argument of OpenReport to restrict the records displayed on the report. Typically master/child links would handle the items in a subreport.
- Local time
- Today, 12:31
- Joined
- Aug 30, 2003
- Messages
- 36,157
The terms you want to search on are "parameter" query to add a criteria (you'll use the Criteria row of the query design grid). For the wherecondition, look in VBA help at OpenReport; the wherecondition is one of its arguments.
I'm not sure how this should work.
I added a parameter using a column's name. When I enter the query it asks for the parameter value but it doesn't filter the query.
Nevertheless, when I create a report using that query, it asks as well for the parameter but this time, it does filter!!
Is this the way it works?
I added a parameter using a column's name. When I enter the query it asks for the parameter value but it doesn't filter the query.
Nevertheless, when I create a report using that query, it asks as well for the parameter but this time, it does filter!!
Is this the way it works?
Oh, this time I didn't use criteria! I just created a parameter in the Query.
Example of query:
[TRANSACTION N°] | [PRODUCT] | [PRICE]
-----------------------------------------
1 | GARLIC 1 | 5
1 | GARLIC 2 | 5
2 | GARLIC 1 | 6
3 | GARLIC 3 | 2
Then I add as parameter "TRANSACTION N°"
Each time I enter the query, it asks for "TRANSACTION N°" and I may enter 1 but shows the 3. Instead, when I enter the report based on this same query, it would filter without any problem.
If this shouldn't be like this and u have any idea of why this might happen, I appreciate it.
Hey! Here I have attached a sample DB using the parameter, but it is not working okay.
In the query, it doesn't filter.
In the report, it just shows one persons name, but it shoes the items of the rest of the people.
In the query, it doesn't filter.
In the report, it just shows one persons name, but it shoes the items of the rest of the people.
- Local time
- Today, 12:31
- Joined
- Aug 30, 2003
- Messages
- 36,157
Okay, you entered it in the parameters declaration area but didn't actually make it a parameter (criteria). Try this
PARAMETERS [Enter Name] Text ( 255 );
SELECT PERSON.ID_PERSON AS PERSON_ID_PERSON, PERSON.NAME, PERSON.SEX, items.ID_ITEMS, items.ID_PERSON AS items_ID_PERSON, items.[ITEMS BOUGHT]
FROM PERSON INNER JOIN items ON PERSON.ID_PERSON = items.ID_PERSON
WHERE (((PERSON.NAME)=[Enter Name]));
PARAMETERS [Enter Name] Text ( 255 );
SELECT PERSON.ID_PERSON AS PERSON_ID_PERSON, PERSON.NAME, PERSON.SEX, items.ID_ITEMS, items.ID_PERSON AS items_ID_PERSON, items.[ITEMS BOUGHT]
FROM PERSON INNER JOIN items ON PERSON.ID_PERSON = items.ID_PERSON
WHERE (((PERSON.NAME)=[Enter Name]));
