Simple Queries not sorting properly

  • Thread starter Thread starter Carol Spurgeon
  • Start date Start date
C

Carol Spurgeon

I'm trying to make a simple query from one table. I need
to have the query show two columns List or Sales and pick
up either one column or the other and sometimes both
depending on the names in those columns. I just can't get
the proper criteria in my query. I've tried everything.
Any help would be appreciated. I want a query for each
of my people so I can go and look at any particular time
as to how much business they have done. I have several
other columns that need totaled. Help and thanks.
 
Carol,

Do you mean you want to see all records where "Fred" is in either the
List or Sales field? To look specifically for Fred, put "Fred" in the
criteria of both columns in the query design grid, but not in the same
criteria row, they need to be one below the other. If you want to make
a Parameter Query, instead of the actual name put [Find who?] in the
criteria of the query, and then every time you open the form or report
that is based on the query, you will be asked for the name. Your post
intimated that you might be planning on saving a separate query with
hard-coded criteria for each person, but this is not the best way.
 
Thanks it worked great! Appreciate your help. >-----
Original Message-----
Carol,

Do you mean you want to see all records where "Fred" is in either the
List or Sales field? To look specifically for Fred, put "Fred" in the
criteria of both columns in the query design grid, but not in the same
criteria row, they need to be one below the other. If you want to make
a Parameter Query, instead of the actual name put [Find who?] in the
criteria of the query, and then every time you open the form or report
that is based on the query, you will be asked for the name. Your post
intimated that you might be planning on saving a separate query with
hard-coded criteria for each person, but this is not the best way.

--
Steve Schapel, Microsoft Access MVP


Carol said:
I'm trying to make a simple query from one table. I need
to have the query show two columns List or Sales and pick
up either one column or the other and sometimes both
depending on the names in those columns. I just can't get
the proper criteria in my query. I've tried everything.
Any help would be appreciated. I want a query for each
of my people so I can go and look at any particular time
as to how much business they have done. I have several
other columns that need totaled. Help and thanks.
Click to expand...
.
Click to expand...
 
Back
Top