Search results for query: *

Hi, How would you write in the select record to list all records from a date field to the last 3 years? should I use date diff from currentdate to ????

Hi, I need to write a formula to change from date format xx/xx/xx to month format such as Jan, Feb, etc... How would you write that case? Thanks, C

Hi, Would someone help me write this formula? Here's my data: ID Service Beg Date End Date 1234 H1111 8/18/2010 8/20/2010 1234 A148 12/16/2010 1/16/2011 1234 B1498 8/16/2010 9/15/2010 1234 H1111 8/11/2010 8/12/2010 1234 98104 8/18/2010 9/15/2010 1234 H2011 5/16/2010 9/30/2010 I have a date...

Hi, Would you please assist me with this? I know what I'd like to see on my end-results, but I'm not quite sure how to go about it. "X"s are the results on my main report, and "Y" is the result on my sub-report. Here's my data: ID Service Beg Date End Date 3549 H1111 8/11/2010...

Hi, I did a parameter on customer names, and it only pulls in up to the letter "I" on my list. Is there a limit on the parameter? how do you set it so you can see all of the list? Please help! Thanks, C

Hi, How would I write a formula to change my service codes to the group code "Basic"? These are my service codes: 1) A123 2) S5286 3) H1111 4) H1112 5) H1113 6) H1114 7) H1115 8) H1116 9) H1117 10) H1118 I know how to write a case to change each service code to "Basic", but how would you...

Hi, How would you write a formula to blank out the first five digits of a social security number? The output would be like XXX-XX-1111. Thank you! C

Hi, Would someone give me some ideas how to go about this? I need to show my data all in one row, with only date1, date2 and date4 showing only. It doesn't matter how many dates an ID has. ID Date 3 7/2/2011 3 7/6/2011 3 7/7/2011 3 7/10/2011 9 7/1/2011 9 7/3/2011...

Hi, Would someone help me write the codes for this? I am not sure how to do the row count as it looks at each row. Would I need to do a sub-report? Any suggestions would help me a lot. Here's my data: ID Assistance 5 Medicaid 5 Medicare 5 Food Stamps 24 Medicaid 49 Food Stamps 119 Medicare...

Hi, Would someone help me write the codes for this? I am not sure how to do the row count as it looks at each row. Would I need to do a sub-report? Any suggestions would help me a lot. Here's my data: ID Assistance 5 Medicaid 5 Medicare 5 Food Stamps 24 Medicaid 49 Food Stamps 119 Medicare...

I had created a switchboard, and and item on my switchboard. The particular item on the switchboard is a form operation and the command is "Open form in edit mode" and it is pointed to that form. When I got out of the switchboard, and try to click on that item, it doesn't do anything. Does...

How do I write in my query to search for multiple names starting with "COMMUNITY"? Example: If I type "COMMUNITY", it will show me all 3 COMMUNITIES listings: 1) COMMUNITY ENLISTMENT 2) COMMUNITY ORGANIZATION 3) COMMUNITY ENFORCEMENT If I use the "LIKE" command, and enter "COMMUNITY" only...

I'm trying to write a CASE statement, but it's coming out with this error message. "The selection formula must be a boolean". My ID field is a string. Can anyone help? Select ToNumber ({NoName.GUARD_ID}) Case 15, 16, 17, 18 : "Medium" Case 19 : "Good" Case 21 ...