Cross-Table searches

[Huey462]

I have an access program with two databases, one that tracks all items that have been placed on order/awaiting order and the other lists all of the assets we keep on hand (nuts/bolts/etc). What I want to have Access do is when the Stock form (the one that shows what we keep on hand) is updated/current to have it run the following search:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Look in the SupplyLog table and add up the total for the Qty field each time the NSN fields match Me.NSN and the Status is either “Issued” or “Back-Order”
<o> </o>
I’m sure this will be some sort of DSum bit of code, but I’m essentially self taught and way out of my league on this one.
<o> </o>
Thanks in advance and let me know if you need to know something else.
-Foe

 

[Huey462]

This was my best attempt at a formula

Me.QtyOnOrder.Value = DSum("[TotalPrice]", "SupplyLog", "[NSN]" = Me.NSN.Value And "[Status]" = "Issued")

 

[Huey462]

I’ve tried having the dsum reference the NSN value from the field itself as well as assigning it a temporary value with a DIM statement, neither of which works. I also fixed the field reference in the first [] to QTY
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>

    Me.TempBox = NSNTemp
    ‘Puts value on screen to verify it is working/correct
        'Me.QtyOnOrder.Value = 0
        NSNTemp = DSum("[QTY]", "SupplyLog", "[NSN]" = Me.NSN.Value And "[Status]" = "Issued")
        Me.QtyOnOrder.Value = NSNTemp

 

[Huey462]

I finally figured this bit out, and the code works to go through and add up the total number of times each items is placed on order (example 1). How can I add an “and” statement to the end? Example 2 returns a compile error/syntax error.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> Example 1</o>

NSNTemp = DSum("[QTY]", "SupplyLog", "[NSN] = '" & Me.NSN.Value & "'"

<o> </o>
<o>Example 2</o>

NSNTemp = DSum("[QTY]", "SupplyLog", "[NSN] = '" & Me.NSN.Value & "'" AND [Status] = 'Issued'")