Using loops to enter currency in multiple months

I have buttons in a form: "1stPayDate", "LastPayDate", "PaymentAmount" and "NumberofPayments". I need my form to enter dollars into corresponding months, Example: If 1stPayDate is 12/1/13 and LastPayDate is 11/1/14 and Numberof Payments is 12, I need the dollars entered in PaymentAmount to be entered into fields Dec, Jan, Feb, Etc. What code would I write for this?

Dec 11 '13 #1

Subscribe Post Reply

863

zmbd

5,501

Expert Mod 4TB

Respectfully, Bytes is neither a code writing nor homework service. Please read the FAQ and posting guidelines

As for your question, your database is not normalized if you have field for each month; thus, before we can even begin to provide you with any reasonable help you need some foundational work:
---

> Database Normalization and Table Structures.

---
Pay particular attention to that last entry. Mastering this concept will make your databases easier to work with in the long run.

Hope to see you back!
-z

Dec 11 '13 #2

Similar topics

Using Loops to track user input

by: hokiegal99 | last post by:

I don't understand how to use a loop to keep track of user input. Could someone show me how to do what the program below does with a loop? Thnaks! ---------------------------- #Write a...

Python

Using Net to download multiple files simultaneously

by: Dominik | last post by:

I am writing application which must download multiple files simultaneous. Initially I wanted to use multiple threads to achieve this task but later I heard that Net is "using" separate thread from...

.NET Framework

Question about boxing and using Monitor::Enter / Monitor::Exit.

by: Ken Varn | last post by:

If I have a value type such as int that I want to protect in a multi-threaded situation, Is it safe to use Monitor::Enter(__box(value))? I am thinking that a different object pointer is generated...

.NET Framework

Using loops to add labels to a frame

by: Apirsun | last post by:

I've been trying to use loops to add labels to a frame. I was able to get the program to compile but the labels aren't showing up. import javax.swing.*; import java.awt.*; import...

Java

using loops to create diamon pattern shape

by: janice3 | last post by:

hi.I am a new member in this site. today my question is how to make a diamond shape using loops? the shape is like: * * * * * * * * * * * * * *...

C / C++

Using loops and arrays to acquire the total sum of values in a record

by: isaacsanya01 | last post by:

Hello there, I need some help working with arrays and loops. i have a set of records that contains different actions. i need to iterate over the records, check the actions per record, and do some...

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice