RE: Export with Conditional Statement

HI,

The select statement is too long to include in the post, however, here is the
basic principle on which it is based. There are several variables that are
programmed to be manadatory, meaning they must meet certain criteria within
the access database before being exported into an excel file. If they do not
meet these criteria they are still housed within the access database, they
just do not get exported to the external excel file and then sent to me.

I am trying to come up with code that would allow these mandatory variables
to hinge on one variable-Refused. If Refused=1 meaning that someone refuses
to answer any further questions, then the mandatory variables can be null
(meaning no information needs to be entered into them to export) If Refused=0
meaning that someone agrees to answer further questions, then the prior
conditions must be met in order for that file to export. This way I can safe
guard against incomplete data in the export file.

I hope this helps to clear up the confusion, I appreciate you taking the time
to help.



Kipp Woodard wrote:
It is not clear what you are asking.

Can you post the basic Select statement, and then explain how the two output
sets would be different?

Hello,

[quoted text clipped - 38 lines]
VBA code ?
I didn't think SQL supported IF THEN ELSE statements in MS ACCESS.

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • RE: Export with Conditional Statement
    ... meaning they must meet certain criteria within ... the access database before being exported into an excel file. ... just do not get exported to the external excel file and then sent to me. ... I am trying to come up with code that would allow these mandatory variables ...
    (microsoft.public.access.formscoding)
  • Re: SSL and File Downloads
    ... >> the excel file secure in the transmission. ... Meaning, can ... I should add that if you are passing through an ISA server that has been ...
    (microsoft.public.win2000.security)
  • Re: SSL and File Downloads
    ... > the excel file secure in the transmission. ... Meaning, can ... > someone with a sniffer grab my excel file and be able to ...
    (microsoft.public.win2000.security)
  • SSL and File Downloads
    ... If I am downloading an excel file using HTTPS page, ... the excel file secure in the transmission. ... Meaning, can ... someone with a sniffer grab my excel file and be able to ...
    (microsoft.public.win2000.security)
  • SSL and File Downloads
    ... If I am downloading an excel file using an HTTPS page, ... the file transfer to a local PC using IE 6.0 secure?? ... Meaning, if I put a sniffer on the Internet traffic, can ...
    (microsoft.public.security)
Loading