Search results for query: *

I am hoping someone might have a solution or idea that might help me save alot of time. I have 2 databases that we combine data from and one is in the eastern time zone while the other is in Phoenix. The proble is that Phoenix does not change time twice a year like the rest of us. Currently I...

Hi, I have read many of the threads relating to this error, and have tried some of the things in those threads with no sucess. Here is the situation: I have a table called ForecastedSvcLvl1 I have a query called FCST_SL_QUERY_2 I am trying to update 2 fields in the table for various days...

I am receiving new data that I would like to use in my Access dB. The problem is that I can seem to get Access to understand that my first field in my unix flat file is a date. The reason for this is that the date in the unix flat file looks like this: 07072008 Is there any way to make Access...

I know in Oracle SQL you can do NOT EXISTS..like this in the WHERE clause.. AND NOT EXISTS (SELECT 'x' FROM AX WHERE AX.EMPLOYEE_ID = D.AGENTLOGIN AND D.TIMESTAMP BETWEEN AEX.BLAH AND AEX.BLAH1 AND AEX.ROLL_ID = O.ROLL_ID) Is...

I have an expression that I use to get a value based on a set of threshholds set in a table. These values are as follows: ADH_TEAM_RATING_MIN ADH_TEAM_RATING_MAX ADH_TEAM_SCORE 0.001 0.8999 1 0.9 0.9299...

Has anyone ever tried to to and ERD in Visio against a Simba Client ODBC connection? The Simba client and ODBC driver is installed on the system however it is not part of the Visio drivers. Is there a way to add more insttalled drivers to Visio so that I can connect to this Simba database? I am...

Hi Folks, I use this to get a week number for a date range: WeekNo: DatePart("ww",[Timestamp]) Is there a way that I could also get just the first date from that week number to appear in the query as well? ie. if Week 1 is 3/1/07-3/7/07 the query would show 3/1/07 as well as week 1. TIA

Hi, I am trying to create a historical record of Employees at our business. What I would like to do is have a query that will create a begin date and create that date for each day starting w/ like 1/1/06 and continue thru Date()-1. For example: Jane Doe and John Doe started employment on...

Anyone know a good site w/ help creating charts in Access 2k? I have a few queries id like to display as charts on a for or report but just playing w/ the chart feature is getting more confusing by the minute. Any tutorial would be great. TIA!

Skills="SELECT IntervalAHTByGroupCombined.Group, IntervalAHTByGroupCombined.Skillset, IntervalAHTByGroupCombined.TtlTalk, IntervalAHTByGroupCombined.TtlPCP, IntervalAHTByGroupCombined.TtlAns, IntervalAHTByGroupCombined.AHT FROM IntervalAHTByGroupCombined WHERE...

Hey folks, What I have is a query that results in some general employee information including: EmpID EmployeeName TotalHrsLogged What im trying to do is report the EmpID, EmployeeName where its the MIN or MAX(TotalHrsLogged). I tried this: HighestOcc: Max([TotalHrsLogged]) & " - " & [EmpID]...

I have a scheduling unit that associates a number to a particular name. In this example Break=66 and Lunch=76. What I would like to do is setup something that will tell me "which break". Like "Break 1" and "Break 2" Here is what I have to work with: Emp# ID# Code StartMin...

I am trying to convert a whole number to a start time w/ no luck. Assuming "0" is 12:00 AM, I have a start minute of "480" which would in essence be 8:00 AM. Can anyone tell me if I can somehow convert this to time in my query? Thanks.

I have 2 Data Access Pages that are almost the same. They both pull data from my dB. The issue is that when I open one of the pages it works fine the dropdown list has all the things in it that it should, but when I open the other DAP the dropdown list is blank. What could cause this to happen...

I have a report that has 2 subreports in it. In order for the subreports to run you have to enter a date range that come from the query. Is there a way that I can set an [Event Procedure] so that it sets the date range the same for both subreports? Something like this..this doesnt work but...

I use Access to open a workbook from a Simple Form. What I want to know is can I add code or a macro of some kind that will select Range("A:A") and Delete that column after the workbook is opened w/ the Command Button in Access. This is kinda an extension of a problem I had earlier... Here is...

I am trying to open a workbook with a command button however the path to the file is giving me a fit. The path for the file location contains spaces and I am going blind trying to figure out how to rectify the path. Heres the line. I am sure someone here will see this problem quick! Thanks...

I have a data access page that many users have access to.When opened the Dropdown is blank on some peoples and populated on others. Is there some setting that can cause this. I have checked to make sure that they have the allow ActiveX Controls to run files on this computer checked. Any other...