Search results

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...

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...

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:

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!

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...