Recent content by krismtx

Yes, you are right. Ultimately, I do want a full year. I have been pulling smaller groups of data, like the just January, and then I am comparing with an old "Report Builder" which is the reporting tool which comes with the Pick Database our company uses. I want to use Access and ODBC to utilize...

I use Access 2000 to query a Pick database. There are 2 date fileds, EntryDate and EffectiveDate. I actually need to see a LaterOfDate. I have created a calculated field called LaterOfDate:IIF([EntryDate]>=[EffectiveDate],[EntryDate],[EffectiveDate]). For the LaterOfDate, I have used the...

I have added the table 4 times. I've added Loss_id to the first grid. Do I create a new field in the second grid called Concatenated_Description:[Loss_Description]&" "&[Loss_Description],etc.?? TIA! Kris

I can't wait to try this! Thanks so much!

I have imported insurance loss information from another database. For some reason, each Loss_ID, can have more than one Loss_Description. Ex: 12300 The patron fell on the floor 12300 while he ate his burger 12588 The child slipped on the steps How do I combine all of the descriptions with the...

Thanks Pat, I can't wait to try this! Kris

I have created a great crosstab report from a crosstab query, but I'd like to add info from another table that's static. Example: My Row Headings are: ClientName, CarrierName, and PolicyNumber My Column Heading is MonthDue, and the Value is AgencyCommission Now I'd like to add static...