DSum Help - Microsoft Access / VBA

gbb0330

Hi All

i am trying to calculate Quantity on hand in a unbound textbox in a
form [FrmMainListing] with a subform [FrmSubListing]

QonHand=Qreceived - TotalQSold
TotalQsold=QsoldOnEbay+QsoldThruOtherChannels

here is my expression:

= [Ir0n] - ( ( DSum ( "[Sq0]", "tblSold","SlistingID" =
"[FrmSubListing].Form![ListingID] ) + (DSum
("[ocQ0N]","TblOtherQandL","oItemID" =
"[FrmMainListing}.Form![iItemID]))

Nov 13 '05 #1

Subscribe Post Reply

2067

gbb0330

ok i got 3 improved but still not working versions of the expression

=[Ir0n]-((DSum(nz("[Sq0]",0),"tblSold","SlistingID"=nz("[FrmSubListing].Form![ListingID]
",0)))-(DSum(nz("[ocQ0N]",0),"TblOtherQandL","oItemID"=nz("[FrmMainListing].Form![iItemID]",0))))
=[Ir0n]-((DSum(nz("[Sq0]",0),"tblSold","SlistingID"="[FrmSubListing].Form![ListingID]
"))-(DSum(nz("[ocQ0N]",0),"TblOtherQandL","oItemID"="[FrmMainListing].Form![iItemID]")))

=[Ir0n]-((DSum("[Sq0]","tblSold","SlistingID"="[FrmSubListing].Form![ListingID]
"))-(DSum("[ocQ0N]","TblOtherQandL","oItemID"="[FrmMainListing].Form![iItemID]")))

Nov 13 '05 #2

Similar topics

DSum Assistance for Building Expression

by: Rolan | last post by:

I'm using Access 97 and need some assistance in sorting out a proper DSum expression, or maybe even DCount might be an alternative. I have tried...

Microsoft Access / VBA

NZ Assistance with DSum

by: Dalan | last post by:

I seemed to be having problems with structuring the use of NZ with a DSum expression. Having tried numerous variations of the expression without...

Microsoft Access / VBA

DSUM

by: Mark Reed | last post by:

All, I have never used this function before and am not sure it what I need. Just to clarify, I have a report based on a query which has amoungst...

Microsoft Access / VBA

DSum reference in a report

by: John Baker | last post by:

Hi: At the bottom of a report, I wish to sum all the amounts that appear in a field called Discount$ that appears on the report. I am not doing...

Microsoft Access / VBA

Dsum Use In Query

by: GD | last post by:

tblFoo FooId Name Number 1 One 1 2 Two 2 3 Three 3 The Following query produces the results I want, but...

Microsoft Access / VBA

DSum basic help

by: Marc Aube | last post by:

Is there a web site that can ofer some help. The quotation marks are posing an issue as well as other items for this function. I have some books but...

Microsoft Access / VBA

DSum Glitch

by: pixie | last post by:

Hi. I'm having problems with the following DSum in my report footer. It gives me #Error when I run the report. I hope someone can help me out as I...

Microsoft Access / VBA

DSum / Sum for calculating Order Total

by: potassium flower | last post by:

I am trying to create a food order system for a restaurant. I have tried using both the DSum and Sum functions to calculate the total cost of an...

Microsoft Access / VBA

Using textbox value in a report DSUM

by: danielgoss | last post by:

Hi I have a report that has loads of textboxes that calculate things based on the value on another textbox in the report. I have put a hidden...

Microsoft Access / VBA

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...

General

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...

Oracle Database

https redirect with reverse proxy

by: jalbright99669 | last post by:

Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...

IIS / Internet Information Server

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...

General

How to layout php header location with a variable as the location?

by: Matthew3360 | last post by:

Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...

PHP

How do I view Redshift db tables in Alteryx

by: Arjunsri | last post by:

I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

General

by: WisdomUfot | last post by:

It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

General

PHP Curl Not wanting to connect to localhost.

by: Matthew3360 | last post by:

Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

PHP

Join our open community on Discord to learn programming, SEO, and marketing

by: BLUEPANDA | last post by:

At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

General