Access special list

E

EgX

Hi, i have a database, just that if i have a customer subscribed to 1 and
another to 2 in the program A, i want to get the list of all the program A.
But the database i have only get the people that matches either 1 or 2. Can't
have a list of all A.

Context: ive a program A,B,C with 1,2,3 each program. I want to get a list
of everyone in the program A but every customer has to be in either 1,2 or 3.
 
J

John Vinson

Hi, i have a database, just that if i have a customer subscribed to 1 and
another to 2 in the program A, i want to get the list of all the program A.
But the database i have only get the people that matches either 1 or 2. Can't
have a list of all A.

Context: ive a program A,B,C with 1,2,3 each program. I want to get a list
of everyone in the program A but every customer has to be in either 1,2 or 3.
Click to expand...

Please post the names of your tables and fields. I have NO idea how to
answer your question. You clearly know what "subscribed" and "program"
mean in the context of your application, but these are not Access
terms and do not convey the structure of your table (at least not to
me). What field contains the "A" or "B"? What field contains the 1, 2,
3? How are your tables related?

John W. Vinson[MVP]
 
E

EgX

Hi, i'm not a pro in access so i'll try to explain you my database as clearly
as possible.

I have a database like an address book with 2 fields that are Program and
Step.
Program is the program that the customer is in and Step is the level he is
in the program he signed (1to9).

Each customer can be in a different program but have a different Step. They
too can be in different step but be in the same program. I want to retrieve a
list (printable) of all the people in the program i put in the choice field
for printing. I actually have a field to print but the field make the choice
of the step. I want to retrieve everyone from the program whatever the step
is. If personA is in same program as PersonB but their are not in the same
step, I want both of them in the list. My actual database is just getting
people from same program AND same step.
 
J

John Vinson

Hi, i'm not a pro in access so i'll try to explain you my database as clearly
as possible.

I have a database like an address book with 2 fields that are Program and
Step.
Program is the program that the customer is in and Step is the level he is
in the program he signed (1to9).

Each customer can be in a different program but have a different Step. They
too can be in different step but be in the same program. I want to retrieve a
list (printable) of all the people in the program i put in the choice field
for printing. I actually have a field to print but the field make the choice
of the step. I want to retrieve everyone from the program whatever the step
is. If personA is in same program as PersonB but their are not in the same
step, I want both of them in the list. My actual database is just getting
people from same program AND same step.
Click to expand...

If you create a Query based on your table, with

[Enter program:]

on the Criteria line under the Program field; and base a Form or
Report on this query, you'll get prompted for the program. If you type
"A" in responase to the prompt, you'll see everyone who is in Program
A, regardless of their level.

I'm not at all sure what you are doing now, but evidently you are
querying for both fields. If you don't put a criterion or filter on
Level, then you will see all levels.

John W. Vinson[MVP]
 
Top