Search results for query: *

I am very familliar with SQL databases and am using FileMaker 5.5 for the first time. Is there any way to issue commands to query or modify large chunks of data? I am looking at the ScriptMaker from the menu but that appears to be some kind of Macro creator. I'm just not familliar with what...

When trying to open sent internet e-mails from history I occasionally get the message "Body of E-mail Unavailable". Does anyone know why this occurs and how to correct it? Thanks

I am having a problem getting the correct settings to allow users to view, edit and delete their own histories but only have access to view another users. When I take the check out of Access to Others History it sets it so they can't even view another users histoty. Please tell me the correct...

Yes I realized I had an error in the statement after I posted it. However, this is exactly what I needed to know. Thank you very much for your help!

BTW, I am using MS SQL 7

Hi, I am new at using SQL and I made a very simple query to pull a few fields from 2 different tables. Now I need to add a field from a 3rd table but I am not sure how to link them. My statement so far is: select key1 as 'ASI#', contact1.Company, contsupp.contact as "Type", contsupref as "Web...

I have a problem with a report I am doing where I need to get complete totals for codes but I am getting them separated by my groups. I have them grouped by Activity Code, Reference Code and then Result code. I would like the report to turn out like this - Activity Codes 1 - (count) 2 -...

Is there any way that you can set a margin down the center of the report so data can continue and still stay on one page? I have 1 very narrow column that is just showing some quick totals and it is using 3 pages. They could easily fit on one page if I could make a margin. Thanks Joe

Both samples worked great, I appreciate the help.

Duplicate records ignoring primary keys. Sorry.

What is a quick SQL query to simply show me a list of duplicate records that exist in a database?

I am using Crystal Reports 9 and when I go to the Visual Linking screen not all of my tables come up with the color coded index markers indicating my indexes. They do infact have indexes but the markers only seem to appear randomly. I tried browsing to an external index but they still do not...

I am having the same probelm. This only occurs with users connecting to Goldmine via VPN. It doesn't matter what user logs in, it still happens. Auto roll-over is disabled but this still occurs. I'd prefer to avoid rebooting the server. Does anyone have any other ideas what might be causing this?

Hi am am trying to get this string to date conversion working. When I check it it tells me there is no errors in the formula. However when I run the report I get "Bad date format string." Here is what I am trying to use: if {Contact1.ACCOUNTNO} startswith "A" then...

When I am trying to run a report linked with 2 DBF files I get the error xBase error: Bad User Specified Key Expression. Does anyone have any idea of what this is and how to correct it? Thanks, Joe

Thanks for the tip. I'll def. check it out. Joe

My company currently uses Goldmine merge forms as it's order form system. We are quickly out growing this. Does anyone have any recommendations for a good (somewhat inexpensive) third party order system that 70 or so users can use. Any ideas are welcome, even if it doesn't interface 100% with...

I have a report I am trying to show amount of scheduled events for a coming week based upon a parameter and summary formula. I have this formula I am doing a sum summary off of: if {CAL.ACTVCODE} = "TRN" and {CAL.ONDATE} = {?TRNSC} then +1 I simply want it to count the number of...

Hi, I have a field that I use in a parameter for a user to select the date range. The field is a date-time field and by default allows you to pick the time in addition to the date. It defaults to the current time. Is there a way to get this to default to a time I specify (ie. 12am) but still let...

Could someone please clue me in to the conditions in which Groupwise 5.5 displays HTML e-mails? It seems to sporadically display e-mails with embedded HTML. I have tried to figure out why some sites like MSNBC if sent throught Outlook can be viewed consistently but other sites cannot. Is there...