Recent content by jllortega

Syntax error in the instruction INSERT INTO. I am translating from Spanish.

The code needs to be adapted. Just copying it won't word. But I am unable to get the right code. This is why I have simplified the table and given tables and fields the same names as in the post.

Just adding the new records with the new date to the table. I have to do it every new moth. After that, I can change the salaries (or the values of the many fields the actual table has).

The goal is to calculate the payroll of number of people. To simplify, let's say three people: A, B, and C. Tha table would contain the following records for July: A, 7/25/2015, 1000 B, 7/25/2015, 1200 C, 7/25/2015, 1400 For August, I need to add the following records: A, 8/25/2015, 1000 B...

Many thanks for your prompt answer. I have simplified my DB so that it has only one table (tblSalaries) with three fields (Id, payDate, Payroll), so as to make it work with the code you provide, but I can't make it so. Could you provide the code for my DB?

I am using a DB to, among other things, calculate the monthly salary of my service users. Obviously, I have to do it every moth. Most of the data from the previous month will be the same in the next month, except date. Even if some of it is different, having the previous data on sight helps...

I am 61, a psychologist, living and working in Andorra. I have been working with MS Access for a long time, and lately learning more systematically from online courses. Still, there are some things that should be easy enough but I can't do. Hence joining.