[Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

Help in building an maketable or append query in Access 2007

I am creating a new database for our company.
My situation is that every day, we get a list of items that are failing. Sometimes we need to watch these items for a few days.

What I want to do is:
(This is based off of the account number and status)
What I want to do is look at the account number and status. If the account number is found, look at the status. IF the status is not closed, then add the info with the CURRENT incident number into the issues table. If the Account is closed, then create a NEW incident, then add the info into the issues table.
If the account is not found, then create a new incident. and add to the issues table
I will submit my database later as I am making a few little changes.

I am looking for any ideas on the concept here? Can you do an IF OR in a SQL?

1 Solution
Bill RossCommented:

You can do an if, else if but not an if or.


BrujAuthor Commented:
I was hopeing for some samples or something, but it got me pointed in the correct direction (I think)
Looks like I will be reading in one line at a time and then deterning if it is now or a repeat


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now