Adding input data

[RickieV]

Hi, I'm new to Access 2010, and learned about Tables, Lookup and etc.

I already enter data and need to find out how to add data.

e.g.

Date, Location Code, Violation Code

7/14/2013, 56, 5
7/16/2013, 68, 7
7/18/2013, 56, 5



I want access to be able to lookup Location Code 56 within a date range inputed, and add the Violation Code totaling 5+5 = 10

is this possible ?

Thanks.

[June7]

Why is a code summed?

Maybe you need to do an aggregate (GROUP BY) Totals query.

SELECT LocationCode, Sum(ViolationCode) WHERE [Date] Between [EnterStartDate] AND [EnterEndDate] GROUP BY [LocationCode];

Access Help (or search web) has more info on using the query designer to build Totals queries.


BTW: Advise no spaces or special characters/punctuation (underscore is exception) in naming convention. Also, avoid reserved words as field names. Date is a reserved word.

[RickieV]

Why Code summed?

I need to get the total number for ViolationCode given at a specfic LocationCode.

I will try your example and see if it gives me what I'm trying to get. Thanks.