Combo Query will not work

[360]

I have two tables that I used to build a query. I tried
running the forms off of the query but it failed. I was
able to build forms off of the both tables I am using;
but, as soon as I added the expression it failed.

The expression is [table1]![total]/[table2]![target total].

I'm not sure if the following is a contributing factor but
here goes:

The Date on table 1 looks up all of the data from table 2,
so that in the form when I select a date, the target
totals automatically populate.

All of my other forms work- BUT - the expressions are all
If, then and not an actual calculation. I'm taking all
suggestions; multiple options will allow me to find what
works best...Help!

 

[Ken Snell]

Use a . instead of a ! between the table name and the field name:

[table1].[total]/[table2].[target total]