Recent content by access09

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