Sadly, none of the recent suggestions ( b.. ..b.. b or B or no
parameter
at all ) overcame the gray band. However, there' was a break through.
In addition to the bul (bulletin) field, I have Y and Z fields for further
sorting. This seems legit and proves handy for Christmas card & other
occasional
mailings. Somehow an f found its way into the Query Y field There
being
no corresponding f in the Y field of the main table for the Query to
select,
it could only respond with the gray band, which,evidently means nothing
doing ! I deleted the f and ran the query, and there were the
records.
"Bertil Isberg" <ctech@[EMAIL PROTECTED]
> wrote:
><<<
>Evidently the way I do the Query doesn't order up any
>records at all. In a previous post I told how I thought I was covering
>all the bases for getting records. Guess I was wrong.
>>>>
>
>So the problem is not the Grey band but the query itself. Try Tony's
>suggestion of using b.. or ..b.. as the selection criteria.
>
>
>--
>Bertil Isberg - CTECH
>Paradox buglist:
>online: http://hem.bredband.net/bertilisberg/
>
>"Delbert" <delllz94@[EMAIL PROTECTED]
> skrev i meddelandet
>news:47670d83$1@[EMAIL PROTECTED]
>>
>> "Bertil Isberg" <ctech@[EMAIL PROTECTED]
> wrote:
>> Delbert
>>
>> a) What happens if you open any table? Do you see any records or just
a
>> grey
>> band?
>>
>> a) I see all the records in the table, the latest count being 319. No
>> gray
>> bar.
>>
>>>b) When you run a query and create an answer table, the Paradox status
bar
>> says Record 1 of 55 (number of records selected). What do you see on
the
>>>statusbar?
>>
>> b)I After filling in the checks on the Query bar and doing a Query Run
I
>> see " 0 records" (zero records) on the status bar. When it's working
right
>> it says 1 of about 115 records, 115 being the number of people getting
a
>> bulletin, that is, the number of mailing labels being made to send out
the
>> monthly bulletin. Evidently the way I do the Query doesn't order up
any
>> records at all. In a previous post I told how I thought I was
covering
>> all the bases for getting records. Guess I was wrong.
>>
>> Delbert
>>
>>
>>>--
>>>Bertil Isberg - CTECH
>>>Paradox buglist:
>>>online: http://hem.bredband.net/bertilisberg/
>>>
>>>"Delbert" <delllz94@[EMAIL PROTECTED]
> skrev i meddelandet
>>>news:4766cdcd$1@[EMAIL PROTECTED]
>>>>
>>>> "Steven Green" <greens@[EMAIL PROTECTED]
> wrote:
>>>>>Delbert, your latest comment leads me to the same conclusion as
Tony's..
>>>>
>>>>>sounds like a query where the parameters leave you with an empty
answer
>>>>
>>>>>table.. or a query of a table that was empty to start with..
>>>>>
>>>>>--
>>>>>Steven Green - Myrtle Beach, South Carolina USA
>>>>>
>>>>>Diamond Software Group
>>>>>http://www.diamondsg.com/main.htm
>>>>>Paradox Sup****t & Sales
>>>>>
>>>>>Diamond S****ts Gems
>>>>>http://www.diamondsg.com/gemsmain.htm
>>>>>S****ts Memorabilia and Trading Cards
>>>>>
>>>>>"Tony McGuire" <png.paradoxcommunity@[EMAIL PROTECTED]
> wrote in message
>>>>>news:47657810@[EMAIL PROTECTED]
>>>>>>
>>>>>> Are you entering any criteria to limit the records returned?
>>>>>>
>>>>>> If so, drop ALL criteria and run the query. Do you get any
different
>>>>
>>>>>> result?
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> ------------------------------
>>>>>> Tony McGuire
>>>>>>
>>>>>> Tony & Steven, the database I'm working from has about 400 records,
>> all
>>>> apparent & freely accessible.. it's a mystery to me why all this
should
>>
>>>> come
>>>> up "empty." The selection I'm making from the database is for people
>> who
>>>> get the bulletin, about 110 records.. There is a field named bul (for
>>
>>>> bulletin)
>>>> in which, at the query level, is a "b".. any record with a "b" in
the
>> bul
>>>> field gets a bulletin in the mail.. from where I sit, THE MATERIAL
LOOKS
>>>> THERE, and Query Run should produce 110 labels and not a smooth
gray
>>
>>>> band..
>>>> Obviously there is something wrong with what I'm doing or the way I'm
>>
>>>> thinking..
>>>> evidently the nice gray band is just saying, mister, you asked for
>>>> nothing
>>>> and that's what you got, or you asked for something out of nothing,
&
>> I
>>>> can't help you do the impossible.. I appreciate the help, let's plug
>> on..
>>>>
>>>> Delbert
>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>
|
