Recent content by morningla

I see. Thanks. It worked great. Could you explain to me what the 0 means? when I format the custom cell? 0 " Holiday(s)

oh i already got it to work with this =COUNTIF(C2:C366,"0")&" Holidays" and it displays: 12 Holidays exactly what I want... the 0 was my citeria. thanks! & was pretty much the function I was looking for. I just had my syntax wrong when I tried to put the text in the front. "Holidays...

i got it to work thanks. i needed something like this =countif(D1:D10,"0")&" Days

it worked great, thanks! is there a way to customize what fields would be display? it's displaying everything now and won't let me remove or edit anything.

Sorry, I don't mean the formula itself, but I need to display the result of the formula, and some text after that. sounds simple, but i don't know where to find the correct syntax.

My version of Access is 2002, maybe that's why it keeps crashing?

I am trying to display a formula with text in the same cell, is that possible? i tried concatenate but that only joins text. i can't do it in the next cell, as the table format won't look right.

ok, so the sql is already working, but there are a few names sneaking by, when repeating characters in first/last names overlap. see below examples: Last Name First Name Brassard Brett McLellan Brad Onciul Brad Ontkean Braedon Brown Christopher Brochu Chelsey McElroy Chris Skrypnuk Dan Skelly...

i was able to narrow it to SELECT SeasonalHireTable.[Last Name], SeasonalHireTable.[First Name], SeasonalHireTable.[Middle Initial], SeasonalHireTable.[Applicant ID] FROM SeasonalHireTable WHERE (((Left([First Name],2)) In (SELECT Left([First Name],2) FROM [SeasonalHireTable] As Tmp GROUP BY...

thanks for the reply, i'm still trying it out. I'm fairly new with access. The only thing I know so far is very simple citeria. The code you gave me, do i need to write that as a new macro? or can i put it under my citeria in query? My feilds are First Name and Last Name and my table is called...

How can I display results if just the first 2 characters of both these fields: First name, Last name match? eg. 1. cathy mcdonald 2. carmen mcfarlane will be displayed as duplicates.