Recent content by yeppy12

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...