Search results for query: *

Thanks everyone I will give the table route a shot.

Thanks much this helps with getting the data I need from the previous day...now if I can just getthe query to know whether we are in daylight savings or standard I am all set.

In the criteria section under where you have the recID put CSTR(Assignments.AssignID) in there..that is how you join unlike field types. You dont need a physical line from table to table in design view. Hope that helps.

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

Thanks I will try that.

This is the originating query SELECT FCST_SL_QUERY_1.ctID, FCST_SL_QUERY_1.FORECASTDATE, FCST_SL_QUERY_1.ctName, Sum(FCST_SL_QUERY_1.fcstContactsReceived) AS f1, Sum(FCST_SL_QUERY_1.WTD_CT_NO) AS f2, Round([f2]/[f1],2)/100 AS FCST_SL FROM FCST_SL_QUERY_1 GROUP BY FCST_SL_QUERY_1.ctID...

This is the SQL for the qry: SELECT FCST_SL_QUERY_2.FORECASTDATE, FCST_SL_QUERY_2.CTNAME, FCST_SL_QUERY_2.ctID, FCST_SL_QUERY_2.f1, FCST_SL_QUERY_2.f2, FCST_SL_QUERY_2.FCST_SL, FCST_SL_QUERY_2.Last_Modified FROM FCST_SL_QUERY_2

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

Thx much.

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

OK I think what I added for the 3rd argument solved the problem. Thanks.

Sorry I didnt explain that right. When the returned value for [ADH_PCT1] is 0.95 nothing shows up, its just blank. Any other value like 0.94 and it say 3...as it should. There is no third argument. Thx for the [tt] tip.

When you add the TOP 1 in there do the values its returning all have different dates? It looks to me like this would return the TOP 1 for each date in that table.

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

That will work...thx

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!