Search results

Thank you very much!

Thank you very much for your useful answers. Sorry if a I lost you with the criteria I´m trying to use ; I don't know the exact translation of "criterios" from my spanish version of MS Access. Finally I grouped a field in a query in this way : "1" or "2" or "3" or "4" , etc . Thanks again!

Hello, I have a field in a table with a restricted number of values from 1 to 10. I consider each number a category and I want to count how many records there are in each one. I can group and count the records in a query but there are only nine criteria to fill in , so the last number...

Thank you very much.

Thank you very much.

Hello , I have an Acces Database and an Excell sheet with different fields about the same people , proceeding of two areas of the same institution. Now I want to join both files in a new database. I import to a new Access Database the Excell sheet succesfully. Now I want to make a query with...

How can I tag this thread solved ?

Thank you very much!

Thank you very much!

Sorry I didn't wrote the ending tag [CODE]. The form is based in a query with a descendig date order field , so it opens the last , modified record.

Hello ,I have a table in a database with quite similar records , and a few changes in each new record. So I need a code that duplicate the last record from a form and open another form to modified this record. I used this two codes each one in a different command button and it works, but not...

Thank you all! Now I need to add this first records . I try an expresion in the query grid : Suma: [Field1]+[Field2]+[Field3]+[Field4] but it doesn't work.

:)Thank you Paul

Hello , I have a table with many numeric fields and I want to make a query that shows the first record of a descending order for each field. For example , Table Id Field1 Field2 Fied3 Field4 1 19 31 54 90 2 45 66 71 28 3 23 37 45...

Thanks for your kinded answer Doc Man. I think it will be usefull for me. i'm not to skilled in SQL so I will work hard on your suggestion. Yes I work with blood pH . There are a lot of professional software programas in this area , but I also like to pick up data bedside in my cel phone and...

Alright , I will try , thaks again!

Thank you , arnelgp. The table has many other fields , with different variables ranks , so I try to make a separate table for each variable and use your suggestion. Thank you very much!

Thank you very much!

Hello , I have this code and it applies on one record when click on a command button in a form. If (Me.pH.Value < 7.15) Then Me.pH_ApII.Value = 4 ElseIf (Me.pH.Value < 7.25) Then Me.pH_ApII.Value = 3 ElseIf (Me.pH.Value < 7.32) Then Me.pH_ApII.Value = 1 ElseIf (Me.pH.Value < 7.49) Then...

Thank you very much!