Recent content by tsvetkovd

I think I figured out what my IIF statement should look like, if it's possible. Although it may look stupid as iif sentence these are the conditions I need to follow. Something like this: Next Inspection: iif ([ConditionCode] of [Components] of [TrussGirder]and[ArchBridge]> 3)...

Thank you, fair enough. Appreciate it. You helped me more than enough. I need to read more about how to form the sentences in the queries, will you please give some links providing that information.

Hi, yes, it is an exercise :o, for me. But its getting complicated :banghead:. Since I need to apply those changes in the inspection frequency for a list of component types on bridges of selected construction types. And this should apply all updates for a particular review date to all affected...

Hi again, I am afraid I need your help again. This time the tings are get a lot more complicated(at least for me) . The situation is as follows: *From time to time, the organization decided to change the inspection frequency for a list of component types on bridges of selected construction...

Hi again, I am afraid I need your help again. This time the tings are get a lot more complicated(at least for me:confused:) . The situation is as follows: *From time to time, the organization decided to change the inspection frequency for a list of component types on bridges of selected...

You are great :-). Thanks a milion. I wish a could be able to help you about anything. Thank you! Have a good day :)

Yes, sorry for not specifying. The values are the frequency of inspections in months. They are between 12 and 36 months in column [FrequencyInMonths]. To update the inspection frequency I wrote the above mentioned iif statement(which increases the frequency if the [ConditionCode] shows that the...

I did the following statement : Inspection_update: IIf([ConditionCode]>3,[FrequencyInMonths]-12,[FrequencyInMonths]+12) in a query. It works well. I wonder how can I do some changes and write another statement in that query to make the values in Inspection_update not to be less than 12 and more...

Thank you for responding. When I typed this in the access, builder said "invalid syntax"

Please, help me to figure out how my statement should look like. I need to make the following statement: waste not < 12 and not > 36. Thank you :rolleyes:

Very helpful videos :). I have one more question which I've been trying to solve. I need to implement an update in my database. I asked a friend, he said that it could be done by query. I need to use query to update the inspection frequencies for some of the bridge components. You will save my...

Thanks a lot. Appreciate it! :)

Please, anyone tell me what means a table to appear as an entity on the diagram? And how to identify the cardinality of a relationship and how to specify which is mandatory and which is optional, please? Thank you!

Thank you for your quick reply. I will do it right away :)

I am a student in applied computing course, we've just began learning access. I had a simple task that I think I've done it, except one error that keeps popping up every time I try to set up a PK for a particular table. Please tell me, what is wrong. I've tried to fix that, following the...