Sql Command Problem

[jigax]

I have an access database with the following columns.

"product 1","product 2","product 3", "product 4","focus 1","focus 2","focus 3" and "focus 4"

I'm trying to create a report that separates these products depending one their focus fields (e.g. if field is not empty display products on top if they are display them on the bottom half). E.g

Products with focus
------------------------
Products without

I have the following SQL command for each field. I change the column for each command of course.

SELECT `Table1`.`product 1`
FROM `Table1` `Table1`
WHERE `Table1`.`focus 1` = "n"

It works fine however whenever I have a record that contains both types of focus (empty and not) my whole report goes blank. Hope my question is clear.

 

[jigax]

Could someone atleast poing me to the right direction please. Thanks.

 

[jigax]

This is for crystal reports why was it moved.

 

[DavidT_macktool]

I'm thinking this one needs Sub-Reports.
Have the main report select records based on focus.
Have a sub-report select by lack of focus.
You may be able to do it with the record selection formula.

"Look into Sub-Reports" would be my attempt to steer you in the right direction.

 

[jigax]

Thanks alot I will look into that and let you know the outcome.

 

[Schenz]

You have broken the first 2 rules of database normalization in designing the database table......

 

[jigax]

schenze any tips? I'm just learning how to deal with all this. I will greatly appreciate even if pointed to the right tutorials..