Blank values in a query

[Jason B]

I have a table set up with a number of fields:
e.g Order No Desc 1 Desc 2 Desc 3 Desc 4
123456 Comp1 Comp2

When I run a query, I want access to completely ignore the
blank values as in Desc 3 and Desc 4 as if they weren't in
the table and don't appear in the query, so that I can
form a report to show all details for an order number, but
not have a list of blank values taking up valuable space
on the report. I am currently using Access 97. Thanks in
advance for any help in resolving this frustrating issue.

 

[[MVP] S. Clark]

You don't have a query problem, you have a table structure problem, or you
have committed "Spreadsheet".
Access best utilizes "Normalized" table structures like the following:

tblOrders
OrderID
OrderDate
etc..

tblDesc
OrderID
OrderDesc
etc..

Until you structure your data in some fashion resembling this, everything in
Access will be difficult for you.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-