Search results

Thank you, I got it working using the crosstab query CJ suggested. To Plog: what is the advantage of converting the dates to the first day of the month over just changing the format. I just used an expression Format([Pickup Date],"yyyy-mm") and it appears to group okay on the surface. As a...

I'm thinking this should be simple, but I am very much a novice and could use some guidance. I have data that is coming in the form of something like this which I have entered as a table: Date Type Quantity 1/14/22 A 4 1/18/22 B 2 1/24/22 A 5 2/3/22 C 4 2/5/22 B 8 I am trying to...

xxxx would be the sum of usage for an account of each entire month, such as March 1 to March 31. So in the end I want monthly estimates of utility usage for each account from whenever the meter was installed through current day.

I am new to access and have been trying to read through some tutorials and other posts to figure this out, but could use some more direct advice on my issue. I am trying to organize a set of utility usage data. There are several accounts (30+) that are read on different days. The end goal will...