Search results

This Query on the table below SELECT ID, Value, As_of FROM Table a inner join (SELECT ID, MAX(As_of) AS As_of FROM Table GROUP BY ID) b ON a.ID=b.ID AND a.As_of = b.As_of Table: ID Value As_of 1173 156 20090601 1173 173 20081201 1173 307 20080901 1173 305 20080601...

Ok.. That part i guessed but as I mentioned the table I mentioned is part of a larger query... I think you helped my before I'm doing the jail db... And this query is getting personal info from one table then a related table inmate info from another and security info from a related table to the...

How do I syntax that from the query builder in the criteria? And under what field the info field or datechange? Sorry for nooby questions..

Hi ya'll I got a query (from different tables) where I use the "last" option on a field (info) to get the last record in that table.. I guess it's based on the Autokey or just the last record in the table.. And that works great in my query mostly... It's just that it's not always the last...

***Update I think i have solved it...not sure how well though...please look at the onCurrent event of the form frmMaster2 to see how i solved the above problem i described.. attached is a new version of my DB

*update I think i have found a solution to my textbox displaying a field of the last records..i found this DlookUp("Name", "Employess", "IDEmployee=" & Dmax("IDEmployee", "Employess", "") ) So im now trying to use DlookUp with the Dmax to see a specific field of the last record in my class...

Thanks :D Well i think i mentioned before I wanted to display the last record of the Security Class and Squad names in the main record, right now its just a textbox with a function pointing to the subform fields...if i click in another record in the subform it changes to that value ...so not...

Update: Ive uploaded a DB with a few of the subforms working ...although im having a bit of a UI problem Ive added text boxes on the main form that show information from the subForms...very simple... I would somehow want to show the latest records information from some subform on the main form...

Yes that is correct, just like in real life you can be committed again after you have been released. And each time an inmate is "in jail" they have different histories, movements and so on.. So the the multiple inmate function i have added will also help with the booking as most personal...

Hi guys, Ive been on the VBA thread, DB structure thread and gotten invaluable help...now that im closer to actually restarting my development i need some guidance in how to best use Access forms and what they can do. I come from a Flash developer background and i could basically do as i...

ok...ive tried to move around decompile and reconstruct all Entities and attribute. Please have a look at the attached screengrab of my relations and let me know if you see any direct No-No's ive done Thanks for pushing me towards making a more flexible and better DB structure

ok...I've exported all fields and tried to organize/de-compile them according to the normalization rules i read... I'm having a bit of trouble with an inmates "temporary" status designations. you see they can become an ICA (Inmate Custodial Aide) or a P1 (similar to ICA) or a Jailward he can...

Thanks im reading through the document now...very intresting. Ill have to take out all my fields and determine the type...entity or attribute hehe that will be interesting ill get back and post an update when (if) I get through it hahah :banghead:

Hahaha well there goes my whole db out the window, I have no problem admitting when someone shows me something that looks so much better. My whole approach is based on an existing excel file they called master file with all the inmates just thrown in there. From that I started to try and makes...

ok I understand the making a new record for each new movement might be beneficial for a "History", but in my case or as i understand it the way i set it up it works quite well for keeping an eye on amount of inmates per Status, Class, Squad etc. And the way its set up now i would have to make...

Hmm... Not sure I really understand you, all placement fields are lookups, class, squad, status and so on. What I Don't understand is you say add a new record when inmates is reclassified and moves? You mean add a copy of the old record with just a new class? I think I must be misunderstanding...

Hi, I've built a db for a jail institution and im a little stuck in one area. Ill just give you a short intro first to the structure... db consists of inmate records, name, prision number, security class and squad name (plus a lot more not relevant for this flow) Example: inmateName: John...

update....it was a lot easier then i thought, although it could probably be done better.. one query for each subform.. for example this... SELECT DISTINCTROW tblInmateProfile.[tbl-squad_ID], Count(*) AS [Count Of tblInmateProfile] FROM tblInmateProfile WHERE...

Hi Ya'll Quick query question, i need to count each group (Squad) total, I have tree tables: tblInmates: inmateID, inmateNames, inmateSquad, inmateClass there are about 7000 inmateNames tblClass: classID, className there are 4 classNames tblSquads: squadID, classID, squadName there are...

That's on thing I haven't been sure about... Having duplicate squads. So whenever counting or checking for the "P" squad I'll just count both MinA and MinB together. Thanks for clearing that up :-D Any idea on the VBA structure for counting the squads and populating a listbox? Or if you...