> There is a field named bul (for bulletin) in which, at the query level,
is
> a "b"..
OK.. pull up the query form.. hit the CHECK thing.. no "b" or any other
parameter.. execute the query.. do you get ALL of the records in the
answer?
if so.. now go back to the query form.. type in exactly what I'm putting
on
the next line
b or B
that'll capture capital B and small b.. execute the query.. do you get ALL
of the records with a B or b in the answer?
--
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: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
>
>>
>
|
