Search results

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

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

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

I am trying to use a replace function in VBA to run a query but I dont know how to reference it in VBA in order for it to work. Here is my code where I ahve tried to use to get rid of certain characters from people's name: Public Function GetName(AnyText As String, bFlag As Boolean) As...

I am trying to seperate a name field so that only the first part shows. Data I am trying to seperate looks like this: John/Mary Frank/Jennifer Ben Jonathan/Janet I tried using this: Left([name],InStr([name],"/")) However, when I use it the 'Ben' entry disappears and the first part of the...

How can i use the replace function to replace a number of characters...below is what i have so far: Expr1: Replace([occupation2],".","") Above just replace '.' but i want to replace other characters like "`" , "^", "+", and so on. Does anyone have any ideas??

I have to following code to loop a large amount of data in an excel spreadsheet. However it takes a very long time to loop through the data( around 8 minutes) and produce a result. In the code I pick one entry from spreadsheet one to loop through spreadsheet two entries and find any entries to...

I am trying to run a query to display all the account numbers that appear in TableA but do not appear in TableB. What should i type into the criteria section? I tried 'not equal' but just returns a list of the account numbers in both tables.