Problem with a query criteria

[0200050]

Hello!

I have a little problem with a query. How i could do a query, (what kind of a criterias??) that finds information from a table depending on three(3) fields?

The working principal:

A record has three fields.

If one of the record's field is empty, but two are still filled, the query would find the next record that has all three fields filled.

So then the query wouldn't show any records, that doesn't have all three fields filled.

These fields i'm working on are Text-fields. What kind of a criteria should I put under a Text-field to check whether the field is empty or not?? Is there such a criteria existing at all?

Thank you in advance,

Cheers
Mike

 

[0200050]

Okay, i must be very sleepy right about now...

The criteria was of course Is Not Null..

Back to sleep!

Mike

 

[0200050]

A New Problem Popped Up!

This is something I can't really handle by myself.

I'm now doing a query which selects some information from a table using aggregate function 'Last'.

There are four fields in the query and they all use the Last-function except SerieNumber-field, which Total is 'GroupBy'.

Now the problem is this:

I have also a form, where user inserts data(form is bounded to the table).

The form has four fields. These four(4) fields will form a record. User may at the first time browsing only fill the first field, and left those two empty.

The problem occurs in the query bound to the table.
The query should find(show) a record, where all four fields are filled, but it still shows some newer with only one or two field filled.

Any suggestions related to this problem would were very appreciated!

Greetings,
Mike, from Finland

 

[Golom]

Mike

Can you post your SQL? The problem is likely in the way you have specified the WHERE clause but we need to see it to offer any help.