Search results

Thanks guys! i did a test on report with the function and worked! Thanks!!!!!!!!!!!!!!!!!

I'll correct it, i'll make calculations on the report, query will just collect sample information and result values. Regional setings are in greek, this is propably the reason that it works with semi-colon. I've already change the syntax of the iif statement! I'll update the post tomorrow! :)

I'll try to make it on the fly and not store it in table, i'll have it ready propably tomorrow. I'll update the post! Thanks guys!!!

Paul, i'd like to have it calculated in the table before running the query to report samples analysis. (database is about samples analysis) As alternative i could have a textbox on report and make calculations on the fly, but there are 6-8 fields with calculations, rest are working fine...

Hello everybody!!! Can anybody help me with this please? I have these function as calculated field in a table (ms access 2013) After setting up the function, access shows error for invalid dot or operator or unexisted field (field exists :) ) iif([MoistureContent]>9 or...

Goodmorning! I don't disagree with you, but the current project just saves incident and then it prints it/makes pdf. Statistical analysis is being performed with excel (export table). The reason is that i have to create so many different charts (about 20) and the best is by excel. So, i just...

Thank you for the answer, but the main form is the incidents, the employee will be mentioned only in these fields (fullname,employmentdate,birthdate). There are more than 30 fields in the form...i can't make it as subform... It'd be better to have employees (by empid) as subform...

Goodmorning to all! Guys, My problem is the following: I've got a database for safety accidents/incidents. I've a table for incidents and another for employers with fields: tablename:tblEmployers, formname:frmEmployers EmpID FullName EmploymentDate BirthDate In the Incidents form, i've a...

It's working!!!!!!!!! Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I've also noticed, that on the forms filter-after running the query-i have ex: id=10. Form gets filter but doesn't show record, it stil asks for new record...

Data entry is set to yes, allow edits/additions/etc are also to yes...

Hello everybody! I have a form and the problem is the following: On my main form i have a button to open the form to add only data. If i finish inserting data and close the form, when i try to open the form(with another button) and view all the records, i get again a new record form... I've...

Hello to everybody! I have the following problem: I've a search form, with only one unbound text box. On the search button code, i look for the string in a union query which results appears in a subform. On the main form, i've also placed 2 checkboxes which show the username and the...

Hello everybody! Costas, Thessaloniki, Hellas