Recent content by mocamira

I don't know... I would like to create some sort of general function... Probably one table at a time.

That works thanks! But is it possible to do the same thing for different tables with different fields... like this Ratio = Value/DAvg("value1","table1") and the same ratio to work for value 2, table 2... Like the SUM function for example, it works with all the tables and values you want...

Hi, I have just started "coding" in VBA 2 days ago... I am trying to do a function as follows: Ratio = value/Davg(value) value being a field in a table we can call table. I got to this stage: Function Ratio(value) Ratio = End Function I have managed Ratio = 1/value, or Ratio = value +1 and...

That doesn't really work... That doesn't really work because I don't want a Yes/No Field in the table. I want it to change in the query depending on the result of the IIf function so that If I change the value in the table and the IIf function result is "No" it unchecks the box in the result of...

Hi, I am doing a query in which I input a formula IIf(Value>0,Yes,No) and would like to see the results appear as check boxes ticked or unticked instead of lists of Yes and No. Apparently there is a way to change the format in the properties but I can't see how! Any ideas??? Cheers :rolleyes:

Hi, First time on this forum, I really hope I'll get a reply! Here is the situation: I have a table with an ID, and a velocity value. I want to calculate for each ID the velocity value/the average of all the velocity values. This is very easy to do on excel but not on Acces! The main problem...