different parameters - same field

[DKnight via AccessMonster.com]

Hi,
I am trying to run a report where you get a list on people on a certain cycle,
amt due > $100, etc. I want to be able to input more than one cycle without
having to run multiples queries. Can I do this?

 

[vanderghast]

Use a table. Assuming they are all for a given cycle, have the amount >
minTestAmount, then have a table:

cycle minTestAmount 'fields
1 100
2 106
3 109



Bring the two tables (your initial table and this reference table) in a
query,

Under initialTable.cycle, add the criteria:
= [refTable].[cycle]

Under the initialTable.amount, add the criteria:

[refTable].[minTestAmount]

and that's all.



Vanderghast, Access MVP

 

[KARL DEWEY]

If I understand you correctly then you could use a union query to pull the
sets like this --
SELECT Name, [amt due], "$100 or greater" AS [Amount]
FROM YourTable
WHERE [amt due] >100
ORDER BY Name
UNION ALL SELECT Name, [amt due], "$50 to $100" AS [Amount]
FROM YourTable
WHERE [amt due] Between 50 AND 99.99
ORDER BY Name;

 

[DKnight via AccessMonster.com]

Hi,
I am trying to run a report where you get a list on people on a certain cycle,
amt due > $100, etc. I want to be able to input more than one cycle without
having to run multiples queries. Can I do this?

I think I need to explain myself more. The report is based on the cycle that
is keyed by an employee, I want them to be able to run multiple cycles on
the same report. eg. cycle 101 and 102 and 103 etc.

 

[DKnight via AccessMonster.com]

I figured it out, Thanks!!

I think I need to explain myself more. The report is based on the cycle that
is keyed by an employee, I want them to be able to run multiple cycles on
the same report. eg. cycle 101 and 102 and 103 etc.