Recent content by lucy6868

Just when you thought you were rid of me... Here is the next derivation. I am trying to get supply and demand by location out of a system that was built around only have one location. When I try to add location to the running total, I get the message: The expression you entered contains...

The following formula worked correctly: RT4: DSum("[DemandQty]","[tblMRPDetail_Demand_RunningTotal_DataFields]","[PartNo]= '" & [PartNo] & "' And [UniqueRecord] <= '" & [UniqueRecordAlias] & "'") Thanks much for your help.

UniqueRecord is a text field.

Here's is my fresh attempt: RT3: DSum("[DemandQty]","[qryMRPDetail_PartShortages_Sub]","[PartNo]= '" & [PartNo] & "'" And "[UniqueRecord] <= '" & [UniqueRecordAlias] & "'") This returns the grand total of all demand for all part numbers. Different but not what I need.

I managed to get an entire total based on part number with this: RT2: DSum("[DemandQty]","[qryMRPDetail_PartShortages_Sub]","[PartNo]= '" & [PartNo] & "'")

This is giving me a total sum for all demand qty in the database, not judt the demand for the individual part number: RT2: DSum("[DemandQty]","[qryMRPDetail_PartShortages_Sub]","[PartNo]= " & '[PartNo]' & " ") What I would like is: UniqueRecord...

Can you give me the syntax for treating it as a text field? Thanks, Lucy

It is a text field. Sometimes there are alpha characters in the part number that I am using to create the UniqueRecord field.

Toast, I sure hope you are still around. Here is my query: RT2: DSum("[DemandQty]","[qryMRPDetail_PartShortages_Sub]","[UniqueRecord] <= " & [UniqueRecord] & " ") It returns: #Error Can you review my syntax? Regards, Lucy

I am trying to write a query that will give me a running total of the demand qty for each part number sorted by date. I have created a unique filed that includes part number, date, and order number that is unique for each record. I then sort on that unique filed. Query1 UniqueRecord...

I figured it out: UPDATE tblLateOrders SET tblLateOrders.DemandRunningTotal = DSum("DemandQty","tblLateOrders","PartNumber = '" & [PartNumber] & "' AND [OrderDate] <= #" & [tblLateOrders]![OrderDate] & "#");

I have read through the threads on creating a Running Total and am still stuck so here goes... I am trying to write a query that will return the running total of demand by part number by date. Table: tblLateOrders Fields: PartNumber OrderDate DemandQty DemandRunningTotal...

I have this formula that I copies from a website somewhere that numbers the records in a query so I can use it to populate a journal entry screen in my accounting software: Line: IIf(CInt(DCount("Description","tblPayrollJE","Description <='" & [Description] &...

I have a form for looking at UPS Worldship charges. I would like to add a button that would take the user to the tracking information on the UPS website. I have the hyperlink in a query and it works fine if I copy paste it to Explorer or Firefox but I don't know how to get it on the form. I...

In my UPS Worldship database, my shipping guy sometimes types in the sales order number like this: 20043818 / 30108 - 1 and sometimes like this: 15993 - 20 Hoods / 20043700 The sales order number always starts with 200 and is 8 digits long. I am trying to write a select query that only...