Fields with no values

[Beth B]

Hello,

I am trying to make a query that only shows the fields that have a value to
them. What I am trying to accomplish is that I have a bunch of people buying
from a bunch of different people. But not everyone buys from everyone. but
when I pull the query I only want to show the people that are buying from
this one person.

Is that possible or just confussing?

Thanks,

Beth

 

[KARL DEWEY]

Use this for query criteria --
[Enter your data for search]

or if you wish to search by putting in the first part --
Like [Enter your data for search] & "*"

or if you wish to search by putting in any part --
Like "*" & [Enter your data for search] & "*"

 

[Beth B]

the problem is that each person that is buying something has their own field
for each person that they are buying from

Use this for query criteria --
[Enter your data for search]

or if you wish to search by putting in the first part --
Like [Enter your data for search] & "*"

or if you wish to search by putting in any part --
Like "*" & [Enter your data for search] & "*"

Hello,

I am trying to make a query that only shows the fields that have a value to
them. What I am trying to accomplish is that I have a bunch of people buying
from a bunch of different people. But not everyone buys from everyone. but
when I pull the query I only want to show the people that are buying from
this one person.

Is that possible or just confussing?

Thanks,

Beth

 

[Lynn Trapp]

Uh oh...that sounds like your table is woefully unnormalized. You should
NOT have a field for each buyer and each vendor. Could you post the
structure of your table?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

the problem is that each person that is buying something has their own
field
for each person that they are buying from

Use this for query criteria --
[Enter your data for search]

or if you wish to search by putting in the first part --
Like [Enter your data for search] & "*"

or if you wish to search by putting in any part --
Like "*" & [Enter your data for search] & "*"

Hello,

I am trying to make a query that only shows the fields that have a
value to
them. What I am trying to accomplish is that I have a bunch of people
buying
from a bunch of different people. But not everyone buys from everyone.
but
when I pull the query I only want to show the people that are buying
from
this one person.

Is that possible or just confussing?

Thanks,

Beth

 

[Beth B]

This table is freakish and is driving me nuts. I got the source data from
another person. In order for it to work property I literally have to rebuild
it from scratch and re-enter all the data. the rows are the names of the
companies that each person buys from and the columns headers are the names of
the people.

I have a feeling that what I want to do is not possible

Uh oh...that sounds like your table is woefully unnormalized. You should
NOT have a field for each buyer and each vendor. Could you post the
structure of your table?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

the problem is that each person that is buying something has their own
field
for each person that they are buying from

Use this for query criteria --
[Enter your data for search]

or if you wish to search by putting in the first part --
Like [Enter your data for search] & "*"

or if you wish to search by putting in any part --
Like "*" & [Enter your data for search] & "*"


:

Hello,

I am trying to make a query that only shows the fields that have a
value to
them. What I am trying to accomplish is that I have a bunch of people
buying
from a bunch of different people. But not everyone buys from everyone.
but
when I pull the query I only want to show the people that are buying
from
this one person.

Is that possible or just confussing?

Thanks,

Beth

 

[Lynn Trapp]

It definitely sounds like a "freakish" table and I suspect you may be right
that it's not possible, at least in the way the table is currently
structured. To start with you are thinking too much in spreadsheet terms.
Rows do NOT have names. Columns should describe an attribute of the entity
that the table is representing (in your case it sounds like a purchase order
type system or something like that) and the table should not, except in very
rare instances, contain repeating fields. Remember that fields are expensive
while rows are cheap.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

This table is freakish and is driving me nuts. I got the source data from
another person. In order for it to work property I literally have to
rebuild
it from scratch and re-enter all the data. the rows are the names of the
companies that each person buys from and the columns headers are the names
of
the people.

I have a feeling that what I want to do is not possible

Uh oh...that sounds like your table is woefully unnormalized. You should
NOT have a field for each buyer and each vendor. Could you post the
structure of your table?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

the problem is that each person that is buying something has their own
field
for each person that they are buying from

:

Use this for query criteria --
[Enter your data for search]

or if you wish to search by putting in the first part --
Like [Enter your data for search] & "*"

or if you wish to search by putting in any part --
Like "*" & [Enter your data for search] & "*"


:

Hello,

I am trying to make a query that only shows the fields that have a
value to
them. What I am trying to accomplish is that I have a bunch of
people
buying
from a bunch of different people. But not everyone buys from
everyone.
but
when I pull the query I only want to show the people that are buying
from
this one person.

Is that possible or just confussing?

Thanks,

Beth