Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by d22

  1. d22

    Query different data from the same field, and group by common field

    That worked. Thank you all.
  2. d22

    Query different data from the same field, and group by common field

    That did work on the non-calculating field. Do you know how I could have event 1 - 11 all group up in the same field? Meaning if the event number = 1 - 11, then put the heat_lane value in the first available column. Thanks.
  3. d22

    Query different data from the same field, and group by common field

    I don't think a crosstab will work, because it is a non-calculating field. The example 1/4 is the heat number/lane number. Thanks.
  4. d22

    Query different data from the same field, and group by common field

    I have a swim team table I am building. I have 3 fields, swimmer_name, Event# and Heat_Lane. I would like to have a separate column for each unique Event# and Heat_lane( the 2 are associated to each other. I can get the data to return, but I would like to group by the swimmer name. Here is...
  5. d22

    Upgrading Peachtree 2000 to a more recent version

    Bill, We are running Peachtree 2000 Powerful Accounting for the Next Century (5.0 Release). Do you know if I can upgrade to Peachtree 2008 and retain all of our data? Thanks.
  6. d22

    Upgrading Peachtree 2000 to a more recent version

    I just started work for a small company which has Peachtree 2000. They would like to update to a newer version of Peachtree Accounting, but I am not sure which version I can upgrade to from 2000 without losing any data. Does anyone know if there is a site with a matrix which will tell me what...
  7. d22

    Join 3 tables with 2 right joins

    [2thumbsup]That worked great. Thank you. D.
  8. d22

    Join 3 tables with 2 right joins

    I wrote a database for a Little League to track registrations. I am working to combine 3 tables to make one so I can populate a MS Word form. The tables are Player, Parent_1 and Parent_2. The Player_ID is the PK in the Player table and the FK in the other 2. The problem I have is my query...
  9. d22

    Find and update existing records

    Roy - Thank you, it worked like a charm. So easy yet so hard.
  10. d22

    Find and update existing records

    I have created a Player DB for a Little League. I have figured out how to add a player if he or she is not on the list. The problem I have is I am using dlookup and I have no problem looking up the player and all their information, except it adds it to a new record or Player_ID. Basically I...
  11. d22

    Date range to determine another field value

    Paul - I was trying to update a field, but have re-thought the process. Your idea is killer and worked well. Thank you for all of your assistance and time. I have to go play Thanksgivings now, but I am sure I will post again as I continue to create the database. I was looking for a demo of a...
  12. d22

    Date range to determine another field value

    Paul - Good catch, that extra iff was a typo on my part. I ran the query and it worked, but it didn't update the record. I have a Division query with the query you sent me and a test box with the control source of Division. How do I get it to update after I input the DOB? I know how to do...
  13. d22

    Date range to determine another field value

    You are correct the expression will have to be changed yearly. The way it works is if Mary Smith was born on 8/2/89, then you would be in the Pony Division for the entire year next year, as per Pony rules. Pony for next year spans from 8/1/89 - 7/31/91. A twist in the whole thing is that the...
  14. d22

    Date range to determine another field value

    Paul, The date range is defined by Pony at the beginning of the year. The range on my last post is for next year (2004). I don't plan to re-register players on the DB each year, so I would need a method that could change dynamically each season. Your assumption is correct, that once Mary is...
  15. d22

    Date range to determine another field value

    Paul, I created the test record with the control set of Division. I created a query with the following information Division:IIf(DOB > #8/1/89# And DOB < #7/31/91#,&quot;Pony&quot;,IIf(DOB < #7/31/93#,&quot;Bronco&quot;,IIf(DOB < #7/31/95#,&quot; Mustang &quot;,IIf(DOB < #7/31/97#, IIf(DOB <...
See more

Part and Inventory Search

Back
Top