Search results

Thanks...but anything to do with SQL is beyond me...I studied political theory sigh. I think this is going to have to be referred to someone else.

I have (sort of) built a database and I think worked out the normalization issues. Its for a county council and is designed to keep track of the contracts they have going for projects. Two departments work on the database, the department that keeps up with the contractor (who they are, what...

Thank you, to you both. Fortunately its a temporary job. I have tried it both with three tables and a series of little tables (that got out of hand fast with trying to define the relationships). I think part of my problem was that I was expecting the relationship to serve as a validation, so...

Thank you both! David-yes...and I will need to be able to see the history of all of the payments. Simon, If I'm understanding your suggestion correctly, it sounds as if you are saying I should set up lots of tables with only one or two pieces of information and then have the forms set up for...

I'm not a programmer and know very little about setting up access databases other than the very basics...however...due to my politics background, I'm setting them up for the local government....just my little disclaimer about why I'm asking stupid questions. I am creating a database for...

When I link, all I get is an import of the old records on a new batch table by themselves...without the new ones. When entering new records they go onto the original batch table so that new records and records existing on the new access file don't ever co-exist with the old records fromt the...

what I have ended up doing is importing the old into the new...but this results in seperate batch tables. I have also tried creating an append query but haven't gotten it to work.

I think that the older version is Access 2000 and the newer 2003- both versions are saved as access 2000 versions but the older may have been created from an access 98 file somewhere along the way.

I have two seperate files with the same type of data. Each file is sorted into multiple batches. The first file is a current data base still being used that was created in an older version of access. The new database has some records, but is in a newer version of access. I need to know how to...