Recent content by MDekker

I think I got it pretty much covered, the normalization part of it. I am entering data only once and use it all around. Using lookup functions to create links between different tables.

this thread can be closed as I change from date dependent to non date dependent as I can get my head around it. :cool: thanks everyone for your help!

Hi all, it's me again. I am still strugling with my access database. After you said my database was all wrong, I started over again. I did manage to solve a few issues. Now I am stuck again like a real noob. Situation: Table1 = contains the information of which I would like to show de...

I am trying to setup a database for dealers with machines they need to report hour readings of. The hour readings need to be put into a report with graphs so the dealers can have a monthly report of their fleet and suggestions on what needs to be done related to maintenance etc. I have made...

Well I can't get it to work as I want it. So I just forget about the excel and am working on a new database which can hold the same information, but with more lookup tables so I only need to enter data one time and this data can still be used accross different report graphs and forms.

thanks, I will give this a shot tomorrow morning when I am fresh again. This sounds like the thing I was looking for. !!!

This is the query I have: SELECT Tbl_Master.Model, Tbl_Master.[2014,02], IIf([2014,02] Between 0 And 3000,1,0) AS [0-3000], IIf([2014,02] Between 3000 And 6000,1,0) AS [3000-6000], IIf([2014,02] Between 6000 And 9000,1,0) AS [6000-9000], IIf([2014,02] Between 9000 And 12000,1,0) AS [9000-12000]...

I understand what you are saying here Paul, thing is I don't have a date in the column "2014,01" I have per machine the running hours. I need the running hours per month and calculate differences between them and create graphs. Once I got this dynamic column selector query running I can figure...

Yea I might not have been too clear in my explanation I see now. Sorry for being slow :) In my table I have machines and each of these machines have running hours per month. The months are in columns and the machines are the rows in the database with loads more information per machine. I...

I thought the crosstab query was to be used for information between tables. My situation is: 1. I have one table with per month hour numbers 2. each month another column will be filled with new numbers 3. each month I need to produce reports 4. which I would like to be done fully automatic...

yes I can understand the use of a Pivot table, but then I need to change the range of the information every month and that is what I would like to avoid as I need to produce like 40 different graphs and I don't want to change the data range every time manually.

Is it possible to use date dependent field names in a query? I have this table and there are columns based on year and month (formate of names is: 2014,01) I need to select the columns of last month and then 4 months further down in history. Is there a way to do that as the information in...

Hello all, I have been working with access several years ago when I was building my own databases to help me do my job more efficiently. At this moment I just started a new job and there are different oppertunities for improvements here. I hope I can be of any assistance here to others...