Search results

Hmm the idea is as follows: so i have a huge table with data stored of accounts and sub accounts. For each of the account the value is a sum of certain sub accounts. So basically what i want to do is to be able to create a view of the accounts in such a way so that if anyone wants to see the...

it would be great if someone can tell if this is feasible to start with in Access or not using a macro or writing a code or through any other measure...thanks!

Thanks Chris, I know what you are saying but that is not what I am trying to achieve here. Even if I mention the field as a sum of sub accounts, would I be able to double click the same only to see the constituting sub accounts table separately?

Also since I am new to using this forum, could you please tell me where is Northwind's database located on the website? Thank you

Hi, Thanks for your reply. So basically what is happening is that there is approx 50 accounts each of which is made up a number of sub accounts, so in excel we generally do like Sum(SubAccounts Range) to get the value for the main account. So I want to something similar in access to for each...

I want to basically create a table such that if i double click on one of the fields in the table, it opens up another table that constitutes that value? So lets say that particular field contains A which is A=B+C+D+E, so what I want to do is when I click on A, it should open up the table with...

Can I also possibly ask you something ambitious I was trying to do? So in MS Access, I want to basically create a table such that if i double click on one of the fields in the table, it opens up another table that constitutes that value? So lets say that particular field contains A which is...

I understand that but I cannot paste the query actually...

Okay. So what is happening is that I have a huge table from which one query is pulling out certain accounts. The second query is then calculating a combination of those accounts using + and - operations and then we are using these computer columns to calculate a ratio. I am not sure how I can...

Hi Bob, There are 69 rows and 6 columns in the query results, but each of the 6 columns is a large computation of columns from another table. Thats why access is out of the limit in terms of characters. I dont see any other place where I can set the format, i did set the format in the table...

Hi, I am trying to format the values in a column which is a result of an extremely long query. Now I know that I can set the format in the design view but if I try to view the query in design view, because of its length, I get a message saying that "the expression you entered exceeds the 1024...

Hi, I think I was able to fix the problem of nulls with the Nz modification in my query so it is working fine now. Thank you!

yeah I dont think that is still working. So basically the problem is that for example from that master table, using a query I am getting three columns and I am trying to get a sum of those three columns in the fourth column. Since values in two of those columns is zero or Null (not sure), the...

Debug.Print also gave me syntax error like missing bracket or a colon. So just to be absolutely clear, when you mean copy, do you mean just copy the table and set the validation rule or something? Sorry I think I am still new to access so facing all these problems... Thank you!

Hmm, I dint know that, but i did try to change the same and run it to see if it can fix the error but again it is showing some error in syntax only. Is there a way to create a new table by name lets say HD_GL_ACCT_BALANCE_New which would have all the same fields as my original table...

Hi, I tried the line of code you provided but it is giving me a syntax error for some reason. I have pasted the code below here. Do you see any thing wrong in the code? Thanks! iQuery1 = "INSERT INTO HD_GL_ACCT_BALANCE ( [DATE], GL_ACCOUNT_NO, GL_BALANCE ) " iQuery2 = "SELECT distinct #"...

Okay. I think I have lots of blanks that are getting imported after making Nz a part of the query as well. So what can be done so that all blanks and nulls are set to zero? My excel sheet from where the data is being imported surely has zeros. So if it is importing from that excel sheet...

Actually I cant post the data base. So I will have to figure something. So when a field is a zero and NOT NULL, does a zero appear in the record or is it a - or is it just blank or can be anything?

Hi, I dont think that change is working still. I deleted all the records and I tried inserting new data in the table using the changed macro but still my queries of adding some records is giving me problems.

Okay, I am going to try this now, might take long... thanks!!!