Search results

Yes it was not the right column title. I figured it out though. This is what I wanted. SELECT Sum(Value) AS TotalAmount FROM Table1 WHERE Year(DATEOFSERVICE) = Int(YearInput); Thanks Alot though!

Why is it that when I run the query it asks for *Value*'s Paramater amount in a little text box? Sum(*Value*) I want it to pull the values from the table and sum them all where year is 2010. Not for me input the value. Thanks for all your help though. I am making some progress :)

How would you restrict year? I thought that is what I am doing by inputing the year 2010. There are rows that have dates in 1 column and $ values in another column. I want to add all the $ values where the years of the dates are all 2010.

This lets me input both the year and the value. I want to just input the year, and then it adds the values of rows that have that corresponding year in the date field.

I have a query that has names, payments, and dates. I need to know how to build an expression in expression builder in order to total the column of values if that value is associated with certain year, eg. 2010. Example data john, $30, 3/2/2010 fred, $25, 6/3/2011 sam, $20, 7/22/2010 kyle...

you cant join them based on a common value of a column? walmart matches with walmart so now take the attributes that were associated with walmart in the previous 2 tables and then join those attributes into a new table. thought it would be simple.

No, right now I have 2 tables. And no I do not have PKs because I do not need them. Table 1 Column 1 Title - Company Column 2 Title - Employee Last Name Column 1 Sample Data: Walmart Column 2 Sample Data: Smith Table 2 Column 1 Title - Company Column 2 Title - Contract...

Table 1: Company(field 1), Employee Name(field 2) Table 2: Company(field 1), Contract Start Date(field 2) I want to creat a new table(table 3) that has the employees name(field 1) and the contract start date(field 2). The table is made by finding where the company name matches and then adding...

They are not in the same record, they are in seperate records and that is just how I put them in my post. I am just wondering how to check to see if their is a value that is common in both tables.

I have a database with a table being a list of multiple employers and corresponding contract start dates. Ex. company1, 1/1/2012 company2, 3/1/2012, etc. Then I have a query of employees from multiple employers. Ex. John smith, company1, bill miller, company2, etc. I want to a...