Search results

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 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...