Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

CarryOver from other forum

CarryOver from other forum

CarryOver from other forum

Hey, I started thread in the wrong forum apparently. But I think the answer there will suffice.

However, maybe the good folks in this forum and expound.

I have the Approach that came with Smartsuite Millenium. Not sure what version number but I think it's latest version.
I built a DB and need help creating all my queries for making reports, of sorts.

My first query, is to select all records where the date is OLDER then 45 days ago from today. And then to exclude from this list any records which has a certain column as not null.

My bigger question is what is the best way to make queries within Approach, or, how does that work? I found the SQL query wizard to be quite limiting already. And what would be a good reference for SQL query syntax supported in Approach?


RE: CarryOver from other forum

You have two options for developing and storing queries in Approach.

1) The Find Assistant can set up multiple conditions with "and" and "or" between them.

2) You can do a manual Find and enter conditions and formulas into fields on the view and the give the Find a name by typing over the <current find/sort> in the Action Bar after you have run the Find successfully.

In your example, I think the manual Find method would be the easiest to set up.

In a text field on the view you are doing the Find on, go into Find mode, then type this formula into a text field:

If(yourdatefield < (Today() - 45) and yourotherfield <> '')

This formula compares your date field to Today's date less 45 days and your other field is not equal to null (<> is not equal, '' is two single quotes with no space between them).

Sue Sloan

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close