Recent content by IATAILG8ER

Hi, I am trying to set up a database for organizing Track and Field meets. I'm a newbie to a lot of the Access capabilities. I've attached a PDF of what I'm looking at doing for my Access tables. Some of the tables I think I have right. I don't know how to organize the meets, events, days...

Thanks Thanks, that worked great. I didn't fully understand where I was suppose to put the formula. I am kind of green when it comes to access and was trying to build it in the criteria box for that field. It works fine now. I have just one other question. Let's say some of my records don't...

I still am having problems I tried that and it still didn't work for me. Here is what I am trying to do. I've attached my database as an example. I have two tables one called "add1" that contains the addresses and another one called "zone" that contains the zones for the addresses. My query...

I am new to access and have I question that I think should be easy to answer. I am importing a mailing list from text to access. The list contains these fields Name, Address, City, State, Zip. What I would like to do is create a field in that table based on the zip code field. The new field...

Thanks 79ssecca for your help, I just now was able to try your suggestion, but am still having a problem. I created two tables one a name table and one a address table. The address table has a one to many relationship with the name table. How did you assign the AddID field to the tables...

Hi, I'm new to Access and have a problem I was hoping that someone could help me out with. I am working with a mailing list that has a Name field, Address Field, City Field, State Field and a Zip Code Field. What I would like to do is combine records that have the same address and zip. Example...