Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BizDev

    Microsoft Access -- Updating a Field with "Cumulative" Data

    Holy... Yes. That made a _world_ of difference. Wow. You rock, Duane.
  2. BizDev

    Microsoft Access -- Updating a Field with "Cumulative" Data

    Very cool-- I did not know that, thank you. With over 500,000 records, and needing to do 3 of these "cumes" in the same table (or recordset), I'm beginning to understand why calculated records shouldn't be stored (or created in the first place). This query hard on the cpu.
  3. BizDev

    Microsoft Access -- Updating a Field with "Cumulative" Data

    Yes, they are denormalized. This isn't a production database with dynamic data going in/out on a daily basis. It's more for reporting/analysis look at daily/weekly/monthly/quarterly/etc. snapshots in time. I added in the aliases as you showed and it works like a charm. Thank you _so_ much. If...
  4. BizDev

    Microsoft Access -- Updating a Field with "Cumulative" Data

    Duane-- here is the SQL: SELECT [tblAYB].ITEM_NUMBER, [tblAYB].FISCAL_YEAR, [tblAYB].FISCAL_WEEK_NUMBER, (SELECT Sum([GGG_DEM]+[DO_DEM]) FROM [tblAYB] WHERE [tblAYB].ITEM_NUMBER = [tblAYB].[ITEM_NUMBER] AND [tblAYB].PERIOD <=[tblAYB].PERIOD) AS Cume, [tblAYB].FISCAL_YEAR...
  5. BizDev

    Microsoft Access -- Updating a Field with &quot;Cumulative&quot; Data

    This is in Access. The point is that this is a very easy exercise in Excel, as Dallen pointed out. However, there is not, to my knowledge, an easy way to functionally or logically have Access check the prior row, on a unique "key"-- in this case, item number, or in Excel column A, and perform...
  6. BizDev

    Excel 2007 - Copy &amp; Paste Only Fill Colur

    Could a format validation serve your needs here?
  7. BizDev

    Microsoft Access -- Updating a Field with &quot;Cumulative&quot; Data

    Strange. I only get this value when running that: 324357.154000002 for the cume column.
  8. BizDev

    Microsoft Access -- Updating a Field with &quot;Cumulative&quot; Data

    Awesome, I'll give it a try once the dbase finishes updating some tables. Really appreciate it!
  9. BizDev

    Microsoft Access -- Updating a Field with &quot;Cumulative&quot; Data

    Is there a way to do a running sum as a calculated field? Forgive me if I sounded terse in my reply. There's more I want to do with this table (adding more fields, contingent on the cumulative value), and a report isn't what I'm after at this poin in time.
  10. BizDev

    Microsoft Access -- Updating a Field with &quot;Cumulative&quot; Data

    Definition really isn't important. You could call it supply and demand, or debit and credit. What's important is the two values are netted, and a running sum is added by date, for each unique item.
  11. BizDev

    Microsoft Access -- Updating a Field with &quot;Cumulative&quot; Data

    Appreciate you taking the time to look at this. The formatting below isn't great, but hopefully not too difficult to extrapolate out the logic of what I'm trying to do. Item Date Qty1 Qty2 Net Cume Shoe 1/1/2009 5 2 7 7 Shoe 1/2/2009 -3 2 -1 6 Shoe 1/3/2009 0 0 0 6 Shoe...
  12. BizDev

    Microsoft Access -- Updating a Field with &quot;Cumulative&quot; Data

    Here's an example... http://spreadsheets.google.com/ccc?key=0AoPAogi68vEUdGpmcmdrdk9Nb2dDaUozek9ScnpxY1E&hl=en By item, I want the cumulative to represent, by date, the running sum.
  13. BizDev

    Microsoft Access -- Updating a Field with &quot;Cumulative&quot; Data

    Hey everybody, first time poster here. Here's my situation. I have a table that basically looks like this... Field Names: Item Date Qty1 Qty2 Net Cumulative There is accurate data in all of the fields, except for cumulative. I have the data sorted ascending by Item, then ascending by date...

Part and Inventory Search

Back
Top