hi!
i have a database about the employees. I want to make an Increment system about their salary. Our company will add $100 to one employee's salary after completing his 12 months just right from his Hiring Date. Please help me in this regard that what should come there in the query and any plus point from anyone will be appreciated.
Thanks in advance.
3 1418
What have you tried so far?
You don't really say where you're trying to do this, but in a form Me.BonusDate = DateAdd("yyyy",1,YourHireDate)
or in a query BonusDate: DateAdd("yyyy",1,[YourHireDate])
Linq ;0)>
You don't really say where you're trying to do this, but in a form Me.BonusDate = DateAdd("yyyy",1,YourHireDate)
or in a query BonusDate: DateAdd("yyyy",1,[YourHireDate])
Linq ;0)>
hi!
Thanks Linq! i have already done this inside the query.
BonusDate: DateAdd("yyyy",1,[dlcfrom]) and also [Salary]+100 in another field.
I have also done a NextBonusDate: DateAdd("yyyy",2,[dlcfrom]) and [Salry]+200 for another next year.
kindly i would like to ask that what should i do if the years go to 5,6 or 10. I think the whole table or query will be messed up with such a huge number of fields. So in such case what should i do? should i go for it or is there any way to manipulate some other code so that it gives me Many years records in each row in one filed relating to One Employee. This will create a one-to-many relationship of Employees Table to the Salary Table.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Duffey, Kevin |
last post by:
I don't know if jdbc/java code requires this, but when I use two gui admin tools I found, and I insert a row into the table using their row editor feature, both require me to enter a number for the...
|
by: MFC |
last post by:
Ok, after three C# books, (C# How to Program, Programming in the Key
of C#, and C# Weekend Crash Course) and three weeks, I believe I have
tried everything to make a certain form function...
|
by: Jack Addington |
last post by:
I want to scroll through the alphabet in order to scroll some data to the
closest name that starts with a letter. If the user hits the H button then
it should scroll to the letter closest to H. ...
|
by: Paulovič Michal |
last post by:
hi all,
I have problem with SERIAL field type (or sequence functionality).
I have table with three columns - ID, IDS, NAME.
I want auto-increment IDS grouped by ID.
Example:
1, 1, Ferdo
1, 2,...
|
by: t4zone58 |
last post by:
Hi
Basically I am print out a group of number with a certain increment. However I found out a wierd thing happened from the result
The code I wrote:
Dim number1, number2, counter, increment As...
|
by: naknak4 |
last post by:
Introduction
This assignment requires you to develop solutions to the given problem
using several different approaches (which actually involves using three
different STL containers). You will...
|
by: naknak |
last post by:
Introduction
This assignment requires you to develop solutions to the given problem
using several different approaches (which actually involves using three
different STL containers). You will...
|
by: satan |
last post by:
I need to call the recursive binarySearch method from my OrderedArrayList class into my main program
public abstract class ArrayListClass
{
protected int length; //to store the...
|
by: user923005 |
last post by:
The purpose is for a shellsort.
I am experimenting with the increment for shellsort using a modified
version of Pete's driver and this bit of code (shell_ratio is a
floating point number for the...
|
by: Carlos Yakimov |
last post by:
I want to convert this C# Linq Query into VB.NET
void Load() {
int i = 1;
var q = from P in Persons
select new System.Windows.Forms.ListViewItem( P.Name, i++ );
}
I did this:
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |