Recent content by jon98548

I have a description field that starts with a basic name of an item followed by a comma and the more descriptive text. I would like to return everything before the comma and truncate the rest. I can do this in Excel with: =LEFT(A1,FIND(",",A1)-1) but Access doesn't recognize Find. Thanks...

All you need to do is format the date you have. Do a simple query on that data. Make a new field called: NewDate: Format([OldDate],"ddmmmyyyy") That should do it.

Thanks, Jerry and Rich. Here is what I ended up with. Jerry, I was missing that bit of code in the last line to force in the "empty" months. TRANSFORM First(qryMonthCount.Units) AS FirstOfUnits SELECT qryMonthCount.AssessmentYear, qryMonthCount.AssessYear, qryMonthCount.WorkUnits...

Ok, I've given this a try, but I end up in the same dilemma. Months where nothing was done, don't come out in the query.

Hi, all. I really don't know where to start with this. I have a database I use to check compliance with certain items. An auditor goes to a division and asks some questions, taken from the database, and enters a compliance level for that question. When the auditor enters a response to a...

fly his kite

was the newcomer

bright and fair.

said the old

when rubbing sticks

So they rubbed

tasted like candy

biscuits and gravy,

hanging fruit. Having (Just came across this!)

Larry, look at the second post here by jfgambit. I think it might suit your needs. I'm also looking for another one I used once.Search form