Search results

Thank you all for the help. It was a group by clause in one of my queries.

I have two queries (A and B) that are each pulling data from the same table. The only difference between the two queries is that query A has 1 parameter and query B has 3. For some reason, I can edit the results from query A in the datasheet view, but I cannot edit the results from query B in...

Ok. The query works with my data. Thanks for all of the help.

Ok. I will try the query again with more data.

Yes, when I type in a number in the dialog box, the query returns no results.

Ideally, if I typed in 30 as the filtering number, I would see something like Tom 33, Jane 48, Bill 51, etc.

No, the clerk field is a text field.

I have 4 columns in my table called Ovens: Last_Name, Age, City, and Clerk. First, I want to count the last names and sum them by clerk. Second, I want to filter based on a number I type (i.e., if I want to see the clerks with sums greater than 24, I only want the query to display sums of 25...

I have a table that I was in the process of cleaning up when I got the following errors: "type mismatch in expression" and "microsoft office access can't open the table in Datasheet view." What does this mean, and how can I get rid of these errors? Thanks.

Ok. I'll give that a try. Thanks for the help.

I have an if statement that keeps giving me a parameter box that asks me to enter a C: Expr1: IIF(IsNull(TORRY.PAF) AND (TORRY.TYPE = “C”), (TORRY.USER_DEFINED), (TORRY.PAF)) What is wrong with my if statement...is it a syntax error? I cannot figure out why the parameter box keeps popping up...

Adam, Thanks so much for your help. It works now...I think the problem was I had a comma in the wrong spot.

Well, I cannot seem to get the query to work. I keep getting a syntax error that says something is wrong with the select statement or that I have not entered enough arguments for the DAvg function.

It does not work. For some reason, Access keeps giving me the error that says I did not include "Issue Number" as part of an aggregate function.

I have a query called Spans1 that calculates the difference between dates: SELECT [Rasp].[Issue Number], [Rasp].Issues, [Rasp].Status, [Rasp].Date_Received, [Rasp].Date_Resolved, DateDiff("d",[Date_Received],[Date_Resolved]) AS Span FROM [Rasp] WHERE ((([Rasp].Status) Like "*" & [Enter...

I am opening the form from a switchboard.

I am opening Access (i.e., the database) from a server rather than off the desktop. I did save after changing the Data Entry property. The form autofills certain fields...could that be an issue?

Ok. I changed the DataEntry = No, but the problem now is when I exit the form and open it back up. The problem is still the same: the form only shows the new record and not the ones already entered. How can I fix this problem for good?

I have a form that doesn't show all my records when I open it. For example, I open Access and then open the database. I click on my form to open it, and it shows no records. I know for a fact that there are several records entered into the database via my form, but the only way I can see them...

I used your query and a box pops up asking me to enter a parameter for name_count. What does that mean, and what should I enter?