records count

[gmpf]

Hi everyone

first time post.

I have a bunch of records in 1 table. Some records could have 1 duplicate field. What I am trying to do is create a query that produces the total or count in a new column. For example:

ID
FName
SName
Account#

If account appears more than once, I would like a new column to count the number of times in total that record appears. Then use this in a report afterwards.

Is this possible?

 

[pr2-eugin]

Hello gmpf, Welcome to AWF.

How about creating a Query that will count the field, then save it by giving a name, then use that Query to Join with the Query that will hold other information like FName and SName.. Use this new Query as the Report's Recordsource.

 

[gmpf]

Hi pr2-eugin

Thank you for your quick response, just to clarify or point me in the right direction

Should I do a find duplicates query first or the count first?

thanks

 

[pr2-eugin]

The method I have proposed would (a) Find the Count which should be 1 for non-duplicating records or any value greater than 1 (b) for duplicate records.

Is that something you wanted?

 

[gmpf]

Thank you for the suggestion it really helped, after trying it a few times I got there

 

[pr2-eugin]

Glad to help. If you get stuck somewhere, post back we will try to get you there. Good Luck !

 

[ootkhopdi]

Hello gmpf, Welcome to AWF.

How about creating a Query that will count the field, then save it by giving a name, then use that Query to Join with the Query that will hold other information like FName and SName.. Use this new Query as the Report's Recordsource.

how can i do that ,
pls tell me detail with example

ootkhopdi