Search results

One is text, the other is decimal

One is text field the other is a field that has been derived from a query-can I look at the properties of those fields? Also how can I change the amount of places after the decimal? Thanks for looking at this and helping me, I appreciate it.

Here you go: SELECT OTM_40_Credit.USER_ID, Avg(OTM_40_Credit.OTM_Credit_Percent_40) AS AvgOfOTM_Credit_Percent_40 FROM OTM_40_Credit GROUP BY OTM_40_Credit.USER_ID;

Hello, I am working in Access 2000 and have a query based on avg percentages.There are two fields, one for usersId, and the other is percentages. What I am trying to do is to group by userId and then find the average.There are only about 332 lines of code. when I run this query I get an...

Thank you-it worked great!

Hi, I have a field in a table with 020, 040, 050, 060, 070, 080 and I want to query only the 020 and 040's from the field. I have tried "020" And "040" in the criteria and that does not work, I also tried writing it in an expression and that didn't work either. Any ideas? Thanks in advance.

Thank you!!! Worked like a charm

Thanks-but still getting same error

Thank you, I tried the below code and get the error that I have the wrong number of arguments. IIF( [Z] < [Y] -0.5), "A", IIF (AND(( [Z] > [Y] +.5),( [Z] < [Y] + 1.5)),"C", IIF (AND(( [Z] < [Y] +.5),( [Z] > [Y] -0.5)),"B","D"))))

Hello, I am trying to write this "if" statement for a query. I keep getting syntax errors and was wondering if anyone can take a look and see anything. Also is this the best way to do this-should it be a function in a if else statement? IF( [Z] < [Y] -0.5), A, IF (AND(( [Z] > [Y] +.5),( [Z] <...

Thank you very much, got it working!

The code that I used above works. I only want the fields that do not match and it works for that. What I need is to include the other fields that are attached to those fields. I am updating a table from orders that were processed from days before. I don't want to include the order numbers...

Hello, I just figured out how to do a comparison and get only the results of those that are not equal, but I have several more fields that I need to include if the name fields from the table are the same. I have tried a few things and keep getting errors with syntax. Any help is appreciated...

Perfect-Thank you!

Hi, I am working with a table that sends an "S" in a field. I can change the "S" to a "1". But where there is not an "S" in the table I would like a "0". Here is what I am using now: update_flag: Replace([OFF_MILL_IN_SPEC_FLAG],"S","1") I have tried several things, and nothing-is it possible...

Thank you so much-We finally got it working just perfectly. I cannot thank you enough for all of your time and patience. I sure did learn a lot! I hope other people did too! I do have one glitch when we add this to the larger database. When we run the quartile function, it freezes, when we...

I guess neither do I. I run the query to create true_data. Then I run the dq2_test to run the function and that is where I get the error "invalid use of null". and when I debug it takes me into the function. I am still looking as to why-so any suggestions will be great. I am not figuring any...

I was working and zipped and it didn't save my latest. Very sorry. Here is the latest. Still getting the error.I made a few other changes, but didn't help.

Good morning, I thought by using a not null statement in the query I was alleviating the possible null error in calculations when the query made the table. When I try to run a query now, I get an invalid use of null. I made a few other slight changes and am once again lost. Thank you again for...

I am attaching the newest attempt. I am trying everything and am not sure how to fix the newest error. I did get a smaller version working. Then created a make table from a query which I thought would work, but getting new errors. Any suggestions will be appreciated. I am at my wits end, and...