G
Guest
I have two questions. Any help would be appreciated.
1. In the expression box in formatting, I type the followin in
[nLAY]>=28and<=90and [nTRN]=400 and[rTRN]=1
I get an error message saying a comma within the preceding value or
identifier is missing. How do I write that formula correctly.
2. I type the following formula in the expression box. [(rKRAT]>=1
AND[rKRAT]<=2) AND [nMLO]>=6
I get a message that tells me that the field nMLO exists in two tables.
The report is made up of a table ALL_HX4 and a query PL4. The values in PL4
came from ALL_HX4, but [nMLO] isnt in PL4.
How can I tell access what table or field I want PL4 to come from?
If you have time to help and I havent made myself clear, please tell me what
you dont understand?
I do look in books for answers, but not succesfull this time.
Thanks a million for any help.
Ed
1. In the expression box in formatting, I type the followin in
[nLAY]>=28and<=90and [nTRN]=400 and[rTRN]=1
I get an error message saying a comma within the preceding value or
identifier is missing. How do I write that formula correctly.
2. I type the following formula in the expression box. [(rKRAT]>=1
AND[rKRAT]<=2) AND [nMLO]>=6
I get a message that tells me that the field nMLO exists in two tables.
The report is made up of a table ALL_HX4 and a query PL4. The values in PL4
came from ALL_HX4, but [nMLO] isnt in PL4.
How can I tell access what table or field I want PL4 to come from?
If you have time to help and I havent made myself clear, please tell me what
you dont understand?
I do look in books for answers, but not succesfull this time.
Thanks a million for any help.
Ed