Search results

Hi, Okay I will re-check my IIF statement, but that doesn't solve the problem. When i just join this table to another table and pull the column into the query, it still shows truncated values in the Column_4. (Which is also a memo field, No formulas used here,and if i just see values from...

Hi Gurus, need your help yet again. I have a linked table in Access 2007(link back to SQL Server), and when i look into the values of a 'Memo' Column called "Column_1" in Access, it is just fine. Now, In a query I am doing the following IIF statement: Expr1...

Hi guys, Excuse my novice questions. I have a query in which i did two things: defined a Column "Line Item Cost " as Sum ( using the dropdown in Design Grid of the query). Then i calculated another field: Expr13 which is: Expr 13: Sum([Line Item Cost]+ [Change Request Total Cost]) So, If Line...

Thanks a Lot, thats what i needed. Thanks, Kon

I mean, Do i need to modify SQL in SQL mode or can i do it in Design Mode of a Query? Please help! Thanks, Kon

Hi, that is exactly what i want, Please suggest how to achieve this using a Query. ? Thanks, Kon

Hi All, I have a Append query which has columns from two tables. Now i need to create a new column "Sum" in new table which should Add two of the Number columns . That is : I have column A and Column B; I need to create a Column C which contains (A+B) Please advise. Thanks, Kon

Hi guys, My task is to create a table with some columns one of which should be something like a Autonumber, but it should start with 8000, 8001, 8002, 8003 and so on. and not 1, 2, 3, 4 etc. Please help. Thanks, Kon

Hi Gurus, Here's my situation. I have three columns in Access: Attribute Name, DateValue, CharValue. I wish to create a make table query which does the following: If Attribute Name = 'approved_date' then take the value from DateValue Column and populate it in a New table 'new'. but if the...

thanks Hi thanks so much for your reply. Any easy way to build it from scratch. I created this table by getting data from three tables(using a query). ...Any easy way to do this or do i have to type in all the column names again? Meanwhile i will also work on your other solution. Thanks, Kon

Hi Guys, I am Creating columns in a table in Design Mode. First i created a table with upto 235 columns and i was able to save it. Now, i had to modify the table and delete some of old columns and create new columns. But Now, my table is not saving and throwing the error: " Too many fields" even...

I'm attempting to upload an excel file into access table using the wizard however I get this error message "subscript out of range" Please Help! I've uploaded other files via excel and don't have this problem. Thanks Kon

Infopath form .xml from an Access table.... Hi guys i think i am very close....and i need some valuable suggestions. Here is what i have done.... I have imported Data from an Access database into sharepoint by: 1) First Importing the Access table to a Sharepoint List 2) In Infopath i created a...

Hi Guys, I have an Access database which has many tables. I have also created a Infopath form template and published it to Sharepoint server. Now, My question is: How to get the existing data from an MS Access Table to a Infopath form? I need to create a Infopath form for each row in the...

Thanks a Lot! I was able to delete the other post. thanks

Hi guys, i have two databases. I need to Copy 'some' tables and reports from one database to the other one. Do i just do right click and Copy table and paste it in another database. Thanks, Kon