General discussion

Locked

MS Access Conditional Statement(If/Then)

By instrumentality ·
I am trying to use Microsoft Access to track my software installations and cross-reference them with my license inventory.

I have a table with a column listing the application name, a second column showing the machine type (PC, Mac, Server), a third column showing the number of copies installed, a fourth column showing the number of licenses, and three yes/no style columns (checkboxes) marked "Shareware," "Freeware," and "To Be Deleted."

I would like to set up a conditional query whereby IF, for instance, the freeware box is *not* checked AND the number of licenses is less than the number of copies installed, THEN the information in that row should be displayed in the query.

Can someone explain how I can set this up, given the fact that I am completely green on setting up expressions in MS Access?

Thanks much.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by instrumentality In reply to MS Access Conditional Sta ...

Point value changed by question poster.

Collapse -

by instrumentality In reply to MS Access Conditional Sta ...

I figured it out but it won't let me withdraw the question for some reason.

Collapse -

by kingtas In reply to MS Access Conditional Sta ...

1. Make a select query in design view.
2. Add the table in question.
3. Add each column individually (not with *)
4. Under the Number Copies column in the criteria field add an expression similar to this expression to fit your column:

Table1]![NumLicense]

5. Under the Freeware column in the criteria field add ths expression:

0

6. Save and run the query.

This works if done correctly. Hope it helps.

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums