[apoli87]

hi good day!!
I Have no background in microsoft access, but i want to make a simple database that can perform a simple calculation..

i hope you can help me!!!

Thank you and good day!

[Amadeus]

We certainly can, but you'll have to provide some more information. What kind of data will you need to store? what is the calculation to be performed?

[fys999]

Hi newbie here.. here's the sample calculation I want to perform. It's more on timekeeping like (TIME OUT-TIME IN= NO. OF HOURS WORK). Hope you can teach me how to do this in ms access. Thank you

[P4L]

fys999, on 15 March 2010 - 10:17 PM, said:

Hi newbie here.. here's the sample calculation I want to perform. It's more on timekeeping like (TIME OUT-TIME IN= NO. OF HOURS WORK). Hope you can teach me how to do this in ms access. Thank you

To answer this one, try something like:

Select tbl.EmpId, (tbl.TimeOut-tbl.TimeIn) as HoursWorked
From tblUsers as tbl

[quote name='felix kili' date='12 May 2010 - 11:51 AM' timestamp='1273686712' post='1016153']

Kili, on 12 May 2010 - 08:47 PM, said:

am trying to create a project that will calculate salaries but i don't know how to input the codes. for example how to find "number of years worked" by subtracting "year of entry" from "current year". i also don't know how to get increment according to the number of years worked and also to calculate the total salary by adding monthly salary+increment. please help

For this one, try using the Wizards in Access first, and see what you come up with. Also, Microsoft.com has templates that you can play with. If there's a more complex issue, we would be more then happy to help you out.