Search results

I have a table with data about the number of accurences of a specific event. This table has 5 columns: Amount, Month, Year, Area and MsgType. From this table I would like to make a graph representing the following: X-Axis: Month Y-Axis: Amount Lines: MsgType The graph will get multiple...

I have a bunch of queries at the moment and they practically all do the same thing. I'm writing a program that makes a top 10 of events. These events occur in a certain area: 6-2 6-3 6-4 Pilot General All of these areas can generate some sort of event. The eventtypes are: Alarm Change DDP...

Im currently starting to get the hang of the report stuff, but I still have one big question floating around in my head. How do I create new sections in a report? I tried google, Access' help function and found nothing.. Lets take this for example...

I'm having to import data from a .csv file and that finally works. The csv files have a date in them and I only need the month. Editing the csv files is not an option on that though. I have read some stuff about a DatePart function but that one just doesn't seem to work for me. SELECT...