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

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

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

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

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

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?

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?

I need to get a numeric date field into a string format yyyymmdd. EX> I have a field called joined that is numeric, field size is 8, I need it to be in a string format when the program runs. Thanks for any help you can give!!

I have a program that takes the entries out of one db and puts them into another based on a certain criteria. Once the record meets that criteria it's moved to the second db but then I want to delete that entry that was moved out of the first db. Not sure how to accomplish this. Any help would...

I have these lines of code and I want the family_id to increment and I want the key field in the syskey table to increment the same as the family_id. I can't get it to work. Could someone Please give me some help??? select 18 nextnum=key (this is numeric) * FAMILY PROFILE -...

I finally got my daterange parameter to work!! But I just found out that I need to be able to access the report by daterange and by lastname+firstname. How do I get another parameter in the report so when they run the report it will ask what daterange do you want and whose info do you want to...

I have a report that I want to be able to have the user chose a date range for the report. I have a field in the contrib table which is a recieved date. I want to create a parameter that will allow the user to chose a date range for the report. I've tried but can't get it to work. I put it in...

if i have a field in a db called famphone and the phone # is in this format: (123 2342345 and I want it to be like this (123) 234-2345 what would the replace statment be? I've been trying for awhile and can't quite get it exactly right. Thanks for any help

I have a report that has multiple fields from a family dbf. I have the report grouped by lastname and sorted on lastname. There are 30 families in the dbf. But when I run the report only 27 families show up. After looking at it the families that aren't showing have one or more of the fields...

I have two tables, family and lookup, if I have one link established between the two, the family status(from family table) to table id (in the lookup table) I called this family status. And I dropped the table description field right on the report and it worked great. Now I need to make...

I have two tables, a family table and lookup table. In my report I want to include the family status field from the family table. I have the two tables linked by status id but in the both tables it's a number. There is a text field in the lookup table that gives the corresponding text for the...