I am having a brain freeze.
I need to calculate the max and min values from a lookup table for each record in a report. I defined a variable: vFirstRdng as DATE and define it in the report variable section as: (MIN(fuel_date) IN fuel_usage_file WHERE equip_code = .vequip_code AND fuel_date BETWEEN .vfrom_date AND .vto_date) vequip_code, vfrom_date and vto_date are properly defined and have the correct type. I keep getting an error and it will not accept the definition for the variable. I have tried variations of parenthesis, replacing the IN with FROM with no luck The following command works correctly at the r> prompt: SELECT MIN(fuel_date) IN fuel_usage_file WHERE equip_code = .vequip_code AND fuel_date BETWEEN .vfrom_date AND .vto_date And so does this command: SELECT MIN(fuel_date) INTO vFirstRdng FROM fuel_usage_file WHERE equip_code = .vequip_code AND fuel_date BETWEEN .vfrom_date AND .vto_date I don’t use report variables that much anymore but I know I have done this before quite a bit before DBcalc was available. I know I am probably missing something really simple but I can’t seem to figure out what it is… Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137
