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?

Yes.

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


Sharkbyte




"Allen" wrote:

> 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?

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




"Sharkbyte" wrote:

> Yes.
>
> If [Region] = "x" and [EmployerSize] = "x" [City] = "x" Then
> *Do this*
> Else
> *Do this*
> End If
>
>
> Sharkbyte
>
>
>
>
> "Allen" wrote:
>
> > 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?

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.



"Sharkbyte" wrote:

> 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
>
>
>
>
> "Sharkbyte" wrote:
>
> > Yes.
> >
> > If [Region] = "x" and [EmployerSize] = "x" [City] = "x" Then
> > *Do this*
> > Else
> > *Do this*
> > End If
> >
> >
> > Sharkbyte
> >
> >
> >
> >
> > "Allen" wrote:
> >
> > > 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?

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


"Allen" wrote:

> 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.
>
>
>
> "Sharkbyte" wrote:
>
> > 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
> >
> >
> >
> >
> > "Sharkbyte" wrote:
> >
> > > Yes.
> > >
> > > If [Region] = "x" and [EmployerSize] = "x" [City] = "x" Then
> > > *Do this*
> > > Else
> > > *Do this*
> > > End If
> > >
> > >
> > > Sharkbyte
> > >
> > >
> > >
> > >
> > > "Allen" wrote:
> > >
> > > > 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?