Hahaha, looks good!
I think we are on the way. PHV, all those things they said about you were totally false.
Seriously, my thanks for the help and I will try to learn from this for next time.
God I love this site...
Strange,
The subquery:
SELECT caseLink, Max(caseRequestResubmit) AS caseRequestDate FROM caseRequestTable GROUP BY caseLink
returns one record for each case as is desired, but the overall query gives all the requests, not the Max...
Sorry, my mistake, the caseRequestDate is actually called caseRequestResubmit. I amended the field date in the first request in a foolish attempt to make the questions simpler.
Wow, speedy response.
This is the basic query which shows all the duplicate cases with each request. I tried using top, but that just gives me the most recent case only, not each case record showing the most recent request:
SELECT DISTINCTROW caseRequestTable.caseRequestResubmit...
To the brainstrust,
I have seen some similar questions as this, however due to being a bear of little brain, have had trouble adapting those solutions to my tables.
Basically, I have 2 tables with fields shown below:
caseTable
- caseID
- caseLodged
- caseAllocated etc
caseRequestTable
-...
Did something sensible and whacked in Xp disc and did a repair job. Replaced the registry files with originals from repair folder and golly-whiskers, she is up and running!
Bad news is I have to reinstall vital programs, but at least the machine is working (faster too!) and I get to clear out...
34 degrees Celsius in my house last night, so I thought it prudent to test the machine when I wasn't sweating onto the motherboard.
I couldn't hear much from the drive before, but when I test it as above with the machine open, I will check.
I might also make myself a garland of icecubes and...
Hey teksters,
Last night my computer crashed (reset itself) while opening Firefox and since then will almost get to the point where it should display the windows logo and progress bar. I think that it actually shows it for a nanosecond before the screen goes blank with no further drive...
Dear genii,
I have a subform which allows users to create records against a given "client record" from a list in a table. In other words the main client form has a subform which shows a datasheet of "flags" which can be attributed to the client. Therefore one client can have many flags. I want...
Hey guys,
I am trying to design a query based on the following tables:
Table: Person Table: Travel
-------------- --------------
personID ---------| tripID
givenName | tripdate
familyname key port
address | flight
dob...
Hi, I'm wondering if someone can help with my problem. I have recently set up security for my Access database by creating the work group, setting up a work group administrator, setting user permissions etc. This was all done on C:\ drive to avoid crashing my work's G:\drive where the database...
I am starting to wrap my head around access crosstab queries (with limited sucess) and am trying to generate a query that has date ranges as the columns.
I have seen the examples that show the columns shown as quarters eg Q1, Q2, etc.
If I want to have something like "< 1 year", "1-2 years...
i should also mention that each userID might be associated with different combinations of source and dest:
eg
A.userID | B.source | B.dest | B.level | B.type
-------------------------------------------------
1 UK US 2 mail
1 UK US 1...
Hey guys and gals,
I have been trundling along for a few years, getting around the need to create complex queries by relying on php to provide the logic, but now I can't find a simple solution and wish I had been more creative with mySQL in the past.
I need to request data in a 2 table join...
Dear Chaps and Chapettes,
In the process of assisting my brother to assemble his computer before he moves interstate, I swapped a cdrom into his box for ease of installation of stuff.
After returning the drive to my machine, I found that my machine would not boot, in fact it seemed no power...
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.