 |
|
||||||||||
|
M.A.R.S |
||||||||||
|
This forum is for the sole use of MARS users. ChristianSteven Software will not accept any responsibility for the contents.
|
||
| Return to Website | ||
 First |
 Prev |
 Reply |
 Forum |
Next  |
Last  |
| Viewing Page 1 of 1 (Total Posts: 1) |
| Author | Comment |
Howard Shively
Sep 13, 06 - 11:05 PM |
DLookUp function in MARS
I'm new to MARS. Prior to running ANY report in our LARGE Access database, I must first determine if two steps have been completed. Both steps set specific values in a table. I have created an access query that retrieves the necessary data. I then can use a DLookUP to determine if the required data is found. First Check -- DLookup("StatusLevel", "qry_950_MARS_Vendor_Orders_Complete_?") Second Check -- DLookup("StatusLevel", "qry_950_MARS_Moving_Orders_Closed_?") In both checks, the DLookup would either return a number or a NULL. If a number is returned the task was completed; if NULL returned the task was NOT completed. My question: Can I run the DLookUP from MARS and based on the return; have MARS run or cancel the scheduled report. If so, HOW? Thank you, in advance, for your assistance. Sincerely, Howard |
| First |
Prev |
Reply |
Forum |
Next |
Last |