I want to use a "constant" in some of my calculations. In this case it's a postal mailing application which selects different names-and-addresses depending upon whether it's the first, second, or third attempt to contact people. So, I want a way to enter the value 1 into every record of a select transaction this month, the value 2 next month, etc.
I'm running Access 2007 with Windows 7 Pro.
I've tried to do this by having a table containing this value and another value used in a similar manner. Then I did a select query with the name-and-address table and this "values" table. I end up with duplicate records in the query result: every name appears exactly twice. I set up a test database, with the same result. Obviously, I'm doing something wrong, but don't understand what my error is!
Thanks for any help,