Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What can I do?
• What to Read?		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Сообщества
• Talxy Chat
• Horoscope
• Online		 disable design
Start your blog now! All for FREE.
Blog > sum if code  19 November 2007 06:27:09
  About me:      
My photoalbum…

My favourites…

My quotes…

My discussions…

Last comments…

My friends' entries…

Friends' hobby…

Friends birth dates…

My friends' zodiac signs…

My links…

My wishes…

My blog search…

My Profile…

Status:  offline

  
— friends-pages
— favourite
  My Tags:
Access Programming
  Read my Posts:
393 days back graceg07
403 days back Microgar Blog by user "Microgar"
  Recent Comments:
RE: sum if code
dear freind you have all wrong in your tables! to get sum U must have following sql : SELECT…

  Recent Blog Topics:
How to convert iTunes Plus to…
The other day Apple announced that it was making about 80% of the iTunes store DRM free, with the…

True nobleness
On the calm sea, everybody is the navigator. However, only the sunshine has no shade, only have no…

_4_
…

mego day!
:-O­ yesss I today went for a walk from a 6 morning! it super! so merrily that pipec!

Everybody is a book
Everybody is a book, parents are our publishing houses, and our publication time on birthday, the ID…

boring..boring...boring :-|…
boring..boring...bor­­ing :-|­ where people? bitchs...not abandon me one…

here so quietly and boring! on…
here so quietly and boring! on beone merrier far! well but I can sit in a quiet.... and not who by the…

Transfer iTunes Library to Zune
If you have moved from Apple iPod to Microsoft Zune, you probably have some songs that you purchased&hellip­;

hello!
hello!I here new! interestingly me what people dwell on this site... I search friends from the command…

Routes on Sale!
Looking for great Quality/Competitive­­ Rates???? Breezecom FZC is offering: PAKISTAN! CLI…

sum if code

mohd hisham 19 November 2007 06:27:09
 Dear member,

I want to create coding for sum if in access.
Any can translate to me how to code sum if.
Table1 have tickectNo, item_partno and qty
Table2 have item_partno, qty1, qty2, and result.

When I click one button generate;
* sum (qty in table1) insert to qty2 in table2
* qty2 - qty 1 insert to result

pls help me to code in VBA

Tags: Access Programming
Add comment
Microgar 28 November 2007 15:30:24 [ permanent link ]
 dear freind

you have all wrong in your tables! to get sum U must have following sql :

SELECT Table1.tcket, Table1.prod, Sum(Table2.quantit ) AS SommeDequantit
FROM Table1 INNER JOIN Table2 ON Table1.ref = Table2.prod
GROUP BY Table1.tcket, Table1.prod;

I just post an eample here share it (choose free column) http://rapidshare.c­om/files/72885956/ba­se.mdb
Add comment
 

Add new comment

As:
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

Blog > sum if code  19 November 2007 06:27:09
  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .