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