Search results

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

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