Search results

  1. S

    creating update queries

    OK, I solved that problem. I do have another question though. Can I use an absolute value function in the update query with a field name as long as the field only has numbers? For example, this is one of the attempts I typed into the update to row: Abs[Oral Communication] Or, if there is a way...
  2. S

    creating update queries

    This should be an easy one for you. I'm tyring to make an update query, however when I click on the arrow next to the query type button it is just an empty box and I cannot select update. I've got another update query in this database, but I can't remember how I made it. Any help would be...
  3. S

    sorting problems

    Thanks for the help and information, everyone. I was able to get the autonumber to do what I needed. So, I finally have the db functioning the way I want it. It may not be the best design in the world, but I'm a psychologist by training and had to learn Access while doing this project. What I...
  4. S

    sorting problems

    Is there any way to completely remove sorting so that data is stored in the order in which it was entered on a form? I had to use to two forms (with the first containing a subform) because the information was too long for one. The important piece of information is the name of a course, and when...
  5. S

    rounding errors

    I'm pretty new at Acesss so this should hopefully be an easy question. I've written and update query and am having problems with basic division. When I go back to the table it rounds the answer to the nearest whole number, but I need to get the actual decimal places. I've tried looking in help...
Back
Top Bottom