IF THEN

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Im trying to logically convert an if/then statement from
Excel to Access anybody got an idea? If so email your
response to the address above.
 
What do mean by "logically"?
The VBA code for If..Then..Else should be the same.
Can you explain in detail exactly what the statement is
and what you are trying to do with it. We can help you
better with an explanation that is not so vague.
How/Where do you use it in Excel. What are you trying to
do in Access?
 
Im trying to logically convert an if/then statement from
Excel to Access anybody got an idea? If so email your
response to the address above.
Click to expand...

Look up IIF in the online help.

Three comments:

Access IS NOT A SPREADSHEET. It is *not* a bigger version of Excel;
applying spreadsheet logic to a relational database will get you all
twisted up.

Like most of the volunteers here, I'm a self-employed developer,
donating my time to the newsgroups. Private EMail support is reserved
for paying clients. If it's worth my time to volunteer to come answer
questions, it should be worth yours to come to the newsgroup for the
reply. Your request is considered impolite.

Posting your real EMail address is, alas, somewhat dangerous for you.
There are spammers and (worse) viruses (the notorious SWEN virus for
example) which routinely trawl through newsgroups looking for
addresses. If you start getting EMails with 150KByte attachments
purporting to be Microsoft security upgrades... delete them unopened,
they're that virus.

Please reply to the newsgroup, not to the EMail.
 
Back
Top