Search results

@PatHartman no I had it from the start. I originally had the correct PK/FKs as you mentioned, but somehow after all my fiddling I screwed them up. Anyway, fixed it. Exporting to an excel file may be the best route as you say, I'll explore that a bit. Thanks.

@PatHartman - ok I will look at the date suggestion, thanks. I have multiple tables. I definitely don't want a spreadsheet, just was hoping for something similar to a spreadsheet for the monthly/annual report. The bulk of the data portion is the water use entries. There are about 100 sources...

@June7 - thanks for that, I haven't used crosstab queries before. But maybe I can modify the report based on what crosstabs can do for me. (Sorry I can't post the db - be too much work to remove proprietary info I've already added). Also I think I can do some more brainstorming on...

Hi, self-taught with access and my first time posting. This forum has helped me a lot! I'm building a database that tracks water usage from lakes (sources). For the purposes of my questions, I have the following tables: Sources, Permits, Withdrawals, and UseTypes. I am ultimately trying to...