Search results

Actually, I'm attempting to basically group by the first field but create a difference on the third field. The issue is that I need to ensure that the difference is sorted as being the "greater" semester value subtracting the "lesser" Theoretically, my third field, the one I called [value] is...

the 20041 is the numeric date field ((year*10)+semester) The pk for the first record would be 1 and 20041

Agregation between different values of a multiple key Okay, so today's fuzzy headed mystery applies to a three field wonder involving a key (combined with date to be pk), a numeric (semester) date, and a value. Table 1 ---------- 1 20041 3 1 20042 3 3 20042 4 4 20041 2 5 20041 4 ----------...

John - Thank you so much, I appreciate your patience. I thought I was so close when I was sniffing up the [MinOfTrimester] GROUP BY [Field 1] trail, but this seems considerably less expensive. Thank you again. Regards, ~Chad

Hmm.. I think I had figured out that much already. I guess what I need help with is what exactly to tell the query to look for. I know it needs to compare the trimester values of each [field 1] against the other values for the same [field 1] but the logic inside my head isn't making sense for...

Unfortunately this would not work as it only catches actions within 2004. The items in field 1 are non-unique as I had said before. An example dynaset: Field 1----|----Trimester 124 _________ 2003-3 125 _________ 2004-1 125 _________ 2003-3 126 _________ 2004-2 126 _________ 2002-4 127...

Hiya folks. So here's today's ponderance: I have several queries chained together to produce a working dynaset of data with two fields--one is a non-unique item number, and the other is the trimester (a numeric field set up like 20041, 20042, etc) the item had action within. Because an item...

Sub-Query Madness - Addendum Help! So, here is my problem--any help to point in the right direction would be appreciated... I have a query taking a multitude of records from a table that SHOULD have a unique identifier in the OSS key (which is a three-field primary key). However, due to bad...

Does anyone know of a way to make an option group accept a letter keystroke for quicker data entry purposes? Specifically, my option group only has two choices -- I would like the respective labels for the radios to look like: (R)adio One (N)ot Radio One To which then a respective "R" or "N"...

Thank you very much Pat! As I've worked on it and thought on it for the last 24 hours I've actually decided that I would do myself a favor if I simply re-worked this from the ground up. It will basically give me a chance to go through and clean up those items I had originally thought were 'good...

I actually have the bones model of the system completely up and running--it's taken a good 2 months or so to teach myself access as I've done it, but all seems well. That's actually why I'm so feign to just destroy it for standardization purposes. The place I'm at now is actually the last step...

Hey hey-- So, in my 'yout I made some silly choices with the object names of my database -- spaces and the lack of a standardized notation such as 'frm' before the various queries, reports, tables, forms, etc. Of course, as I've read more and more I've understood that such good standards exist...

:D Thanks for the assistance there, Tim... I'll take those suggestions... Oh, and the additionals on the list were both noted and appreciated... ;) Sincerely, ~Chad

Thanks for the replies but... First off, thank you for the replies... I've looked into the aforementioned developer's book and I'm thinking about a purchase, but before I grab ahold of a book like that, I do think I need something to understand the basics of vba coding. I have the Access 2002...

Does anyone, perchance, have a good recommendation for a moderately paced beginners reference / tutorial for vba programming for Access? Online, or in paper--either is okay. I would like to be able to learn some vba for a few databases I'm working on to make them slightly more 'bulletproof' and...

First off, thank you very much Ken. I had considered such an option already, but didn't know if it was actually feasible. So maybe a better question would be related to the process necessary to create the correct income id number I am relatively confused about. Thanks again, ~Chad

So I've read a good 100 postings or so so far on the subject of how generating a unique identifier through any other means than an autonumber can be dangerous. But I can't resist the opportunity to simply ask if there is a way to make this possible, if only through a calculated field... In my...

Alrighty I have spent the last two days picking my brain and searching the posts for this one and I'm just downright stumped so I thought I'd turn to some folks who actually KNOW a thing or two about access. ;) So, I have an accounting database. In this database there is a table where the...

Yup... that works... But not to the full extent that I want... I would like to expand upon the statment to include a 'Like "*"' part of the statement to display ALL records in the case of a null entry and data validation for only existing dates would be nice too, but this ALL part of the...

Currently yes... but right now there is no form for this query nor is there any need or desire for one??? <blah blah SELECT and FROM statement> WHERE Year([TaxLogs].[Date])=[Please Enter Tax Year] ... so confused... ~Chad