Search results

Hello, Thanks for the suggestion on the query it worked using that method.

Hello, Thanks for your advice. I have not done the querydef in this section of code but I have used code like that in similar sections. Essentially it will look like this: Sub X Dim strSQL1 As String Dim querydef As QueryDef strSQL1 = " Sum SQL Statement " querydef = strSQL DoCmd.Save ...

Thanks for the replies. Alc and Brian your suggestions seems like it may work to what I am looking for. A mix of the two may work nicely. FYI. The table has about 8 fields containing data about Tasks where the Task is the Primary Key in which I allow duplicates. So far keeping it as the...

Hello, I have yet another question in regards to Access. I was tasked to figured out how to graph data historically by day that is generated by a SQL query of expressions. I currently coded a SQL query to formulate the numbers needed, but have no knowledge of how to graph it historically...

Hello, Thanks for the idea. That is not a bad idea, but only one catch is I want to filter the table in such a way that I can show every entry that has the same task ( a field in that table) Now this table will possible mutiple entries for the same task so I would want to grab all of them and...

Hello, I have a table in a form to track changes to items in source table. Items are copied in by selecting the items in drop downs and after a button click the item needing editing is copied into this tracking table. Now what I want to accomplish is too build a query (ultimately to drive a...

Hello, Thanks for the replies. I can see both your points in using the update query. I will see what I came figure out. I don't think I need the join in the query. And now that I think of it the violation makes sense because the Task field in source table is the primary key and same for the...

Hello Dcrake, I tried what you suggested and then update query runs but after I hit yes to modify the rows another window pops up with a error message saying I have a 2 key violations. I am unsure of how to fix it. My guess is that its not happy that I have identical tables (one the source and...

I have created a form that will allow a user to browse for a excel file and then import the excel spreadsheet into a tempTask table and then I want to do a update query on the main source table called Task. Both tables have the same number of columns and same field names but the update query...

I actually figured this issue out on my own. I had the right concept however it was not filtering correctly because I wasn't using the relationships correctly. In the one case I wasn't filtering on test case simply because I wasn't select test case in the query so the parameter passed did...

Hello, I finally got back to working on this issue and I did resolve it. The parameter I was using did not exist in the query so I reworked the query to add the table with the value I wanted to export on as the parameter and it worked flawlessly. Just thought I would post a reply since I...

I have form that displays mutiple queries in pages (the queries are subforms). What I am trying to accomplish is that upon selection of a value in the combobox I want to have the ability to filter all the queries based on that value. Currently, I can get it to work halfway where the filters I...

I have this query setup to produce summed values and it works fine. Now I am trying to display the output of the query in a pivotchart however it does not seem to pull all of the data in the query. My mock data table has three test cases in it. And it seems that this query will only show 2 out...

In using your pointers I am trying to formulate what the query should look like in terms of using the iif separate then using Dsum(). But I am getting a data mismatch comparison or a error trying to using expression...error. In Try1 I just wanted to make the expression work but I failed at that...

Hello, I have fixed my problems. It was with the query it was referencing itself. I also corrected the query in the VBA code. However, it works as I planned but the code doesn't pass the parameter to the query. It will prompt me for the parameter and the query executes but it doesn't returned...

Hello, Thanks for the suggestion. However I just gave it a generic filename.xls and re-ran the code. I pull up with another run-time error #2282. The format you trying to output the current object is not available. I am assuming that it either doesn't like my SQL string or the fact that I am...

Hello, I am trying to create an export function in Access to export a query with filter that is controlled by a combo box then export the query to Excel. So far I browsed this forum and other sites and put together the VBA code that was used by other to try and accompolish what I want...

Adam, Thanks for your pointers. I understand what your saying and I will try it out and see what works. I know I was able to do this type of sum with the iif that would look at field x and if it was not null it sum every record for in the table. This works so that is why I tried this query. But...

I have a select query with a number of expressions and I cannot seem to get the expressions to work. Access keeps giving me syntax error on the following code: SELECT Run.Test_Case, Sum(IIf(DateValue([Attempted_Actual]) < DateValue([Attempted_Actual]),[Points],0))/Sum(IIf(Not...

It appears to be a corrupt query and form. I believe the form was corrupting the query in some way because it would only be after the first time the query was run through the form that the query would disappear. I re-created the form and rebuilt the query using the query builder instead of the...