Search results

Sorry that worked CJ, I had the form in design view when I tried your code. Thank you both very much.

That unfortunately gives me the same error I was getting before: Enter Parameter Value Forms!AddEmployee!First_Name

That is what I did. I simply created a blank database and imported everything from the old 2003 database.

Is says Missing Semicolon (;) at end of SQL statement. But its there. Never saw that error before.

Here is the SQL. This worked perfect until I switched to Access 2k7. I have a button on the form that simply runs this query. INSERT INTO CUSTOMER_LIST ( First_Name, Last_Name, Zipcode, Phone_No, Email, Referred_By, Referrer ) SELECT ([Forms]![AddEmployee]![First_Name].[Value]) AS First_Name...

Hello, I know I am behind the times but since I updated my Access database to 2007 my append query no longer works. The query is taking values form an unbound form and appending them into a simple customer table. Did something change that ([Forms]![AddCustomer]![LastName].[Value]) no longer...

Thanks I will give that a try.

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

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

I think I got a solution for this I appreciate the info. We just needed a way to show a history of when a rep comes and goes. and so we dont drop their stats if they arent currently in the system. It a nutty process for sure.

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 but just playing w/ the chart feature is getting more confusing by the minute. Any tutorial would be great. TIA!

Absolutely perfect. Thanks a ton.

Is it possible to actually change a number to text? I cant seem to figure out how. I have 2 proprietary systems one uses a number and one uses text for the same item. I know how to change the text to a number however the more efficient way for me to do this is the other way around. Its the...

HAHA genius..thx that worked perfectly. Getting late in the week im about burnt 8).

Hey folks, What I have is a query that results in some general employee information including: EmpID EmployeeName TotalHrsLogged The original query looked like this: SELECT EmployeeID, EmployeeName, Min(TotalHrsLogged) As LowestOcc, Max(TotalHrsLogged) As HighestOcc FROM qryName GROUP BY...

Oh ok I was under the assumption that the custno would be in both tables so LEFT OUTER would have still had the same results.

kinda like this youll have to fiull in table names: SELECT YourTable1.Custno,YourTable2.[customer Logins] FROM YourTable1 INNER JOIN YourTable2 ON YourTable1.custno = YourTable2.custno GROUP BY YourTable1.custno HAVING (((YourTable2.[customer logins]) Is Null)); or SELECT YourTable1.Custno...

Create the query Join at custno and then put IS NULL in the criteria section OR like this in the sql window HAVING (((customer logins) Is Null))

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