Recent content by DeV

Nevermind, problem is solved..thanks anyway.

No one that knows? Theres got to be someone that works with graphs and reports..

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 found the solution for it by messing around in VBA. Thankyou for your help though Pat. This is it if you're interested. Public Sub FillTable() Dim db As Database Dim i, j As Integer Dim Areas(5), Types(5) As String Areas(1) = "6000/2" Areas(2) = "6000/3" Areas(3) =...

Because it might contain private/confidential data. :(

I made the example you linked too, and that works. Then I tried implementing it into my own DB but that refused to work even after a lot of fiddling around. I wouldn't dare asking you to make it for me, that's your own decision. Not going to force you to say the least :)

Sorry Pat but once again I'm just too stupid to understand that. Anyway I'll lay down the structure of the two databases. Anyway try to imagine the following, a factory that produces stuff in reactors. All reactors have particles like seals, valves, pumps etc. All these things can generate...

Like I said I have nothing to do with the data that comes into my database. It is being imported from csv files that are stored in a folder on the network. These csv files are generated every hour by all the apparatus connected to those networks. So either the entire network is crooked or Access...

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...

Could you explain that piece of code to me please? I've been trying it but the Case Like is not accepted by VB. If i just drop the Like i get an error when I run the query stating that it cant find my function. Appreciate the help. DeV

To be quite honest, the command Month, returns the day. I have a file that has dates from 10th of Januari till the 13th of Januari. Only problem is that the 10th untill the 12th are in mm-dd-yyyy and the 13th is in dd-mm-yyyy. Now you say that it doesnt matter what format it is because it still...

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...

Wouldnt it be possible to say something like: If Month(EventDate) > 12 Then EventMonth = Day(EventDate) Else EventMonth = Month(EventDate) If so, how could I implement this?

Thanks that helps, only problem is that it currently slices the day instead of the month. Guess I should just put Day instead of Month? I also noticed that some records in the table have a different structure. Normal: mm-dd-yyyy Some records: dd-mm-yyyy Anything to do about that automatically...

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...