Using reports to make an index of sorts

[Reynastus]

[SOLVED] Using reports to make an index of sorts

Hi All

So I have a database that I am working on and have not populated just yet. One of the desires for this database is to be able to press a button which would open a form then select a drop down option that would match a description of a department (this is no problem, It's not in the database just yet however). What i would then like to happen is for a report to print or preview all the documents that match the department criteria.

I have a complete report working fine but I have noidea of how to sort the results to only show those applicable.

Any ideas? I'm sure its something simple I'm just new to access and learning things still.

Thanks in advance
Rey

 

[pbaldy]

Would this work for you?

http://www.baldyweb.com/wherecondition.htm

 

[Reynastus]

Hi

Yeah Baldy that helped and the explanation helped more than anything else.

I actually muddled out the answer after searching the forums here a little and finding a solution. I would post the link to the solution but I am not allowed to

But your Link helped to understand better

Cheers

Rey

 

[pbaldy]

Glad it helped, and welcome to the site by the way!

 

[Reynastus]

thanks for the welcome and thanks for the link to you site ... I can see me forming more databases now with that as a reference :S