Hi, am new for this forum, so couldn't post properly...
1. This is my table
CREATE TABLE [dbo].[tblWeeklyTransactionSheet](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Period] [float] NOT NULL,
[PayDate] [smalldatetime] NOT NULL,
[Payment] [decimal](12, 2) NOT NULL,
[Current_Balance]...