Report problem

[army182]

Hi before i start iam a beginner in access and my english isnt very well.



Iam creating report based on my database. the report is based on query which contains criteria that data will be selected by surname.
That works but i have need to display data like what kind a monitor this person is using. One user can have several monitors so i need to display like several lines in listbox. but criteria doesnt work on listbox it shows just all the data from row source forgetting about criteria. that means that i get data from all right columns but for all users.
I cant have a separate criteria in listbox query because then to report work user will have to write surname twice.

Pls help. I just need to get the same persons data in listbox. in textbox u can get several lines too as a result?

[recyan]

Would suggest
----------------------
1) Post your table/s used in query, along with a few data.
2) Post the query sql.
3) Post the result of the current query, that you are getting.
4) Post the ideal result, that you want.
5) Post What is happening in the report, if the query output you are getting, is correct ?

----------------------
The other option, if possible, post your db with minimum data & point out where things are going wrong.
----------------------
This will enable people to help you better & faster.

Thanks

[June7]

As recyan suggests, provide db for analysis if you want specific guidance.

In general, base the report on a query that joins tables then use report Grouping & Sorting features. Another approach is report/subreport.

Listbox is useless on report object.

Concatenating data from multiple records into a textbox would require VBA http://allenbrowne.com/func-concat.html

A dynamic parameterized query is one way to filter report http://www.datapigtechnologies.com/f...mtoreport.html