Two tables, one is Budget the other Actual, sorted by RevID – a primary key
in both tables, feeding a query.

In qryNetRev …..
If the value for a record from Actual.NetRev is blank, would like that field
to return the value for that same record from Budget.NetRev.

This *has* to be a very normal practice, but can’t quite get the syntax
correct.

Any assistance will be much appreciated.

Thanx,
- Mike

On 5 mei, 02:47, MikeF <Mi...@discussions.microsoft.com> wrote:
> Two tables, one is Budget the other Actual, sorted by RevID – a primarykey
> in both tables, feeding a query.
>
> In qryNetRev …..
> If the value for a record from Actual.NetRev is blank, would like that field
> to return the value for that same record from Budget.NetRev.
>
> This *has* to be a very normal practice, but can’t quite get the syntax
> correct.
>
> Any assistance will be much appreciated.
>
> Thanx,
> - * * * Mike

Add a field to the query.
YouNameIt: IIF(IsNull(Actual.NetRev);Budget.NetRev;Actual.NetRev)


Groeten,

Peter
http://access.xps350.com

Thanx, that worked [except w/commas, not ";"].

"XPS350" wrote:

> On 5 mei, 02:47, MikeF <Mi...@discussions.microsoft.com> wrote:
> > Two tables, one is Budget the other Actual, sorted by RevID – a primary key
> > in both tables, feeding a query.
> >
> > In qryNetRev …..
> > If the value for a record from Actual.NetRev is blank, would like that field
> > to return the value for that same record from Budget.NetRev.
> >
> > This *has* to be a very normal practice, but can’t quite get the syntax
> > correct.
> >
> > Any assistance will be much appreciated.
> >
> > Thanx,
> > - Mike
>
> Add a field to the query.
> YouNameIt: IIF(IsNull(Actual.NetRev);Budget.NetRev;Actual.NetRev)
>
>
> Groeten,
>
> Peter
> http://access.xps350.com
> .
>