Search results for query: *

I have a set of values in table NPANXX and need to delete records in Table 2 where Field A in NPANXX equals Field B in Table 2.

I have a date field that is showing dates in the following format: 1/9/2006. I need it to show with a two digit month and day and then be converted to YYYYMMDD format.

How can I add 30 days to an existing date field

I have a text field (0000000.00000) and I need to convert it to a numeric field. I have tried Int(Field Name) and set the properties to Fixed with a decimal value of 5. When it converts, it places all 0's after the decimal point.

I have 2 fields that contain dates that are text fields. How can I calculate the difference between the two dates?

I have a text field that contains a number and I need to multiply it by 100 but it is returning an error. Other than re-importing the data, how can I get around this error?

I have two fields (Phone #, add on). I need to create a single record for each phone number and unique add on.

I have multiple fields where the date is imported as M/D/YYYY. I need to find a way to convert it to YYYYMMDD.

I am trying to find the difference between Todays date and another field called Went Negative Date. I have the following code in place but I am receiving an error. Please help me locate the error in my code. =DateDiff("d",[WentNegative],Now())

I have one table (Table A) that has a specific id number and then I have another table (Table B) that has multiple records that have ranges of id numbers. (Ex: Value in Table A = 123 Range in Table B = 000 - 120, 125 - 150). Using Access 97, how can I run a query to verify the values in...