Search results for query: *

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

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

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

Yes, is that a 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...

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

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

I have looked at multiple examples and postings and I still cannot get my Union Query to work. Below is what I have at the current time. Can someone please take a look at it and tell me what I am missing, or perhaps where I went wrong? When I run the query, I get the following error: "Syntax...

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.

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

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.

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

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

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

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

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

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

I have 2 tables I am trying to joing. tblOpenCases has 32 columns and tblClosedCases 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...

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

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