Search results

Yes I think you are right, so I need to check the same for nulls in the other fields as well. so my entire query looks like this: iQuery1 = "INSERT INTO HD_GL_ACCT_BALANCE ( [DATE], GL_ACCOUNT_NO, GL_BALANCE ) " iQuery2 = "SELECT distinct #" & iDate & "# AS [DATE]...

Okay the bigger picture is that I have daily spread sheets coming in which I am importing in a big table in MS access using VB Macro and my macro has the following line: iQuery3 = "FROM Temp_Data WHERE (((Temp_Data.F1) Is Not Null) AND ((InStr([F1]," & """" & "-" & """" & "))<>0)); "...

Thanks for the quick reply, is there a way to modify the table because my queries are extremely long?? there is just tons of data so it might be easier for me to modify the table and create an updated table.... thanks again!

Also, it would be great if someone can tell me how to use a calculated column in a query as a part of another calculation in the same query. So what I mean is lets say you have columns A, B and C. Then you are trying to run a query which has Sum:B+C and then can I use Sum in the same query to...

Hi All, I have this huge table that I run queries off to get desired results. Now in that table of course there are some values and some nulls. So if I am trying to run a query which sums three of the rows with one null value, the result is a zero. Now I am looking for a query that can help...

Hi, I have a database for accounts and I have a particular format which is produced by a query giving me only 50 rows which are mainly sums of a few rows above it. What I want to do is to be able to click on a field or a record for any of that 50 row to be able to open up a table consisting of...

Also, when I am trying to fetch only certain fields from the table by creating a where clause in the following statement: iQuery_Where = "HD_GL_ACCT_BALANCE.GL_ACCOUNT_NO=CFA OR HD_GL_ACCT_BALANCE.GL_ACCOUNT_NO=REC"; Does the CFA and REC need to be in quotes like "CFA" and so? Also I have 50...

Hi, I am trying to create a filter to contain dates from a table and then trying to run a query on the same table to get corresponding date's values. But I am getting a run time error in the following piece of code: iQuery_From = "FROM HD_GL_ACCT_BALANCE INNER JOIN MAP_BALC_DESC ON...