Search results

Thanks. When I run it it throws up an error. See red below. Its says 'no current record found'. When I go into the risk table only the last line of an the address displays for a cover number. Any ideas?

Thanks that looks great. How do I call it in the immediate window though? Where is the immediate window in MS Access 07? Thanks A. Shrimp but the number of address lines does vary. From one line to 6 lines.

This is the way the address was typed into the old database. I have to work with the data the way it is.

That is how the data from extracted from the database. The field had a character limitation so it was spread out over several rows.

I have table in an Access db that looks like below: There are two fields - Cover number and address What I want to do is create a query or alter the table so that the output leaves me with no repetition of the cover number and the address all on one line between the two fields. I.E. The...

Thanks. Thats great

Yes. Thats exactly it.

No as in give me a full field back as it was with the changes made.

I see where your coming from but for this no. Its just 0 and turns the number negative.

Thats great. It works. Is there a way I can have all the debit amounts in one field, including positive and negative numbers??

I have a field with amounts in it. For example: Debit Amount: 00000006223 00000004356 0000000432r 0000000845v 00000006226 0000000198s 0000001638w 0000000911r 00000013667 0000000113q 00000001508 However, when the ‘Debit Amount’ has a letter as the last character,i need to replace the letter...

How do you set your system date. thanks

When i use the cdate function to correct the format it cant do it properly. I think this is because it is checcking the date in the american format. See results of the function below: 230493 - 4/23/1993 230494 - 4/23/1994 310598 - 4/31/1998 310500 - 5/31/2000 310502 - 5/2/1931 310506 -...

The dates are stored in an access database and is a text data field.

How do I format this dates into a proper data format such as dd/mm/yyyy Examples of the way the dates are stored in an access database are as follows: 020196 - (Stands for 02/01/1996) 160799 140502 231105 260509

Thanks Brian. The DateSerial function worked a charm. Funny enough it did come out in the American date format but that doesnt matter. It works for all the dates but it doesnt count the way I want it too between certain months. For example, Start Date - 05/12/09 Renewal Date - 10/01/10...

The date difference function should still work if I just have the day and month. But all my insurance policies have their dates in the format '1209' which should be '12/09'. Can you think of a way I could insert '/' into the '1209' date field?

Made changes to my post, see above. I leave out the year because I only want to know which insurance policies dont renew on the same date of the month they were started regardless of the year and to show the difference in days.

Hey, I am trying to count the number of days between two dates. The dates are associated with an insurance policy. One date is for the day the insurance policy began and the other date is for the day the insurance policy was renewed. What I want to know is the diference in days of the date...

Thanks. Looks good. What do you mean by the immediate window actually? Where do I type in the code?