Recent content by gmpf

Didn't think of it that way (usually my problem) So; just to clarify for my own piece of mind For example if add3 and/or town was without any data Thus could then be omitted from the query? If I've understood that correct how would I go about doing that in the query Thanks for ur help again Paul

Thanks Paul, will this approach help with removing the <null> values. Otherwise the address labels look a little unprofessional, if you know what I mean?

Hi everyone I would like to create a report based on a query. The first part is simple enough. However within this query I have a 'Count field' (a total of the number of duplicated this record has appeared in the table). And would like to create a subreport (if possible) based on that...

Hi everyone apologies in advance if this has been asked over and over, I can either not find the correct answer to both the following (what should be a simple request) or I'm doing it wrong? The first part of the request is to capitalise all the below fields, when they appear on my report...

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

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

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