Search results

This forums sucks, I never get my questions answered. I would recommend this one: http://www.tek-tips.com/threadminder.cfm?pid=701

I created a pivot table as a data access page. Is there a way to create a pivot chart from this like in Excel?? Thank you

Hi, I have this query here: SELECT sum(subtotal) AS final_count FROM [select count(*) as subtotal from 1_2_06 WHERE Role='EUM' union all select count(*) from 1_9_06 WHERE Role='EUM' union all select count(*) from 1_16_06 WHERE Role='EUM' union all select count(*) from 1_23_06 WHERE Role='EUM'...

I don't think my previous post is possible, so to get around it, I would like to know if this is possibly. I have multiple tables that have the same column names. I need to go to each table, count specific values in that column, sum these values and update a separate table with the values...

I don't think my previous post is possible, so to get around it, I would like to know if this is possibly. I have multiple tables that have the same column names. I need to go to each table, count specific values in that column, sum these values and update a separate table with the values...

Can someone tell me why this query is causing this error? I don't understand it: UPDATE 1_2_06 SET ROLE = (SELECT ROLE FROM UserRoleData WHERE USERNAME=ASSIGNED_TO) WHERE EXISTS (SELECT ROLE FROM UserRoleData WHERE USERNAME=ASSIGNED_TO); thank you

Thank you, this works great. Unfortunately, I have to compare the Assigned_To field to another Assigned_To field that is setup this way (Lastname, Firstname). I have to be able to make exact matches on this data. Otherwise, I would definitely separate it, but I have no control over the data I am...

I have this query: INSERT INTO 1_2_06 ( Issue_ID, Assigned_To, ListType ) SELECT Issue_ID, Assigned_To, 'QPT' FROM QPTActions WHERE QPTActions.Entry_Date<=DateValue('1/2/2006') And QPTActions.Close_Date>DateValue('1/2/2006'); The Assigned_To values are a Lastname, Firstname format as they...

Nevermind...this was a dumb problem with a lookup field. I had the 'Retrieve IDs for lookup columns' checked, when importing a table.

Hi, I have a strange problem, I have created this query: INSERT INTO WEEKONE ( Assigned_To ) SELECT QPTActions.Assigned_To FROM QPTActions WHERE QPTActions.Entry_Date<=DateValue('1/2/2006') And QPTActions.Close_Date>DateValue('1/2/2006'); It works, but it inserts Numbers into the Assigned_To...

How can I get around not being able to create multiple statements in a single query? For example, I tried to do this: DELETE * FROM UniqueDates; INSERT INTO uniqueDates ( Entry_Date ) SELECT entry_date FROM [SELECT Entry_Date FROM BarcelonaInternalActions UNION SELECT Entry_Date FROM...

Hi Everyone, I am about to embark on a big task of displaying charts and graphs with access. I've been using excel, but I'm hoping to leverage my SQL experience to better manipulate the data using access. In comparison to Excel how powerful are Access' charting/graphing features? Can you...