Question with MS Access

[cchen]

Basically I have three tables. The first one lists some identifying information, and the other two list application data. The other two are basically like a checklist if the certain item uses that application.

I want to create a form that can display all of the data. However I only want to show the applications that the item uses and not show the ones that it doesn't use.

How can I do this?

A combo of query/ form? (ME = database newb)

 

[ojai00]

A query would be the way to go. Just enter the criteria you want and it should give you the display you want. Hope this helps.

 

[wyvrn]

Yep do a query, select the fields you want displayed. Then build your report off the query you created. If you want, I can email you an example of one I did for class.

 

[cchen]

How would I do it with a query?

Here's an example of what I want to do

Here's a table

Item blah blah blah
rifle a b c
tank d e f

another table linked to the first one

hunting eating war sleep blah
x x x (supposed to be under hunting eating and blah)
x x ( supposed to be under war and sleep)

So I want a form or query to look like this:

Rifle a b c hunting eating blah
tank d e f war sleep


something along those lines

a query could do that?

 

[wyvrn]

When you design your query, you can mark which fields you want to show. Run it to make sure it works. Forms are not what you want to display data, forms are primarily designed to accept input. You want to make a report to show the data. The report wizard will give you the option to use the query you save previously as it's base, and then format it the way you want. I emailed you my example, let me know if it helps.

 

[wyvrn]

Here is a good Access tutorial.

 

[cchen]

thanks for the example, but that's not quite what i'm trying to do.

i'll try to explain myself better


in this query, i only want to display the fields in the second and third tables if there's an x in the field

so for example, on the report it would look like this:

name of item other identifying information applications: (list any of the fields that have x's in them)

 

[wyvrn]

Is the x for a yes/no field? Or x as in any result that happens to have the letter x in it?

If the former, you can use query, display the yes/no field (in my example it would be the "outside only" query, and "outside only" field), then go to design view of that query and put Yes in "Criteria" field if you want to display a success, and No in "Criteria" field if you want to display results that are not selected. Here is a pic of my query in design view showing how I wanted all records with a check in "outside only" to be displayed. Then another pic of the result of the query. If I wanted to display all the customers that did not have the outside option, I would have typed in No into the "Criteria" field of the "outside only" query.

If the latter, I am not sure how to query fields for specific letter and then display those fields. I would suggest reading the tutorial for that.

That help?

Originally posted by: cchen


thanks for the example, but that's not quite what i'm trying to do.

i'll try to explain myself better


in this query, i only want to display the fields in the second and third tables if there's an x in the field

so for example, on the report it would look like this:

name of item other identifying information applications: (list any of the fields that have x's in them)