[thewebbmasterone]

I'm using ms access 2003 and i created a table that tracks safety violations at work. I have a column that allows me to select from a couple different statuses. I have 3, Corrected, not corrected, and void. I am trying to query the table so that i can see the complaints that are either marked not corrected, or have not been looked at yet and so the status is blank. So i need a query for "not corrected" and "blank". I'm new to visual basic and the coding that goes with it. Can someone please help me. Thanks.

[Jimmy the Hand]

Hi

I'm not sure you need VBA code for this. You can create this query with the built in query builder. The condition will be something like Status <> "corrected".

Naturally, you can do this through VBA, too. One possible way is to define the query in SQL language, and open a recordset based on this SQL string. E.g.

Dim Rst As DAO.Recordset, mySQL As String
mySQL = "SELECT * FROM [tbl_Violations] WHERE [Status] <> 'corrected'"
Set Rst = CurrentDb.OpenRecordset(mySQL)

The first method is more convenient, and easier to use. The second method is good for something, too, but it all depends on what do you need it for.

Jimmy

[slurpee55]

Webmaster, you have made several posts all dealing with different aspects of the same database.
(everyone - the other two are
http://forums.techguy.org/business-a...ble-based.html
http://forums.techguy.org/business-a...sn-t-fill.html)
It would be far more efficient if you only posted once - we will help you, but this scattershot process is going to have some people helping with some things and others with others, sometimes at cross purposes.

I have suggested that we use this as the thread to use at both the other threads.

[thewebbmasterone]

sorry, i'm new to all of this. usually i don't post anything on forums i just read them and fiddle until i figure it out. I'll post any further questions here in this thread.

[slurpee55]

That's ok - a lot of newcomers make that mistake. Welcome to the Forum!

[slurpee55]

Agh...Jimmy, webmaster, since OBP is doing quite a bit of work on this in this thread
http://forums.techguy.org/business-a...ml#post6039245
I am going to just forget it all.