Search results

Thanks Pat, just one question. Are you suggesting I should add a new table every year for the data?

Because this old columns don't have a date connected to them. But if yoo can help me that way, I'm happy to make sure a date will be present.

The reason is for comparison purpose and because this is the only 'old' data I have. It should also only go back 1 year and not the rest of this DB's miserable life.

Ok, let me try and clarify the situation a bit. I have date which is old (last year) en new (this year). Now, on the 1st of January (or whatever date) the new data becomes old. This old data is used for comparisons and stuff like that. This is a very easy cut and paste senario but it should be...

No, sorry if that was the impression I gave. I have only two columns: Prior, Present. The Present values need to get into the Prior column at a certain date. The Present values than need to be deleted (but the column obtained)

I have a database which contains information on last year and this year (number of employees and premium charged). Would it be possible to have a query or module or anything else automatically copy the data that is in the present column to the prior column on a set date? Thanks

You are correct, those are typos. The reason why I use 0,20 instead of 0.20 is of the Flemish settings on the computer, but either will do.

HELP with iif URGENT The first problem has to do with an iif function I am trying to figure out. I have asked this question before but the answer didn't work out for me. iif(format([Individual Policy Holders].[Date of first policy],”mm/yy”)=format(Date(), “mm/yy”), iif([Broker...

Head hitting keyboard:o . You are right, it is working now. I checked the links in the wrong database (I think I have about zeven copies of this thing now). Thanks to all of you, now I know were I have to go to get some help.

Thanks, here is the version like I received it from Rich (accept it is converted to 2000)

These are all the same. I have checked them already (and did it again just now). Every thing works fine @ Rich and I get the errors. Are there any libraries (accept the ones in the text) which 2000 doesn't have and 97 does?

The Module is defined As Currency The query columns which are used in the calculation are defined the same way but maybe Rich nows because he says I'll look and play around, maybe I'll find the solution but if anybody in the means time has any tips or suggestions, please let me know. Thanks

At least we got some change into the messages. When I try to run the query now it says: 'types in expressies don't match'. I have gone through that document again and made sure all libraries discussed are selected but this doesn't make a difference.:confused: Thanks

a: thanks I'll try b: this was the original module, this module was cut out of the DB to try and see if it was working c: this copy was used to test if it would make any difference to use the same name or not. Overall: big thanks, I'll try and build up the DB from this.

I did this before with the same DB and I didn't get any error (before I created Module). If I want to do this now, I get an message that I don't have all the libraries for Access 97. Maybe a problem can be found here. I have attached it anyways so if you get any error or problem please let me...

Unfortunately, no change :mad: . This is really starting to make me mad. I really appreciate the help. Maybe somebody can write a different piece of CalCom code to get to the same result (I don't know it so unfortunately I can't try that). Could this be a computer related problem rather than...

Thanks for that piece, but it didn't help me solve the problem (it was very useful in understanding the reasoning behind libraries). I haven't imported the DB into another blank DB. Do you mean just copy each tabel or do you mean export DB and import DB? Thanks

I have already tried this because I assumed I was making a typo or something.

This is when using CalCom() and any other suggestions that I have gotten so far.

I don't get any message when I compile the modules. I only get the undefined message when I want to use the query.