Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: maggielady
  • Order by date
  1. maggielady

    replacing fields

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

    how to find records in db that only occur once

    Thanks, worked great!!
  3. maggielady

    how to find records in db that only occur once

    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!!
  4. maggielady

    Date problems

    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!!
  5. maggielady

    Date problems

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

    IF and CASE statement help

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

    IF and CASE statement help

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

    IF and CASE statement help

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

    comparing 2 tables

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

    comparing 2 tables

    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!!
  11. maggielady

    Date issue

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

    Date issue

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

    How to get last 2 characters out of a string

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

    VPF6: Character date to string

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

    replacing a character field with a blank

    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?
  16. maggielady

    formatting a date

    Thanks Stella740pl, works like a charm!! You rock!!
  17. maggielady

    formatting a date

    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"...
  18. maggielady

    formatting a date

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

    formatting a date

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

    Floating bar chart, not showing last value correctly

    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?

Part and Inventory Search

Back
Top