SELECT * from __, revenue*dlookup('[ ]','__', '=" "'), revenue*dlookup('[ ]','__', '=" "')
http://www.sql.ru/forum/1105756/ispolzovanie-konstant-v-vyrazhenii-sql