I have a file (sample attached) where I have a bunch of colors and an associate dstate. I would like to make either a query or report where it would give me a count of what I have and where. For example, it would tell me:
COLOR STATE Count
Blue NJ 2
Red NJ 1
Green NJ 1
Blue NY 1
Red NY 1
How would I go about doing this? Thanks!!! Sample.mdb
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query: