Solve my problem!

  • Thread starter Thread starter ishaqani
  • Start date Start date
I

ishaqani

SBcnt Table:

[SBNO]
-----------
013180
013180
013180

above 3 are unique records

SBnet Table:

SBNO SBNOTOTAL
-------- --------------
013180 3
013180 3
013180 3
013180 3
013180 3
013180 3

above 6 records are also important for me but the SBTOTAL value 3 should not
be repeat in all fields only first record shows value 3 in SBTOTAL and
remaining 5 records shows value 0. like below

SBNO SBNOTOTAL
---------- ---------------
013180 3
013180 0
013180 0
013180 0
013180 0
013180 0

above example is required. How can i count and set the SBNO 3 unique records
value=3 in SBNOTOTAL field first record and remaing records with 0 value.

I have many records in SBNO field in SBnet Table with different value and
want to count same from SBNO field in SBcnt Table and put the value into
first record of SBNOTOTAL in SBnet Table.

Please guide me and help me through example code. would be highly appreciated.
 
Attaching a sample mdb file. I have TABLE1, TABLE2 and QUERY1, QUERY2 in my
mdb file.

http://www.multipixmedia.com/test.zip

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.

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

How is it possible.? Can anyone help me.




Gary said:
What *OTHER* field in SBnet table determines
which record is *first* record?
SBcnt Table:
Click to expand...
[quoted text clipped - 41 lines]
Please guide me and help me through example code. would be highly
appreciated.
Click to expand...
Click to expand...
 
Yeah -

You can help you. Need to go back and hit the books, concentrating on
Crosstab and Totals queries. That's what you've produced and you're not
going to get the results you're demanding that we provide.

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

http://www.multipixmedia.com/test.zip

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.

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

How is it possible.? Can anyone help me.
What *OTHER* field in SBnet table determines
which record is *first* record?
Click to expand...
[quoted text clipped - 4 lines]
Click to expand...
 
Back
Top