Thanks for the info. I guess what I'm wondering is why you guys recommend against it? I don't mean to be headstrong here, but I don't see the problem with it.
So, mainly, what I'm wondering is, is it impossible/a bad idea to move records from one table to another, or do you just not follow my logic for wanting to do it?
Well, I know that in theory, it doesn't matter how big the table is, but I'd rather that it not, down the road, be littered with lots of computers that are no longer even in the building. We just need to hold onto that information because when our university does its annual inventory, there are...
Ok, I was trying to be breif, but I'll flesh out the situation a little. Basically, there is a third catagory, too, which is storage. In other words, what I was hoping for was to have three tables for our computers (current, surplus, and storage- in which current is what's on the floor...
I am currently using the system you suggested, but if it is doable, it would be much more preferable in the long run to transfer the records to a separate table. I'll look into the make query command.
Ok, I'm working on an inventory database. Right now, there is a table for all of the computers that we have in the building, however, it would be cleaner to have a separate tables computers that have died and were sent to surplus.
My question is how would I transfer a record from one table to...
This seems like this should be so completely easy I'm embarassed to ask, but I'm completely stuck.
I have one column in a table that is alligned to the right instead of the left. It also shows up alligned like that on the form I created for that table.
My instinct is to just select the column...
I'm going in circles with this Access book I'm reading. Basically, I'm designing a form to enter data, and I want most of the entries to have list boxes or combo boxes that give them very specific choices for what users can enter to keep the entries uniform and useful.
The only info I can find...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.