Search results for query: *

Hello, I'm trying to write some code to take all the tables I have created and put their names in a list/table. I was able to do this with form names but not table names. Dim obj As AccessObject, dbs As Object Dim formsdata1 As Recordset Dim i As Long i = 0 CurrentDb.Execute " DELETE [All...

Thanks, I'll give it a shot. Ya, this started out to be an experiment, so the details at the beginning were overlooked, such as the table name. Now it's become a project! To late to change it now! (Maybe) Thanks again!

Thank you Leslie and Lameid. Yes I need to match any of them and count it in the total. I tried 'AND' as well as 'OR' and couldn't get either of them to work. It looks like this... =DCount("[QueueName]","frmJanuary1","[QueueName] ='New Enquiries' OR [QueueName]='Closed' OR [QueueName]='Ready...

So assuming I used this coding and it worked.... =DCount("[ItemCategory]","tblTableName","[ItemCategory] ='Word1'") Now I need to have one function count several different words and their occurance...how do I end this..for example =DCount("[ItemCategory]","tblTableName","[ItemCategory]...

Yes that worked!! Thanks Bill, you are the man! Ryan

Hey, Not sure if I'm in the right Forum, but here it goes. I thought I knew what I was doing apparently not. I want to count the number of times a 'word' appears in a column. Let's say I have a table called "January1", a column called "ItemCategory". I want to 'count' the number of times...

Hey, Not sure if I'm in the right Forum, but here it goes. I thought I knew what I was doing apparently not. I want to count the number of times a 'word' appears in a column. Let's say I have a table called "January1", a column called "ItemCategory". I want to 'count' the number of times...