Search results for query: *

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

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

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

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

I am working with Duanes wonderful Employee Evaluation I downloaded from his library (http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Employee%20Evaluation') and it is exactly what I am looking for and have begun work on. What I am looking for is a bit of advice as I will need...

Have a couple of modules that run when my DB opened. Tables primarily link to another source DB that receives downloads of data daily. My DB has some "Make Table" queries designed to run on the AutoExec macro. There is a lookup table as shown below. UserName LastUpdate Running e122685...

I know that there is probably a simple explanation and I am doing something very stupid, but I can't see it. My IIF statement reads as indicated in the SQL below and it will not change the only entry possible in the Elect field (TWO) to YES. What am I doing wrong. SELECT [ElectronicWS CSR Rpt...

Looking for help on the best way to accomplish combining multiple queries with the same type of data that will be give me single lists of that data. Basd on how the data is dumped to the table (by the CCN #), I have had to break up the data in queries. Below is an example of the SQL of the 1st...

I am stuck on how to fix code. Have a linked database that has 4 append queries that must run once daily, one of which is a Date query. The primary tables used are linked to another database that when opened 1st time each day, the data from our mainframe loads the previous business days data...

I have spent that last 2 hours looking at posts and other Access/VBA sources to try and figure out how to format the body of my email generated by a button in HTML format. I was looking at thread 705-1150127 which made the most sense of everything I looked at but I was still confused by where...

I am struggling with a query and looking for a bit of help. Below is the SQL of my 1st query. What I am trying to do is create a 2nd query that will tell me how many cases were closed by [CSR Name] in 7 days. Date1 and status1 (I059)Should be when case comes into the department. Date2 and...

I did find thread 703-1359243 answered by Dhookom on 4/21/07 that had the same problem that I am having, but my query makeup is different and I can't see why this is happening. My field is set up as memo on the table, and my query that builds the report is based only on that table. I see...

I have been struggling for 2 days over something that should be so easy. I have a report based on a query as follows: SELECT QryOnSite.FirstName, QryOnSite.LastName, Sum(QryOnSite.CountOfOnSite) AS SumOfCountOfOnSite, QryOnSite.[Employee ID], Sum(QryOnSite.[Visit Duration]) AS [SumOfVisit...

I am hoping someone can assist. I have taken over a database from an employee no longer with us. The database is nn use and I need to create the reports to go with it. Problem is, that when I try to set specific criteria on the query field whose corresponding table has set the field as a...

I have a question which may seem a bit dumb but again I am trying something I have not done before. Have a form with a button that opens a query with several jundred records in data sheet view. Each has a OrderID # assigned to it. I want to be able to double click on a specific order number...

Have a query that makes up a report. I am forcing myself to try and use IIF expressions so I can learn them. 2hours into it and after looking at multiple examples, I am looking for a bit of assistance and any help in formatting would be appreciated. I am trying to display the value of all my...

The below SQL is the qry that makes up a form. SELECT Date()-[SubDate] AS Age, tbl_Suggestions.SuggestionID, tbl_Suggestions.BadgeId, tbl_Suggestions.Idea, tbl_Suggestions.SuggestedAction, tblEval.AckDate, tblEval.DecisionSent, tblEval.ClosedDate, tblEval.Decision, tblEval.ImpleDate FROM...

Have my form set to open so the ID # is in descending order with the last completed order ID record appearing. Hopefully this is not too dumb of a question but I would like to have the user open up a blank form while keeping all the other records available should they need to search through them.

Have checked multiple postings but cannot seem to get the result I need. Looking for some help with my expressions for conditional formatting. Have a bound text box (AvgASA) with a result for each of 12 months {ToDate]. Based on the date range, the target value for the AvgASA will change. I...