RE: Having +3 different criteria on the same query

Tech-Archive recommends: Fix windows errors by optimizing your registry

The Nz is necessary because you have a range of dates. It's the same as
putting the & "*" after single value criteria. It's your way of saying "If I
don't enter a value, give me everything".

Barry

"PaulinaDi" wrote:

Just excellent. Really.
It works excellent.
Should I use this criteria always on the date? or just because the situation
of using 3 different criterias and trying to bring info although I don´t use
the 3 of them?

"Barry Gilbert" wrote:

Change the FechaFact prompt to:
Between Nz([Inicio],#1/1/1900#) And Nz([Fin],#12/31/9999#)

It cannot deal with null dates and there's no way to use a wildcard like in
the other fields.

Barry

"PaulinaDi" wrote:

I'm very sorry. I misstyped my answer.

# Field Criteria

1 Cliente Like [Nombre Cliente] & "*"
2 NumFact Like [Factura] & "*"
3 FechaFact Between [Inicio] And [Fin]

All on the same line (the first line on the criteria area)
But I still get the same problem. I may see the result entering data for the
3 fields, I may also see info if I enter info in the 2nd. and 3rd (and not
the 1st. one) and I am also to see info if I just enter info in the 3rd.
field (not the first and the second) BUT I'm not able to display info if I
just enter info on the 1st. OR just on the 2nd. or both on the 1st. and the
second. Is like a leather...

What happen if my customer only knows the first letters of the Customer
Field (1st) or the InvoiceNumber (2nd) or the Date (3rd) or 2 of them?????

THANKS A LOT!!!!!!!!!







"Barry Gilbert" wrote:

Instead of
Like [Nombre Cliente] And Like "*"
you need:
Like [Nombre Cliente] & "*"

Also, all your criteria should be on the first line with no criteria on the
OR line.

Barry

"PaulinaDi" wrote:

I'm very sorry as I don´t understand 100% of English and maybe my written one
is not the best.
Here it is:

I have my query with these 3 fields and I have tried to follow up your
instructions:
Customer with the criteria: Like [Nombre Cliente] And Like "*" on the first
criteria row
Invoice with the criteria: Like [Fact] And Like "*" on the OR criteria row
Date with the criteria: Between [Inicio] And [Fin] on the first criteria row

I want my customers to enter either the customer (2 or 3 letters (or more)),
and/or the invoice number and/or the date. I would not want to have several
queries if I could have just one. It works just for the Invoice and for the
date but not just for the customer. It brings me a blank page.

I appreciate very much your support! Really!


"Barry Gilbert" wrote:

For the customer criteria, do you have the:
& "*"
after the prompt? This allows you to enter the first two characters only.

Also, why do you put the criteria for the date on the or line? This means:
Return records that meet both Invoice and customer criteria or meet just the
date criteria.

Barry

"PaulinaDi" wrote:

OK. I put the Customer criteria on the first line and also the date criteria
but the invoice one I put it on the OR line.
It works if I look for a special invoice on a special date
if I look for a special invoice
if I look for a special date
if I look for a special customer on a special date

But it doesn´t work just for a special customer not typing either the
invoice or date. Is it because I'm just typing part of the name and not all
of it? For EX: Pro in stead of typing Promotora (as the complete name) but it
doesn´t happen if I just type 24? in stead of typing 243.

"PaulinaDi" wrote:

I have a query with several fields and want to use 3 or more criteria to make
it easier for the customer to find something. The fields I want to use
criteria are: Customer, Invoice No. and Invoice Date, but I want the customer
to write into 1, 2 or the 3 criteria and also look for any value or the
completed one.
Customer Invoice Date
EX: Promotora 245 10/04/06
Promotora 246 10/06/06
Pernod 247 10/05/06

The customer may select all the invoices for Promotora or the invoices from
04/06 to 05/06 or the invoices for Promotora from 04/06 to 04/06 or the
invoices 24? from a specific date.

I'm using Access 2003
.

Relevant Pages

  • RE: Having +3 different criteria on the same query
    ... What happen if my customer only knows the first letters of the Customer ... all your criteria should be on the first line with no criteria on the ... and/or the invoice number and/or the date. ... Is it because I'm just typing part of the name and not all ...
    (microsoft.public.access.queries)
  • RE: Having +3 different criteria on the same query
    ... "PaulinaDi" wrote: ... What happen if my customer only knows the first letters of the Customer ... all your criteria should be on the first line with no criteria on the ... and/or the invoice number and/or the date. ...
    (microsoft.public.access.queries)
  • RE: Having +3 different criteria on the same query
    ... all your criteria should be on the first line with no criteria on the ... "PaulinaDi" wrote: ... and/or the invoice number and/or the date. ... Return records that meet both Invoice and customer criteria or meet just the ...
    (microsoft.public.access.queries)
  • RE: Having +3 different criteria on the same query
    ... Should I use this criteria always on the date? ... What happen if my customer only knows the first letters of the Customer ... and/or the invoice number and/or the date. ... Is it because I'm just typing part of the name and not all ...
    (microsoft.public.access.queries)
  • Re: Transportation For Data !!
    ... Think of it as adding products to tblProducts and then dynamically adding them directly to an invoice at the same time. ... bill to customers ... i use filter and all the product from [Invoice Marketing Bill to Customer] will be filtered and only products manufactured by Microsoft Industries Limited will be transferred from to. ... How to use transfer text or add data in a form based that based on a query to another form that based on a different query? ...
    (microsoft.public.access.modulesdaovba)