Search Results

Search found 2 results on 1 pages for 'veska stoyanova'.

Page 1/1 | 1 

• MS Access Mark Duplicates in order of appearance - using the function RankOfDup: (SELECT Count(*) ...)

  - by veska stoyanova

  I'm trying to create Ranking that shows the sequence of agreements for the two fields Customers and Agreements. The number for agreements must be unique, whereas customers can repeat. The formula RankOfDup: (SELECT Count(*) FROM Data a WHERE a.customer=Data.customer And a.agreement >= Data.agreement) Works beautifully but after this query with columns Agreement, Customer and RankofDup, I need to create crosstab that transposes the RankofDub. It works when I make the table first and then create query but my data is too large so I'm trying to put the select query with the ranking in a crosstab query. However, when I try to do this Access gives error message that microsoft jet ... doesn't recognise Data.customer? Any ideas how I can fix this?

  Read the article

• cant get my listbox to display objects

  - by Silvia Stoyanova

  Hello everyone I've been trying to put some objects in an ASP.NET list box but its just not working. I do have an overriden ToString method so I cant understand why this statement wont work. Here's the code that I use: for (int i = 0; i < fitnessClassList.Count(); i++) { lbDisplayItems.Items.Add(fitnessClassList.getFitnessClass(i)); } And the errors that I get: Error 2 Argument 1: cannot convert from 'FitnessClassManager.FitnessClassOpportunity' to 'System.Web.UI.WebControls.ListItem' Error 1 The best overloaded method match for 'System.Web.UI.WebControls.ListItemCollection.Add(System.Web.UI.WebControls.ListItem)' has some invalid arguments

  Read the article

1