IIf statement with "and" for tables with no relationship

  • Thread starter Thread starter margaret
  • Start date Start date
M

margaret

I have two tables ... redemption and sold. In the sold table, I have three
fields serialopen, serialclose, and fairdate. In redemption, I have serial.

Example of sold:

Serialopen -- c1000; serialclose c1999; fairdate 10/15/2004

Example of redemption

serial --- c1750

I need to figure out if serial falls with in the serialopen and serialclose
and return the fairdate. My statement is: SoldDate:
IIf(([serial]>=[serialopen] And [serial]<=[serialclose]),[fairdate],Null)

Since I have no absolute relationship between these two tables, how do I go
about running the query?

thanks for any help.
 
Try this on your data --
SELECT redemption.serial, Sold.fairdate
FROM redemption, Sold
WHERE (((redemption.serial) Between [serialopen] And [serialclose]));
 
That worked ... thanks for your help

KARL DEWEY said:
Try this on your data --
SELECT redemption.serial, Sold.fairdate
FROM redemption, Sold
WHERE (((redemption.serial) Between [serialopen] And [serialclose]));

--
KARL DEWEY
Build a little - Test a little


margaret said:
I have two tables ... redemption and sold. In the sold table, I have three
fields serialopen, serialclose, and fairdate. In redemption, I have serial.

Example of sold:

Serialopen -- c1000; serialclose c1999; fairdate 10/15/2004

Example of redemption

serial --- c1750

I need to figure out if serial falls with in the serialopen and serialclose
and return the fairdate. My statement is: SoldDate:
IIf(([serial]>=[serialopen] And [serial]<=[serialclose]),[fairdate],Null)

Since I have no absolute relationship between these two tables, how do I go
about running the query?

thanks for any help.
Click to expand...
Click to expand...
 
Back
Top