<<<
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
>>>
>>>>
>>>
>>
>>
>
|
