Recent content by aroma_kt

Again thanks Pat Hartman, for your help. Unfortunately I'm not familiar :o with querydefs. If it's not too much to ask, could you tell me how to use them??

Brian, I have tested my solutions on fields of datatype: Number (and format: Currney), both solutions 1 & 2 worked fine, I don't know why it didn't work out with you. :confused: :confused:

Damie, I have three solutions for you: ------------------------------------------------------------------------- Solution number (1): Use the nz function as follows: C: nz([A],0) + nz([B],0) Then right-click on field C (in the query), click properties: click the General Tab, and set the format...

Try the following: field: Count([fieldname]) fieldname where: True (please see the attached photo.) Tell me if that solves the problem.

Thanks Pat Hartman for your response. About your question: No, I don't want to let the user define criteria with (AND, OR). I think the (AND) operator is more than enough. I can easily build the SQL statements for each one of the tables through VBA, I hane no problem with that, but how can I...

It's simple the relationship: one: ==== general info (name, birth, address....) are entered only once of course (in general info table). many: ===== one employee can have more than one training course, the same goes for the other tables, one employee can have more than one leave and so on...

I have the following tables: employees general info employees job info employees leaves employees medical info employees penalties employees Bonuses employees Training Courses employees Promotions employees Insurance Relationships are between the (employees general info) table and each table is...