Search results

Have a look a tthe sample database in this thread: Search Db There are several vb lines that deal with the LIKE statement. HTH

Can you post the SQL of the update query?

Try... IIf(IsNull([DefinitionField]),Null,[LabelField])

Here is a really quick version of how to calculate a running total... I threw this together in a few minutes so don't expect anything fancy...should get you started in the direction you need. HTH

Thanks Jerry...had to change one line... Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Select * from Mytable") Do While Not rs.EOF Dim i As Integer For i = 0 To (rs.Fields.Count - 1) If rs(i).Value = "Null" Then rs.Edit rs(i).Value = Null...

Do a search on Random or RAND function...you should get several examples...here is one that should help you... Random

Have you considered adding a number field (i.e. RptSortOdr) where you could input the number where you want the Brand to be sorted? Then sort Ascending on that field in the Report.

Afternoon Folks... I have an export that comes out of Siebel that we import into an Access 2000 Db. I import the csv file into a temp table to do some separation into two tables (this Normalizes the information in the database). The problem that I have is that when there is a NULL value in a...

Change the criteria of the field to be IS NOT NULL... HTH

Set the criteria of the field that contains the values in your Query to be IS NOT NULL. You can set this at the table level by adding a Filter to the table. This is not recommended due to the fact that if you want to view the records later you have to remove the filter/sort...better to do this...

I was wondering if anyone had some experience with creating a module to rank according to a priority. I know how to create a module and query to rank based on a cost or date, but this is a little different. I have a table tblTicketEsc that contains the following fields: TicketID - Unique...

See the attached

Assuming you are using a query, you can add the following to the Criteria of the name field: <>[All students except?] When you run the query, you will get the dialog box that asks the following "All Students except?", if you type "Smith" you will get all students who's last names are not...

What version of Access are you using?

There is a sample Db I posted in the Sample section that has a Common Dialog Box Function. Do a search for Common Dialog Box. HTH

SELECT Month([Date]) AS [Month], Sum(tblInfo.Items) AS SumOfItems FROM tblInfo GROUP BY Month([Date]); HTH

Take a look at this "Audit Trail" Sample Db. It will allow you to see the original data, changes made to it and the User making the changes. HTH

You could use a Select Case Statement: Here is a really crude example...I put this together in about 5 minutes...so don't expect anything to exciting...

See the following: Listbox to Query Criteria HTH

Select MsgBox from the Action item list in the Macro and fill in the appropriate message for the user. Add it after the rest of your code has completed running. Ghudson: Sent a message to Mile to have him move this...