I don't get this

[A real begineer]

I have tried to write a query as an exercise.

I am trying to sort cars from trucks, yellow, green or red and 6 or 8 cylinder.

I can sort on 6 or 8 cylinders or on colour or trucks and cars. However, I can not seem to teach it how to sort on Trucks that are green and 6 cylinder, whenver I try this it simply shows all trucks.

Please explain this in baby steps cos I don't seem to be able to grasp this concept correctly.

 

[Liv Manto]

Whose leg are you pulling? Your a "member" with 98 posts.

 

[pcs]

you can't create a query to SORT on these criteria...you need to create a query with the criteria field set to type:trucks color:green engine:6 ,etc.

hth,
al

 

[pcs]

Liv Manto
about 5 more posts and you will be a member too!

think it's about 30 posts...no one evaluates the quality of your postings and promotes you. just ask a lot of questions and you are a member!

that said, i've noticed some of your apt relpies! please continue to contribute your expertise! and don't be put off by those who only ask and never give...

al

 

[Jack Cowley]

Are you putting "Truck" in the Criteria field for trucks and cars and "Green" in the Criteria field of color and 6 in the Criteria for Cylinders and all in the same row? If you are then you should see only green trucks with 6 cylinders....

 

[Liv Manto]

BABY STEPS.....


If your vehicle description is on one field:

VEHICLE DESCRIPTION

Truck, green and 6 cylinder
Car, red, stickshift


Your parameter should be:

Truck*green*6*cylinder

OR

Car*red*stick*


If the body, color, type is segregated by
separate fields:

BODY____COLOR______TYPE
Truck___green______6*

Criteria all same line, not:

BODY____COLOR______TYPE
Truck__________________
________green__________
___________________6*

[This message has been edited by Liv Manto (edited 08-19-2001).]

 

[R. Hicks]

I just answered the same question at A3 Forums. I assume this question was from the same person. Just in case ..... here it is again.

You need to use the "Like" Operator followed by the Parameter then an Ampersand (&) and then finally by the "*" wildcard. If the Parameter is left Null (empty) then Access will ignore the Null and only pass the "*" wildcard, thus pulling all records for that field. Each of field criterias should look something like:

Like [Enter Auto Type] & "*"

(the above is just an example, adjust as needed)

Not sure if you are referencing a form to get the criteria parmeters or if you are having the query pop up Parameter input boxes. If it is a form, then full reference to the form and control will be needed in the criteria section of the QBE grid for each field being filtered.
If the query is calling for the inputs using pop up boxes for the input make sure that the text used to call the parameter is not the same as the name of a field. Example .... if you have a field named Colour, don't place just [Colour] as the criteria. It should be something like [Enter Colour]. This will cause a problem if not careful.

HTH
RDH

[This message has been edited by R. Hicks (edited 08-19-2001).]