I am fairly new to access and I would really appreciate your help since i ran into a brick wall with my database. I am a university student and im working really hard to get this database for my work (potential permanent position).
I have several tables for different file types. Each table has a city field and dates of submission. I would like to query by city first, then count how many applications were made in the first, second, third and fourth quarter of the year for each type of file for that city.
example:
Tables of File types( each with city and date as fields): Agreement A, Agreement B and Agreement C ... each agreement table has various applications
I want to show in a table in the following format (numbers being amount of applications submitted):
"Agreement Tracking For City 1:
___________|_Jan _Feb_ Mar ....
Agreement A |_20 __3 ___5 ...
Agreement B |_15 __20 __5 ... "
Thank you very much in advance!!