Search results

Yes there is. It shows up when I use the build function. Unfortunately. i cant post the database.

Doing that brought back the #name error

I have this i removed the criteria but I'm still getting the #error message =DCount("[Completion Time]"," [Testing]") Does it effect it if the Testing paramater is actually a query?

I did everything you suggested and the inside the textbox I'm getting an #error messge

I'm included the table becaue the form is not bound to that table its bound to another table. I changed the textbox code to the following: =DCount("[Testing]![Completion Time]"," [Testing]",TimeValue("2:30:00PM")<[Testing]![Completion Time]) and I'm getting a Name? error in the textbox

I tried that but unfortunately i'm getting an error. =DCount(" [Testing]![Completion Time]","[Testing]","[2:30:00 PM]") and would this count all records after 2:30?

Hello, I have a query running data that pulls all the Dates and Time for a particular day. The Field is called Completion Time and it is a Date/Time column. I want to on a Form display in a textbox the amount of records that are past 2:30 pm. What do i need to put in the textbox field in order...

That works. Thank you!

is that in conjunction with your orginal sql statement. if you can can you provide the entire sql statement.

Thanks for the respsonse. THe function is getting an error message of subscript out of range at this line of code: "while IsNumeric(Mid(ret(i), i, 1))"

The column has information that looks like this: Phones:25~testinginfo:3~Testinfo:7 testingof:9~Phones:38~Testinginfo:9 The results should look like this: Phones:25 Phones:38

Almost that is actually doing the opposite:. I have the following code placed: UPDATE [Testing Log] SET Appends=Replace([Appends],"Phones",""); Also the way the data shows up is the following: Phones:23 or Phones:25. I would need all that information to stay. So after the query runs all the...

Hello everybody. I have a query that has pulled information from a mseter table. On the query in one columns i have information that is scattered and mixed together. Does anybody know a query i can run against a column with the column header as "Appends" that will remove everything that doesn't...

Can you explain your second option more. That sounds doable this way if more tasks get entered i can just add to the table that is being submitted. How would you make it so that only the items not completed will show up for that day?

Thats correct. I'm going for the visual standpoint of when a user opens the form they see what needs to be done. not having to read a report because then things can get confusing for some users on what row they are reading. But if a button is visible then the user would know that that task still...

Hello, I'm starting completely from scratch and need help with this design. I'm trying to create a checklist of items to do everyday. Criteria: Textbox next to a button that represents the task. when the user clicks the button the information from the textbox gets submitted to a table and the...

I actually just ran another query against my query to get the results I need so that ended up working for me.

Yea the problem I'm having is even if I just have it group by just the Account Name itself it still is splitting up the sum results. Do you know the reason for that when everything matches in the file except for the records?

I did it without all the groupings and it is still showing up with more than one name. The reason for more columns is because I'm looking to just summarize everything on one screen and have it all there in one viewing. SELECT [SP Account Info].Name, [SP Account Info].[Term of contract], [SP...

Quick Question, Thanks for responded that query worked to the way I want. Just one question. I'm trying to get the sum of all the total records for each account name that query finds. But for some reason it is showing more than one result for a single account name. I just attached totals and had...