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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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) ?
 
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.
 
No blank records in the table I'm querying. I want a blank recocord if no
records are found which satisfy the query.
 
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.
 
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.
 
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.
 
Back
Top