IF Statement

[Mike]

my database looks like
http://www.filehive.com/files/080717/access.bmp
http://www.filehive.com/files/080717/report.bmp

is it possible to create an if statement where if
WSIB+Insurance Expires PRint report 1 else if
WSIB expires=print report2 else if
Insurance Expires=print report3

but where it'd print all the reports tht meet this critieria?
would i need 3 different forms to do that? :S

and does any1 know any good books to buy that are simple to learn and can
teach stuff like this? i'm getting into access alot over the summer. Thanks

 

[pietlinden]

my database looks likehttp://www.filehive.com/files/080717/access.bmphttp://www.filehive.com/files/080717/report.bmp

is it possible to create an if statement where if
WSIB+Insurance Expires PRint report 1          else if
WSIB expires=print report2            else if
Insurance Expires=print report3

but where it'd print all the reports tht meet this critieria?
would i need 3 different forms to do that? :S

and does any1 know any good books to buy that are simple to learn and can
teach stuff like this? i'm getting into access alot over the summer. Thanks

What does "WSIB+Insurance Expires" mean? If both are past? (less than
today's date?)

 

[wendy]

Hi, does anyone know of a newsgroup that has new , fun, pretty stationary??
Thanks... my email address is (e-mail address removed)
thanks,
Wendy

 

[Mike]

umm wsib valid until=expires on that date
and insurance expires= expires on that date

so if wsib valid until + insurance < today's date = print report 1 for all
suppliers who meet tht criteria
if isnurance < today's date print report 2 for all the suppliers who meet
tht criteria
if WSIB valid until < today's date print report 3 for all the suppliers who
meet tht criteria

 

[Mike]

NeverMind i figured it out, how do you delete threads?

 

[Larry Linson]

Hi, does anyone know of a newsgroup that has
new, fun, pretty stationary??
Thanks... my email address is <SNIPPED>

This newsgroup is for discussion and questions and answers about Microsoft
Access database software. It is unlikely to be a useful source in your
quest. In fact, I doubt any of the Microsoft-sponsored newsgroups (their
name would begin with "microsoft.public.", even those dealing with Word or
Publisher software would be a particularly good source. My inclination
would be to recommend you use Google, or your favority search engine, to
find a source (which, my guess is, will not be a newsgroup, but a website).

A lot of us here would regard "new, fun, pretty stationery" as cluttered
background making message content more difficult to read, a waste of ink,
and a waste of bandwidth when the message is transmitted -- I guess some of
us just aren't all that much into "new, fun, pretty" when it comes to
computer communication.

Larry Linson
Microsoft Office Access MVP

 

[glen stevens]

my database looks like
http://www.filehive.com/files/080717/access.bmp
http://www.filehive.com/files/080717/report.bmp

is it possible to create an if statement where if
WSIB+Insurance Expires PRint report 1 else if
WSIB expires=print report2 else if
Insurance Expires=print report3

but where it'd print all the reports tht meet this critieria?
would i need 3 different forms to do that? :S

and does any1 know any good books to buy that are simple to learn and can
teach stuff like this? i'm getting into access alot over the summer.
Thanks