graham666
asked on
Expression Builder Help
I have a query written using the design view / expression builder and i would like to include the equivalent of a row count in the results. Can someone advise how to do this please?
I tried using count and count(*) but this does not return what i need. I am using group by in the query so this may have some impact. I would just like to be able to add a column that literally returns a the row number for each result.
I tried using count and count(*) but this does not return what i need. I am using group by in the query so this may have some impact. I would just like to be able to add a column that literally returns a the row number for each result.
ASKER
i did mean query designer. I have group by already and if i add a count it returns 4 for one row, 2 for another 3 for another. I need the result to be 1,2,3,4 relative to the rows.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can include a Count in your query, but you must also Group all other items in the query ... open the designer, click the Group By button (or select it from the menu), then work through your fields to get the info you need.