criteria evaluation of field values

[Guest]

I have a database with compensation data in it which is divided by row into
summary data for a specific cut of data to a position. For example I have a
job of Accountant and summary data for this position split out by region on
one, revenue size of employer on another row, or located in a city or not on
another row and total of all splits on another row.

In my query I am trying to write an equation that will say if I have x
region and x employer size and x city then use them all. If not then only
use total split.

Is this possible?

 

[Guest]

Yes.

If [Region] = "x" and [EmployerSize] = "x" [City] = "x" Then
*Do this*
Else
*Do this*
End If


Sharkbyte

 

[Guest]

I missed the last AND statement, in there...

If [Region] = "x" And [EmployerSize] = "x" And [City] = "x" Then
*Do this*
Else
*Do this*
End If

Sharkbyte

Yes.

If [Region] = "x" and [EmployerSize] = "x" [City] = "x" Then
*Do this*
Else
*Do this*
End If


Sharkbyte

I have a database with compensation data in it which is divided by row into
summary data for a specific cut of data to a position. For example I have a
job of Accountant and summary data for this position split out by region on
one, revenue size of employer on another row, or located in a city or not on
another row and total of all splits on another row.

In my query I am trying to write an equation that will say if I have x
region and x employer size and x city then use them all. If not then only
use total split.

Is this possible?

 

[Guest]

thanks for the feedback and I was worried that I was not clear on the way the
database is set up. I have rows of accountant data by data split, so I'm
trying to grab just those rows of split data in the [LINEID].

So [LINEID] is equal to "und300" and "totRevMid" and "rurlrp". If I don't
have all three then just give me [LINEID] "totalrp".

I hope that makes more sense.

I missed the last AND statement, in there...

If [Region] = "x" And [EmployerSize] = "x" And [City] = "x" Then
*Do this*
Else
*Do this*
End If

Sharkbyte

Yes.

If [Region] = "x" and [EmployerSize] = "x" [City] = "x" Then
*Do this*
Else
*Do this*
End If


Sharkbyte

I have a database with compensation data in it which is divided by row into
summary data for a specific cut of data to a position. For example I have a
job of Accountant and summary data for this position split out by region on
one, revenue size of employer on another row, or located in a city or not on
another row and total of all splits on another row.

In my query I am trying to write an equation that will say if I have x
region and x employer size and x city then use them all. If not then only
use total split.

Is this possible?

 

[Guest]

Allen:

So your statement might look something liek this:

'Statement meets your criteria
If [LineID1] = "und300" and [LineID2] = "totRevMid" and [LineID3] = "rurlrp"
Then
<do this>

'Statement Doesn't meet your criteria and only want "totlrp" returned
Else
<do this>
End If

Sharkbyte

thanks for the feedback and I was worried that I was not clear on the way the
database is set up. I have rows of accountant data by data split, so I'm
trying to grab just those rows of split data in the [LINEID].

So [LINEID] is equal to "und300" and "totRevMid" and "rurlrp". If I don't
have all three then just give me [LINEID] "totalrp".

I hope that makes more sense.

I missed the last AND statement, in there...

If [Region] = "x" And [EmployerSize] = "x" And [City] = "x" Then
*Do this*
Else
*Do this*
End If

Sharkbyte

Yes.

If [Region] = "x" and [EmployerSize] = "x" [City] = "x" Then
*Do this*
Else
*Do this*
End If


Sharkbyte




:

I have a database with compensation data in it which is divided by row into
summary data for a specific cut of data to a position. For example I have a
job of Accountant and summary data for this position split out by region on
one, revenue size of employer on another row, or located in a city or not on
another row and total of all splits on another row.

In my query I am trying to write an equation that will say if I have x
region and x employer size and x city then use them all. If not then only
use total split.

Is this possible?