Search results for query: *

Brilliant

I am trying to do an update if the record exists else insert the record for multiple records. The way I normally handle this is with a left join/where is null statement at the end of my insert statement. I'm not sure how to handle the subquery in my statement using this method. Update v1...

I think that should work - thanks.

Table1 contains a integer field called type. It contains either a 1,2,3,4, or 5. I need to insert into table2 either a 1 or 0 into 5 different fields. So if type contains 3 I would need to insert field1 0 field2 0 field3 1 field4 0 field5 0 Thanks

if isnull({AoDealerCodes.Name}) then {AoDistCodes.Name} else {AoDealerCodes.Name} Although it would probably help if I updated the correct formula. Everything is working fine. You were correct a few posts up. Sorry. Again, Thanks for your help.

Yes, the crosstab is in Group #2 and there are multiple distcodes per distUnit. When I move the crosstab to the report foot it does the same thing, it rolls everything up that doesn't have dealercode into 1 line with a blank name. Thanks for all of your help so far.

lbass That is really close, it is doing something that I don't quite understand though. It appears to be combining all of the distcode.Name into 1 row and displaying it as a blank name. The circulation Counts are correct, but for some reason it rolled them all up into 1 row in the Crosstab...

CR XI My tables have a hierarchal setup. DistUnits DistCodes DealerCodes Not All DistCodes have a DealerCode I have a report with a crosstab. Currently the report is grouped by Group1 Date Group2 DistUnit Within Group 2 is a crosstab setup as follows Column is customerName Row is a...

lbass Thanks for trying, sadly I don't know how else I can explain it.

What tells me which routes belong together would be the customers they have in common with > 0 in the circulation count. I was thinking it would probably be easiest to go from most customers to least. For example Cluster 1 might have Routes 1-4 because they have customers 1-5 all having the...

Nevermind about the cluster thing, I'm kind of slow sometimes.

Thanks for your response lbass It appears i forgot to mention that the routes will vary from week to week. the 124 was just an example. One week Route 4 might be in the first group, the next week it might be in the 3rd. I'm wasn't familiar with the cluster, but I will look into it.

CR XI I have a currently have a report with a crosstab setup as follows: Rows: RouteName Columns: CustomerName Summarized Field: CirculationCount The report is currently only grouped by a Date Parameter. I need to add a group to the report and can't quite figure out how to do it. I Need to...

That query is worth a star in my book. I have had a similar problem, and was never able to solve it. Have a star on me.

That works well, do you have one for the standard deviation?

I had a similar question dodge Here is a star