Search results
-
K
Query in a Query.
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... -
K
Quick Question: Is there a way to sort forms like Reports with sub-groupings?
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... -
K
Table Fields (Name / number) dependent on another Tables data.
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... -
K
Two foreign Keys in One table.
I'm not new to access, and I understand normalization at pretty much all its levels, but right now I'm curious about a situation that I have just come across. The first time I've been in something like this, so I thought I would ask. This is the setup. I have employees. They are apart of a... -
K
Options for Networked situations
I have been having issues dealing with "moving servers" addresses, file relocations, and folder name changes. this makes 'linking' quite difficult. I came up with this option, and am wondering if this would work. 'Delete old table connection DoCmd.DeleteObject acTable, "ExampleTableLink"... -
K
Access2002 Charts: Data Limits, how to break?
The BIG problem is this. I need a basic string graph over time recieved from a cross tab query. The data points all come in fine, but the "strings" / lines connecting the points do not show up. I believe the reason is because there are just too many records. I culled the data down using a... -
K
Access2002 Charts
This is a question in 2 parts: First off, since i'm new, I'll introduce myself. I'm a self taugh Access database designer. Lets just say that the first stuff I started off with was very embarrasing :D But i have alot of programming background. I have been with access a while now and now...