Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BigRed1212

    Include rows for which no data exists

    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...
  2. BigRed1212

    Include rows for which no data exists

    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...
  3. BigRed1212

    Extracting and sorting records by year query

    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.
  4. BigRed1212

    Query bring back multiple values I only want one

    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...
  5. BigRed1212

    Where Like clause assist

    How many records are you talking?
  6. BigRed1212

    Get records by category and list the other categories they belong to

    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...
  7. BigRed1212

    Parse time stamp

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

    Parse time stamp

    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.
  9. BigRed1212

    Parse time stamp

    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...
  10. BigRed1212

    UPDATE query, multiple results

    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...
  11. BigRed1212

    Totals

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

    How to list only material that has 12 months data in any financial year

    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
  13. BigRed1212

    Help on Grouping Query to find all rows that only have the same value

    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...
  14. BigRed1212

    Query that matches subgroups of records

    At least I think it gets there.
  15. BigRed1212

    Query that matches subgroups of records

    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...
  16. BigRed1212

    Dates in Consecutive Quarters

    keep getting error messages." What do they say?
  17. BigRed1212

    List box based on query results

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

    List box based on query results

    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...
  19. BigRed1212

    Dates in Consecutive Quarters

    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...
  20. BigRed1212

    Dates in Consecutive Quarters

    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...

Part and Inventory Search

Back
Top