Custom reports

[moishy]

Hello All,

I'm dealing with a Real Estate db. One table (tblProperties) holds all available properties and their information, another table (tblRequests) holds all clients and what they're looking for.

I need to create a report for each client (from tblProperties) based on the information they're looking for from (tblRequests).

I would imagine that I would need to loop thru a recordset and somehow create the were clause, but unfortunately at the moment it is all a bit over my head.

All help will be appreciated (I'm under a very tight schedule so I'd appreciate if this time I can get less prodding in the right direction and more concrete solutions).

 

[Trevor G]

One quick idea,

Create the query from the 2 tables then set up Mail Merge in Word and you can connect to the query as the source that should work for you, use the Word Mail Merge Wizard.

 

[moishy]

I would like to have it self contained in Access (I already prepared the layout).

 

[Trevor G]

I would like to have it self contained in Access (I already prepared the layout).

If you have this laid out, then have you a group header for the client/customer and in the design section add your fields in place then you can force a Page Break after/Before the Group, that would give you individual information per client/customer.

 

[moishy]

No, what I have laid out is the set up of the property information, there are no groups. Maybe I'll give your idea a try.