Thank you Rabbit!
That's working fine in my test table. But there's problem with the real data. In real program I have to use two tables (union). Table1 have like 10000 records and table2 have only 5000 records. I have to find last value so if I use id query always find values in table1. And other problem is that sometimes users write down newest date first and then day older and so on. That happens often after weekend. They first...
Keijo82
Last Activity: May 20 '07, 05:09 PM
Joined: Mar 28 '07
Location:
-
I'm sorry. I meant that in real table there is null values and in example table which I post in this topic "-" means null value. I have to put something in example table because else numbers would been in wrong column like below:
id date tank number1 number2 number3
1 28.3.2007 1 1 1 1
2 28.3.2007 2 2 2 2
3 29.3.2007 1 3
4 30.3.2007 1 4
Number 4 should be in number...Leave a comment:
-
Thanks for your answer!
I don't quite understand what you are saying? What kind of criteria should I use? If I use "is not null" query only give me id 2 row. And I think thats because there is null values in last tank 1 row.
You probably meant something else......Leave a comment:
-
Last not null value
Hi,
What kind of query I should do if I have table like below and I want to get last written values both tanks? Not null values ( - equals null values).
id date tank number1 number2 number3
1 28.3.2007 1 1 1 1
2 28.3.2007 2 2 2 2
3 29.3.2007 1 3 - -
4 30.3.2007 1 - 4 -
So I want query to give me...
No activity results to display
Leave a comment: