Results 1 to 4 of 4

Thread: [RESOLVED] end of year accrual methodology

Threaded View

  1. Apr 12th, 2011, 08:58 PM #1
    dw85745
    dw85745 is offline

    Thread Starter
    PowerPoster
    Join Date
    Jul 2001
    Location
    Tucson, AZ
    Posts
    2,166

    Resolved [RESOLVED] end of year accrual methodology

    Currently the user can enter a begin and end date and a query is executed to return the recordset., At year end there may be charges that belong in the following year. If the user queries for just the followon year (say 1/1/2011 - 12/31/2011) then those charges that were made in 2010 that belong in 2011 are not returned.

    Any suggestions on how best to handle these records??

    Some thoughts for how best to isolate these records so they can be found by a query rewrite are:
    1) maybe copy and hold these records in a separate "year end" table -- or
    2) a flag field noting these belong to the next year (I believe beside a flag, a followon year field would also be needed( -- or
    3) ???

    Thanks
    David
    Last edited by dw85745; Apr 12th, 2011 at 09:05 PM.
    Programs: VB6 Learn Sign Language http://www.vbforums.com/showthread.php?t=637161,

    Text To Speak http://"http://www.vbforums.com/show...65#post3985265,

    Speak Text - Using Word http://www.vbforums.com/showthread.p...ghlight=speech
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width