Recent content by d22

That worked. Thank you all.

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.

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.

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...

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.

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...

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

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...

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

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...

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...

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...

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...

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...

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 <...