Search results

How can I use more than one IIf I want to have it enforce that 2 different cols are Null and use ,= on a third col. I seem to get only 2 out of 2 working because I must be typing it wrong. I tried And I want it like IIf([field1] And [field2] Is Null And[filed3]<= [field4],"Same") I know that...

This works great but I forgot a couple things. First if someone has not tested it shows a zero as pre and post and counts as staying the same which will throw off the statistics. And I also need to run this to show how many were <> or + for each level of each subject. Should I try to make a...

Thank you I think that will work. I just looked quickly looked afterward but I seem to be getting a wierd box when I run my report off this query. It is showing my first field and asking for the parameter. I need to look this up also. I do not know what that means.

I have 2 columns that contain results of testing. I need to show whether there was a gain or loss in scores. I have a code (1,2,3,or 4) instead of the text to make it easier. I need to have my query compare the two and tell me if the difference between the 2 is > < or =. I am new to Access and...

I have a DB that contains statistics on students in a program. There are 5 age groups. When I run my query for my end of year results and only have students in one or two age groups of course that is all that shows up in the query. The only problem is my report that is based on this query will...

I know I seem stupid to you but I cannot do this. I think I am getting the idea but seem to be messing it up. Are you saying I should go to my fist box (the one that is a list box)and in afterupdate event I am putting a statement that says the other field equals this one after update. I tried...

I have a form to enter date. In one box I use a list box and store the first col. In another I have =[Combo129].Column(1) in the source box. It works great, selecting the proper info from the second field. But when I go to my table I see it does not store the info there. I can go back to my form...

I am so sorry I keep type date instead of data. I hope it is not confusing anyone. This is not a date field.

I will try to explain what I am doing. There are 6 levels students enter at. Levels 1 - 4 are called by a certian program type name and 5 and6 another. We have an Iif statement in the program type box that states that if Level is 1 then the program type is Adult Basic Education, that is listed...

I am VERY new to Access and need help. I recently made a database for our department. I have a form for employees to use to enter new clients. I have a field set that they enter a level number and that fills in another field depending onthe number they enter. When I am looking at the form it...