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 derfloh 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: *

  • Users: houstonbill
  • Order by date
  1. houstonbill

    Union Query Problem

    You got it! now I will see how it goes over the next few days but I think that this will be just the ticket. I have a few more make table queries that I will convert using the same type of set up as you have here. I just knew there had to be a way to accomplish this but couldn't come up with...
  2. houstonbill

    Union Query Problem

    Yes, you are correct. Here is the SQL minus the IIF and Group by: SELECT Count(*) AS [CountOfDesk Cd], Sum(IIf([Resp Cd] Like "*[02468]*",1,0)) AS Facility, Sum(IIf([Resp Cd] Like "*[13579]*",1,0)) AS Profess FROM tblOpenCases WHERE (((tblOpenCases.[Desk Cd])="00")); with the following...
  3. houstonbill

    Union Query Problem

    This is the grouping that I used on my make table format. Other than holidays, it would correctly put my sum totals by the appropriate date. So, on a Monday, it would sum up what was open and set the date as the previous Friday. Tues through Friday, it would again group and sum but enter the...
  4. houstonbill

    Union Query Problem

    Yes, is that a problem?
  5. houstonbill

    Union Query Problem

    Here is what the date table looks like. It is simple and straight forward. DateToday 12/21/2007 12/20/2007 12/19/2007 12/18/2007 12/17/2007 12/14/2007 12/13/2007 12/12/2007 12/11/2007 12/10/2007 How can this be used in place of "IIf(Weekday(Date())=2,Date()-3,Date()-1) AS [Date]" and provide...
  6. houstonbill

    Union Query Problem

    Although the query is working perfectly, I have run across a problem which has come to light as a result of our current holidays and figured I would raise the question now. I am re-designing my database for 2008 and trying to eliminate my Make Table Queries that provide me a history by date of...
  7. houstonbill

    Union Query Problem

    I looked for mis spells forever and could not see it. Sometimes the 2nd set of eyes helps. Also, knowing that column names come from the 1st select statement makes a big difference. I did have to add in the Count of Desk Cd and this was my final result: Date CountOfDesk Cd Facility...
  8. houstonbill

    Union Query Problem

    ...AS [Date], Count(tblOpenCases.[Desk Cd]) AS Profess FROM tblOpenCases WHERE (((tblOpenCases.[Resp Cd]) Like "*1*" Or (tblOpenCases.[Resp Cd]) Like "*3*" Or (tblOpenCases.[Resp Cd]) Like "*5*" Or (tblOpenCases.[Resp Cd]) Like "*7*" Or (tblOpenCases.[Resp Cd]) Like "*9*")) GROUP BY...
  9. houstonbill

    Problem with start-up file on shared drive

    Thanks Duane, that did the trick. I thought there was a way to work around the spaces but just couldn't recall. I am currently on a medical and using this time to clean up my databases for 2008 and I can knock this off my list now.
  10. houstonbill

    Problem with start-up file on shared drive

    Hopefully I am posting on the right forum. For all my applications that are on a shared drive, I set up a "Start" notepad file that sets the desktop icon and puts a copy of the DB on the users "D" hard drive that downloads to the shared drive. Below is the first line of that code. At one time...
  11. houstonbill

    Need advice on how to format query

    Got it! thanks so much for your help. I would have responded sooner but had some OP surgery on 12/21 and I am just now getting back to some of my projects. You have been a big help Ginger. Thanks again.
  12. houstonbill

    Need advice on how to format query

    The Date today has lots of dates, basically it is as you described in your calendar table. tbl_DateToday is a make table query by itself. Each day when the database is opened it populates with the current date, adding to the list of previous dates. This table is used with multiple queries to...
  13. houstonbill

    Need advice on how to format query

    OK, so I tried to reconfigure this and cannot make it work. Here are the two queries & table that need to come together. Should maybe we be usig a Union Query? Just asking. Count Of Fac Pending Fac From Date Count of Pending Prof Prof From Date tbl_DateToday DateToday
  14. houstonbill

    Need advice on how to format query

    Ginger, what I need is how many cases have an OPEN DATE on each day, and how many cases have a CLOSE DATE on each day which I believe you have as output A. Once that # is set for the day, I do not want it to change. A case cannot be on both tables. I already have a union query to bring both...
  15. houstonbill

    Trouble trying to filter records in a subReportQuery

    Got it! Thanks for the advice. I knew there had to be a way but just couldn't get there.
  16. houstonbill

    Need advice on how to format query

    I am looking for advice on the best way to get a result. I have 2 tables that are automatically updated daily as a result of a mainframe download. One is an “tblOpenCases” and the other is “tlbClosedCases”. Obviously these will change daily in that what is open today may or may not be closed...
  17. houstonbill

    Need Little Help with Union Query

    Your first choice worked perfectly, and so simple. Duh, I had not thought of using Null. Thanks so much for your help.
  18. houstonbill

    Need Little Help with Union Query

    ...has 30 columns, which match 30 of the 32 columns in OpenCases. Without having to spell out all the columns, I first tried the below SQL: SELECT * FROM tblClosedCases UNION SELECT * FROM tblOpenCases; With this I get an error indicating the number of columns do not match. I tried differnt...
  19. houstonbill

    Trouble trying to filter records in a subReportQuery

    I accidentally put this on the wrong forum (other) and wanted to place this where it belongs. I am wondering if/how I might filter the records that I need. The SQL below shows a sub-report that aligns the members “ContractNum” and “relcode” with the primary list of members in a report. The...
  20. houstonbill

    Advise on Duane Hookoms "Employee Evaluation"

    As I thought about your questions and looked at my structure again, I kept working on it and I now have it working exactly as I want. I try so hard to figure this stuff out myself so I will understand and learn from it all. Part of what I had to do was add the multi-select query to the query...

Part and Inventory Search

Back
Top