I want my query to return a single blank record when there is no d

S

Stu

How do I configure the query to return answer unconditionally - in other
words it will return a single blank record when there is not data to return
(blank record instead of NO record) ?
 
F

fredg

How do I configure the query to return answer unconditionally - in other
words it will return a single blank record when there is not data to return
(blank record instead of NO record) ?
Click to expand...

In a Select query?
If you already have a blank record in the recordset, you can return it
if no other records exist, but if you do not have an existing blank
record, as far as I know, you can't create one.

If you let us know why you want a blank recocord if no other records
are found, perhaps someone can tell you an alternative.
 
S

Stu

No blank records in the table I'm querying. I want a blank recocord if no
records are found which satisfy the query.
 
K

Klatuu

Well, Stu, Fred's question was what do you intend to do with the blank record?
If you can explaing the purpose of the record, someone can help you.
 
S

Stu

Okay - here is what I'm trying to do. I'm querying a table for eight weeks of
records. If no records were created during one of those weeks the query
returns only 7 records and the chart only shows only 7 weeks. I want the
chart to plot the "missing" week as (zero), so it always shows eight weeks.
 
K

Klatuu

Okay, that makes sense.
I haven't tried this exact technique, but here is my idea. You could create
a Union query that would include your current query and a dummy that would
return the same number of fields with all Null (or whatever) values. This
would cause it to always add one blank row to the query. What I have not
figured out yet is how to drop the dummy record if there are other records
returned.
 
Top