Report with only select records in table

[undefeatedskillz26]

I have a master table located on the backend of the server with about 3 fields:

Software
Version
Description

I have 4 databases, one for each software on the front end accessing this master table.

So far I have in the master table a dropdown to select 1 of the 4 software's, the version number and a brief description.

One the front end I have a button that when pressed will bring up the report based on the master table.

Can I have the report just select the software that it refers to. For instance if the datebase is Sony when I click on the report it only grabs the records with Sony on it. For my next database when I open up Sharp's database it only makes a report for the Sharp records.

How would I do this? Is this something I have to code or something I can do in criteria or do I create a query?

Looking forward to knowing how something like this can be done.

Many thanks for taking your time to reply to this. You have no idea how much I appreciate it. I really am thankful for this.

UPDATE: Now that I wrote this out and thought about it even more I am pretty sure it is just making a qry for each database and having it only pull up certain records from the table and than creating a report off that. If there is an easier way let me know. I not I think I'm getting more confident in Access. Thanks!!!!

 

[jdraw]

Normally in a split database set up (consider all Access here) you have a front end with queries, forms, reports, macros; and a backend with Tables.

What exactly do you mean you have

I have 4 databases, one for each software on the front end accessing this master table.

It sounds like you want a query to select the data you need, and make that query the recordsource of the Report. But that's a guess on my part.

You may get some ideas from Martin Green's site Dynamic Reports.

 

[undefeatedskillz26]

Normally in a split database set up (consider all Access here) you have a front end with queries, forms, reports, macros; and a backend with Tables.

What exactly do you mean you have


It sounds like you want a query to select the data you need, and make that query the recordsource of the Report. But that's a guess on my part.

You may get some ideas from Martin Green's site Dynamic Reports.

Okay great I will run a qry for each database.

I have one backend database. I have 4 front ends each front end is to a Software.

For instance 1. Sony has a Front end is Access 2. Sharp has a front end is access, etc. I want to combine all the font ends together but have to make sure the backend has all the tables needed before I can proceed. Hope it makes sense if not please ask and I will explain more. Thanks.