MS access sql query help help help

Posted by Ashpal under Others on 5/21/2014 | Points: 10 | Views : 1806 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,
I have a table which looks like

a1 b1 c1 d1
b1 c1 d1 (a1 value is missing)
a2 b2 c2 d2
b2 c2 d2 ( a2 value is missing)
b3 c3 d2 (a3 value does not exists)
a4 b4 c4 d4

how can I query the table so the result table looks like

a1 b1 c1 d1
a2 b2 c2 d2
b3 c3 d3
a4 b4 c4 d4

Thanks in advance
AshPal

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Vuyiswamb on: 5/22/2014 [Member] [MVP] [Administrator] NotApplicable | Points: 25

0	your explanation is not yet enough for someone to help you, try to explain better again Thank you for posting at Dotnetfunda [Administrator] Ashpal, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ashpal on: 5/22/2014 [Member] Starter | Points: 25

0	hi I have a table in which some rows are almost same but data in one column is not here. As shown above first and second row are same but a1 value is missing in the column A of second row. I donot want that row with less data. I canot delete row by row as there are so many rows. Hope this explains it. Thanks, Ashpal Ashpal, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Vuyiswamb on: 5/22/2014 [Member] [MVP] [Administrator] NotApplicable | Points: 25

0	Where a where clause to exclude them where that field <> is the value you suspect it is in that field. "Null" or "Empty string" Thank you for posting at Dotnetfunda [Administrator] Ashpal, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ashpal on: 5/26/2014 [Member] Starter | Points: 25

0	let me expalin more clearly, First two rows: There are two rows with identical data except with value(a1) missing in one colums. (First two rows in the example given. there is a1 value but it is missing in second row.) In some rows the value is not available and no other row with identical data. ( Thirs row in the example. a3 value is not available.) So I cannot filter with where clause because I want third in the table where a3 value is null Ashpal, if this helps please login to Mark As Answer. \| Alert Moderator

let me expalin more clearly,

First two rows:

There are two rows with identical data except with value(a1) missing in one colums. (First two rows in the example given. there is a1 value but it is missing in second row.)
In some rows the value is not available and no other row with identical data. ( Thirs row in the example. a3 value is not available.)

So I cannot filter with where clause because I want third in the table where a3 value is null

Ashpal, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts