> I deleted the f and ran the query, and there were the records.
that's why the rest of the suggestions didn't work..
--
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
"Delbert" <delllz94@[EMAIL PROTECTED]
> wrote in message
news:47687217$1@[EMAIL PROTECTED]
>
> 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
>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>
|
