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

Last Comment

Shiv

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Shiv

2/15/2010

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

2/15/2010

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

2/15/2010

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

2/15/2010

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!

Certified Expert Program

Credly Partnership

Udemy Partnership