Search results

  1. A

    Returning a list of records in the parent that don't contain certain child data

    Thanks very much for the reply, but that wouldn't fit with my data.
  2. A

    Returning a list of records in the parent that don't contain certain child data

    Anyone? If my question is too basic, I would welcome a shove in the direction of info I can read and research myself to answer my own question.
  3. A

    Returning a list of records in the parent that don't contain certain child data

    I have a simple contact management data maintaining records of activities by salespeople with individual accounts. The child table activities being tracked for each account may be performed by one of several different staff members. I have (with the help of this board) mastered creating...
  4. A

    Splitting a table into two one-to-one

    Oh yes, definitely.
  5. A

    Splitting a table into two one-to-one

    Thanks everyone for the advice and support. I have decided to go with the suggestion of copying the whole table as an archive version. I have a question though - I was hoping to keep the archived data in the same DB, but I don't want to add 30% to the size of my DB - would it be OK to trim...
  6. A

    Variable Criteria

    There's a very common element in queries called a parameter. Create a query and add the fields you want to show in the result. In the field column for whatever data is going to be variable, go to the "criteria" line and add the parameter string. It looks like this: Like [What hair colour do...
  7. A

    Splitting a table into two one-to-one

    Mike: Thanks, but I worked very hard to get this job for the 95% that isn't data management - I'm not giving it up over something that takes up 2 hours a week of my time. I have learned to just shut my mouth and run to the internet whenever they ask for something. And speaking of... why would...
  8. A

    Splitting a table into two one-to-one

    In for a penny, in for a pound. I spend 95% of my time doing other things besides database work - the main job I was hired for has nothing to do with data management. Both my bosses are former DB developers who know way more than I do but are too busy doing other things to do the work...
  9. A

    Splitting a table into two one-to-one

    Thank you for all the useful advice. To clarify - I think people are misunderstanding my users' preference for editing in the table - it is a parent table with a child table, and the child table is accessible through the + sign, which they use to see and edit all the child records. Hence, a...
  10. A

    Splitting a table into two one-to-one

    It's kind of frustrating to have everyone saying why why why. I don't have a choice about this, it is going to happen. A query returning relevant fields in the datasheet view won't work because they use the parent table to edit the child table. I don't know if more recent versions of Access...
  11. A

    Splitting a table into two one-to-one

    Hi Namliam: Thanks for the reply. It's not my choice. The people who use the DB, who use the tables exclusively and don't like forms for data entry, want these fields, which are no longer used but they want stored for archive purposes, gone. Thanks for the info, but I don't understand what...
  12. A

    Splitting a table into two one-to-one

    I want to remove 5 fields from my parent table in a contact management DB to a separate 1-1 table, and I'm trying to find information on the best way to do so. My main question is how to structure the relationship - does the primary key (autonumber) in my "main" parent table become the foreign...
  13. A

    Getting a query result by comp'ing a date in a child table to a # in the parent

    Thanks PBaldy, the expression you suggested worked perfectly, I'm so excited!!
  14. A

    Update a Record From a Record in Another Table

    Do you have the field properties set to accommodate the incoming data? Compatible field sizes etc?
  15. A

    Getting a query result by comp'ing a date in a child table to a # in the parent

    I am running Access2000 for a simple parent-child DB tracking stores in the parent and contacts with salespeople in the child. I want to use a field in the parent table to store the maximum time that should pass between contacts, then use that number in a calculation with the most recent...
  16. A

    Finding Most recent records using query(please help!)

    Anyone with any suggestions for me??
  17. A

    Force empty columns in a crosstab query

    Have you tried removing the filter?
  18. A

    Finding Most recent records using query(please help!)

    I came today to ask a very similar question, so I'll post it first here in this thread. I am running Access2000 for a simple contact management DB with clients in the parent table and individual sales calls in the child. I created a grouped multi-table query that showed the most recent...
  19. A

    Splitting one field into two based on contents.

    Thanks for the quick reply Thank you! This won't be screwed up if there happens to be another 'km' elsewhere in the field, will it?
  20. A

    Splitting one field into two based on contents.

    I am running Office2000. I am copying data from the YellowPages site and pasting it into a memo field. The data shows up like this: 0.4 km General Nutrition Centre - 905-731-8623 1 promenade Circle , Thornhill , ON L4J 4P8 Category : Health Foods-Retail Map & Directions...
Back
Top Bottom