Search results

Hello All, I have a form which from a button opens a query. Once the query is open I have to close the form so the query is on top and can be veiwed. I created a macro to do that. But now when the user closes the form, I want to open the form again. I have tried to create a macro to do this and...

Good Morning All, I am trying to get a query to read from a form a beginning date and an ending date for the query. If I query just by the user id it works great, but once I add the time-I get blank results. I have several fields in my table-user id, start time, end time are the three I am...

Hello all, I am learning Access and am continuing to learn more and more and love it! I have gotten so much help on this forum from reading the posts and asking questions, I really thank everyone for there help. Just when I think I am getting going, I stumble though. I am trying to make a...

Hello, I think maybe there is a flaw in my design, so any help or suggestions would be appreciated. I have a table which has the fields name, productivity, grade. The grade is based on a formula and is A,B,C, D. These grades are given the time the query is ran. Is there a way I can Add how...

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

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.

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

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

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

I am new to all of this, so any help, direction and expertise is appreciated. I have a query that runs and filters all kinds of information. In that query I want to run a function, but am not sure what parameters I should use. I am trying to use the orginal parameters of the function but...

Hi, I know I have seen sveral examples but I can't seem to get them to work. I would like to get the quartile function from excel to work on a table or query. I have played with calling other excel functions and they are working. But when it comes to getting the array into a function for the...