Search results

Table structures Table: Classes ClassID (PK) ClassNumber (text) Defunct (Yes/No) Table: ClassVersions ClassID (Many to One to table Classes) VersionID (PK) Name Hours Classified CourseType HoursApplied Knowledge ValidTimeLength Version (This is the field that...

I hope I can get some help on this. This is by far my weakest area in creating databases. Queries: I need a query that allows me to find the highest number in a field for each set in that table. IE: I have a master table of classes, and a linked table (one to many) of revisions / versions...

I have one table holding lots of different data. That data is all the same, but when it comes to output, it needs to be separated by groupings (which I have defined within the table itself as group 1, group 2, etc) I was wondering. i would like to do the same thing with forms so that input...

Do exactly what it says. Open the backup database, delete all the tables in there (or maybe play it safe and rename them all as back up). Then import ALL the tables from the now corrupted database. If you have made any changes to forms / reports they will be lost. Hopefully your backup...

I think he was asking how to make a relationship in the first place. On the main database window (make sure its highlighted and no forms, tables, queries, reports, etc are open), go to tools and click on relationships. There is also a tool bar icon, but sometimes hard to find. In the window...

@Doc_Man:: As for my defeciency, I believe it is more my description abilities, not the way I am thinking of the problem. I honestly understand what both of you are saying, I guess I have difficulty in explaining though. I was really forced to use and learn Access on my own, and I know that I...

Thanks much for the responses. My wife's grandmother died about a week ago, and I had to take off some time to be with her and head out of country. So I haven't been here for about a week or so. Apologies for taking so long to get back. @Pat Hartman:: Your idea was essentially identical to...

I'm not really stuck... i haven't even used this idea yet, to be honest. I'm just trying to find out if it is the best way. The idea I came up with is basically identical to what you and phil both spoke of. And i know that this is just about the only solution there is. But I dont' know if...

?? um.... Did I offend you in some way? :confused: That response didn't really help. :eek: anyway, maybe someone else can help. Kelemit

I agree Phil... that is the answer I came up with as well.... If you read my "Option 1," you will notice that is exactly what I spelled out. But as you can see from my first post, that is not the question I am asking. I am asking if there is a better way. I know what you are both saying by...

Anyone have any ideas? I'll try to explain again a little more. Hope it helps. Basically, Standards for accomplishing a Quality Check can change, and are stored in a separate database / table. Those standards define what needs to be checked while doing a quality check. Those standards have...

Thank you for your reply. And I appreciate the help, but I do know that. I do NOT want to add fields to a table, that is the essence of the entire problem. That is the point I am attempting to make. I have a situation where the items in database1 will inform what database2 will be. IE...

I have an ... interesting issue. I am wondering if others have dealt with this. I have a solution, but am not the happiest with it. I basically have 2 databases here. (Or I will when I'm done making them) and one is dependent upon the other. In fact, the 2nd's tables are dependent upon the...

You will actually get more bang for you buck if you actually safe up money instead, save up the 200 per month over 5 months, and after getting the $1k, you will end up 5 months in the future, able to buy a better CPU, MOBO, and maybe a slight bump to your hard drive. My 2 cents.

DateDue Field Control source set to: =[fieldDateRemoved] + 15 Kelemit

Depending on how "into" it you wanna get. I would highly recommend DAoC (Dark Age of Camelot). I've tried several different MMO's and to be honest, DAoC is one of the best I've ever come across. Like was stated earlier, the PVE isn't stunningly amazing, but there is ALOT of it out there and...

Are you trying to do a one time thing? Or a system for easy imports many times during the life of your database for the user type thing? Kelemit

{code} SELECT test.Company, Count(test.Number) AS CountOfNumber FROM test WHERE (((test.Number)=7)) GROUP BY test.Company; {/code} This will return the number of "7s" for each company. To get the 6's, change the WHERE portion to =6. This is of course 2 queries, but it does get you what you...

Banana, purists would argue that the static lists should have primary keys and that the data stored in your main table should be the primary key, and not the name of the country / state. IE: (US Address example) Main table: Name, Address, State, Zip Cheese, 1234 Somewhere, 14, 05034 As you...

Interesting. Have never done that before. Basically can just HIDE those 2 boxes as well, no need for a user to even see them. Only one problem. That only works if a user doesn't accidently input the wrong date for a shift / budget. If the shift or budget date is inputed wrong, then the...