T
tamxwell
Here is my Query. I need to pull more than one company number from the
[co-number] field.
SELECT
ALL_AGINGS_ALL.[co-number], ALL_AGINGS_ALL.[divn-number],
ALL_AGINGS_ALL.[cust-number], ALL_AGINGS_ALL.[cust-name],
ALL_AGINGS_ALL.TranType, ALL_AGINGS_ALL.[ref-number],
ALL_AGINGS_ALL.[as-of-date], ALL_AGINGS_ALL.[due-date],
ALL_AGINGS_ALL.[item-amount], ALL_AGINGS_ALL.Today,
DateDiff("d",[Due-Date],[Today]) AS DSO, ALL_AGINGS_ALL.Current,
ALL_AGINGS_ALL.[1-30], ALL_AGINGS_ALL.[31-60], ALL_AGINGS_ALL.[61-90],
ALL_AGINGS_ALL.[91-180], ALL_AGINGS_ALL.[181-360], ALL_AGINGS_ALL.[360+],
ALL_AGINGS_ALL.CA, ALL_AGINGS_ALL.CM, ALL_AGINGS_ALL.[Internal/External],
(ALL_AGINGS_ALL.[co-number] IN (1, 2))
FROM ALL_AGINGS_ALL
WHERE ((([ALL_AGINGS_ALL].[co-number])=[Which Branch do you want data for?])
And (([ALL_AGINGS_ALL].[co-number])=[Enter Branch number]));
[co-number] field.
SELECT
ALL_AGINGS_ALL.[co-number], ALL_AGINGS_ALL.[divn-number],
ALL_AGINGS_ALL.[cust-number], ALL_AGINGS_ALL.[cust-name],
ALL_AGINGS_ALL.TranType, ALL_AGINGS_ALL.[ref-number],
ALL_AGINGS_ALL.[as-of-date], ALL_AGINGS_ALL.[due-date],
ALL_AGINGS_ALL.[item-amount], ALL_AGINGS_ALL.Today,
DateDiff("d",[Due-Date],[Today]) AS DSO, ALL_AGINGS_ALL.Current,
ALL_AGINGS_ALL.[1-30], ALL_AGINGS_ALL.[31-60], ALL_AGINGS_ALL.[61-90],
ALL_AGINGS_ALL.[91-180], ALL_AGINGS_ALL.[181-360], ALL_AGINGS_ALL.[360+],
ALL_AGINGS_ALL.CA, ALL_AGINGS_ALL.CM, ALL_AGINGS_ALL.[Internal/External],
(ALL_AGINGS_ALL.[co-number] IN (1, 2))
FROM ALL_AGINGS_ALL
WHERE ((([ALL_AGINGS_ALL].[co-number])=[Which Branch do you want data for?])
And (([ALL_AGINGS_ALL].[co-number])=[Enter Branch number]));