Search results for query: *

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

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

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

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

I am creating a Access DB for a Little League registration and would to put a value in a field determined by the applicants DOB. I want to write a query to put the value Pony in the league field if the date is between 12/1/96 and 12/31/00 for example. I will need to for 6 different divisions...