Search results for query: *

One of the things I like about forums (and this one is no exception) is that surprisingly often, the mere act of articulating your thoughts is enough to create a post allows you to solve your own problem. It occurred to me after I posted the above and went to lunch that if I did: select...

Hey and Hello, Given a table of survey responses from two dummy responders (I have more than two): table:dummy_responses code ques_elem response 001669 1 3 001669 2 3 001669 3 3 001669 4 3 001669 5 3 001669 6 3 001669 7 3 001669 8...

You might also consider expanding Duane's query to extract the rating and then incorporating that into a query intended to normalize your data. One column/field each for title, year, rating, etc. Losing the parens. Would make things easier to work with.

I would try to simplify things down. Kill most of the stuff out of the query you posted- keep just enough to see the problem. If you really want help, explain your data structure other than just "linked tables", provide some example data, show the current results, and show the desired...

How many records are you talking?

I need to list all records that are under a specific category and also list the other categories they belong to." That part is a little confusing and I think a little important. Could you maybe post some data as it is structured and the desired result? This all sounds hierarchical and that...

Fine MajP. Be all smart and everything. The answer is because I didn't know to do that until now.

But I agree with Skip- passing a time as opposed to a string can have value. But maybe you are converting it back to a time later in whatever you are doing.

Given data like: ID mydate 1 3:28:02 PM 2 4:13:56 AM 3 9:02:14 PM A query like: SELECT right("00" & hour(mydate), 2), right("00" & minute(mydate),2), right("00" & second(mydate), 2), right("00" & hour(mydate), 2) & right("00" & minute(mydate),2) & right("00" & second(mydate), 2) as...

I need both results to be inserted into the third field" Not to be cheeky or tell you what you need, but my guess is you really don't _need_ (or even want) to store your data like that. Generally data that looks like "thing, thing2, thing3" is a whole heckofalot harder to work with. My second...

I do what PHV suggested frequently. Query that provides the detail union Query that provides the total

So, for fiscal year April 2010 to March 2011 if (March 2011 - PurchDate) >= 12 then it should be in the report? If so: ... ... where (#3/31/2011# - PurchDate) >= 12

Yes, I agree with Andy. Confusing, not enough info, and the final product is unclear. This is probably useless because the example provided is probably way too simplified. From the example data if you query for all records where auth_status is 'open' you will get {1,3,4}. Then if you query...

At least I think it gets there.

I waited patiently but nobody posted a proper solution, so I will post this complete and utter hack on the theory it will generate some other responses. We have data like: table patterns col_a col_b col_c 1 840 3 1 912 2 1 1010 3 2 840 3 2 912 2 2 1010 2 3 614 5 3 1260 1 4 840 3 4 912 2 4...

keep getting error messages." What do they say?

This looks promising: http://www.fontstuff.com/access/acctut11.htm

See PHV's post about the evil of list boxes above. You really can't do anything at all with them as near as I can tell. I would get rid of the list boxes if you can. There might be a way to query the records with list box selections and use that query to create and populate a proper table. I...

Given this data: ID testdate results 1 1/1/2009 Fail 2 4/1/2009 Fail 3 7/22/2009 Pass 4 12/5/2009 Pass 5 2/3/2010 Pass 6 4/30/2010 Fail 7 8/25/2010 Fail 8 11/3/2010 Fail This query: select sum(streak) as con_fails from ( SELECT iif(a.results=b.results, 1,0) as streak from testresults a...

So if an event occurs in the first two quarters of year one and in the last three quarters of year two, is the answer to your question two (meaning there were two periods in which the event occurred in consecutive quarters) or three (it occurred in quarter one and quarter two in year one...