Avatar of goretailpro
goretailpro
 asked on

Access Query

Right now I am making a formula

What would the correct formula for Crystal be where add all the fields above and then say I need a filter for this formula where HRO.STATUS = C?
{HRO.TAX_PARTS}+{HRO.NTX_PARTS}+{HRO.TAX_LABOR}+{HRO.NTX_LABOR}+{HRO.TAX_SUBLET}+{HRO.NTX_SUBLET}+{HRO.SUPPLIES}+{HRO.ST}-{HRO.DISP}-{HRO.DISL}-{HRO.DISS}

AND {HRO.STATUS} = "C"

Open in new window

Microsoft AccessCrystal ReportsSSRS

Avatar of undefined
Last Comment
Shiv

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Shiv

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
goretailpro

ASKER
I have other formula's on the this report and as soon as I put this formula on the report it eliminates the other two formula's.

They are  attached below.. the formula above and below reference two different tables.
IF {Customer.LAST_VISIT} in DATE (1982, 01, 01) to DATE (2009, 11, 14) THEN COUNT ({Customer.VISITS}) > 0


IF {Customer.LAST_VISIT} in Date (1982, 01, 01) to Date (2009, 11, 21)   THEN COUNT ({Customer.VISITS}) > 0

Open in new window

goretailpro

ASKER
I added this date filter is that correct?
if {HRO.STATUS} = "C" AND {HRO.PAY_DATE} in DATE (2009, 11, 15) to Date (2009, 11, 21) then

{HRO.TAX_PARTS}+{HRO.NTX_PARTS}+{HRO.TAX_LABOR}+{HRO.NTX_LABOR}+{HRO.TAX_SUBLET}+{HRO.NTX_SUBLET}+{HRO.SUPPLIES}+{HRO.ST}-{HRO.DISP}-{HRO.DISL}-{HRO.DISS}

else 0

Open in new window

Shiv

yes it works..glad if i cud help
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes