Replacing Repeated Values from recrods?

[ishaqani]

Attaching a sample mdb file. I have TABLE1, TABLE2 and QUERY1, QUERY2 in my mdb file.

I want Query1 Value 4 once in Query2. It should not be repeated again with [SBNO] values 5 time.

Value 4 in Query 2 shows with only 1st record and remaing 5 records shows 0 value instead of 4.

How is it possible.? Can anyone help me.

 

[Peter Reid]

Are you looking for "SELECT DISTINCT ...."?

The following will return a single record

SELECT DISTINCT Table1.SBNO, Query1.[20]
FROM Table1 LEFT JOIN Query1 ON Table1.SBNO = Query1.SBNO;

Also,

Value 4 in Query 2 shows with only 1st record and remaing 5 records shows 0 value instead of 4.

This doesn't happen for me, all 6 records are the same (A2k)

 

[ishaqani]

Dear thanks for reply.

I tried select distinct command but query shows only one record remaining 5 records are hide.

I need all six record should be displayed but 1st records shows value 4 and remaining 5 records shows value 0.

 

[Peter Reid]

Sorry for misunderstanding your original post.

I also don't really understand why you'd want to return such data