Search results for query: *

I have two database tables in two different directories, IE: c:\skcms50\family.dbf and c:\datarepair\skcms50\family.dbf. I need to take the family table in c:\datarepair and match it to the family table in c:\skcms50 on famly_id number, then if they match on famly_id, put the fam_hphone value...

Thanks, worked great!!

I have a database that has a family id that keeps families together. I need to extract into another table all the family id's that occur in the database only once. This will tell me how many families I have that don't have an individual record to go with them. Thanks in advance!!

Yes, all my years are 2 digit, but I need them to be four digit. They are all in the 1900's. Your first posted worked great, I forgot about having to have a 4 digit year. Thanks!!

I have a field (character) with a date in it like so 03/17/64. I need to put it in a string format. I have that part, dtos(birthdate), the problem comes in when the birthdate doesn't have a year, ie: 03/17/ I need to be able to put this in a character field in this format yyyymmdd. If the...

THANK you guys so much, I got the results I was looking for, just put a skip in and it works GREAT!! Thanks!!

Jim, The code you gave me works but it puts the same description in the table as many times as the personid matches, it doesn't change the description associated with the next instance of the person id #. Trying to figure out how to make it change the description each time??? IE: Person id...

I have a table that has an id # and a group description. The id # could be in there up to 148 times. I need to figure out a way to get, if the id# is in the table more than once with different group descriptions, into a field called church activites. Not sure how to get it to look at each...

Thanks Mike!! It worked great!! It put me on the right track!!1

I have 2 tables both with a memberid. Table1 and table2. If there are any records in table2 that are not in table1, i want to create a record for that memberid. How do I compare the two tables to see what memberid's are in table2 that aren't in table1?? Thanks in advance for your help!!

Thanks to everyone and your answers, I got it and it works great! Thanks!!

I have a table that has a date field in this format: 08032005. I need to get that field in this format: yyyymmdd. Can someone help please? Thanks in advance.

I have a field called membernum. It has numbers such as 101, 2801, 11202 and so on. I need to break that apart. I need the last two characters in their own field and the remaining to stay in the current field. Could anyone please help me, I'm having a brain fried day.

I have a table with a character date field in this format: yyyymmdd, except that some of the dates are just mmdd. How do I get all of these dates into a string format that needs to go into another program that only excepts dates in this format yyyymmdd(character field 8 spaces)? Any help would...

I have a field that has a character 0 (zero) in it. I would like to make that field blank when there is a 0 in it. I tried to replace the field with " ", "" and nothing works. My brain is fried today, could someone please help?

Thanks Stella740pl, works like a charm!! You rock!!

This is the code I have so far and it works to a point: x=alltrim(birthday1) x1=alltrim(left(x,at("-",alltrim(x))-1))&&&day x=alltrim(right(x,len(x)-at("-",alltrim(x)))) x2=alltrim(left(x,at("-",alltrim(x))-1))&&&month do case case x2="Jan" x2="01" case x2="Feb" x2="02"...

Thanks JRBBLDR, but it's in a character format.

If I have a date in this format: 29-Jan-95, how do I get that into a string format of yyyymmdd?

When creating a floating bar chart I have 2 series of dates. I can get the bar to start with the first date but it doesn't stop at the second date. I've tried formatting the axis but the bar continues to the edge of the chart?