Recent content by rabu5

Pat, thank you. However, when i try to create the relationship you mentioned, i get an error message saying "no unique index found for the referenced field of the primary table". Being as how i am relatively new to Access, i dont understand the message. I referenced name1 to name 2 in the...

Allow me to elaborate a little more... my subdatasheet has date, number and comments. When ever i change record 1's subdata, the subdata for 2-31 all change as well. How do i keep them from changing, everytime i update one of the subdatasheets.

The setup: I have the primany key as name (31 total records), and columns a,b,c and so on. In column c, a memo column, i have a bunch of dates and numbers. The question: I would like to create a subdatasheet unique to each of the 31 different names (not a sheet that is the same for all the...

Thank you very much...that works!

Here is my problem, maybe you all could help. I am running an update query for a list of companies. In my Table they are all in alphabetical order. However, when I run my query, they are sorted in some random order, probably the order which they were entered. I would like to sort the update...

Problem Solved Thank you everyone for your time, but i actually solved the problem!

Sorry, what is an SQL? I am new at this.

Hello everyone, i just read Jaspers post below, but I am still having problems with doing the formulas. When I do an update query for a new field i created (called Field 1), and run it, I just get a bunch of blank spaces (i.e. the formula didnt work). Are there any ideas out there on what I am...