Tara-1044200 (4/29/2012)

---

actaully there isnt any table in real, i am just trying to use len(column)-12 which seems to be not working but it works for len(column)-8 so i was thinking...

kirkm 55368 (4/29/2012)

---

Thanks for the response, Phil.

I see now using the actual field and table names would have been better.

I'm getting :-

Syntax error (missing operator) in query expression "tblBritburn' Table'.

And...

.Netter (4/29/2012)

---

Hi All,

I have an online exam which inserts the user answers in to a table then works out how many correct answers they have got which is working fine,...

kirkm 55368 (4/29/2012)

---

Hi,

I want to build a query on Multiple Tables... there's 3 tables in total. If they all had a 'Field1'

how could I output all fields (in all 3...

I haven't tried to understand your SELECT query and, as you did not expand on what you meant by "not working", I had to guess that there was a syntax...

Mikalina (4/29/2012)

---

Hello,

this is rather urgent..

I have a population of people who got less than 3 coupons, and i need to insert one specific coupon to that population (the one that...

Bill Nicolich (4/27/2012)

---

Before I go and build the schema, I'd like to compare notes with whomever has either seen this done before or has done this before.

I'm looking to create...

Thank you very much John. One coffee later and I was just about to post back that I had worked it out along the same lines.

I think that this is what the OP is after - not some complex forensic solution. Time will tell.

Why are you doing this?

deebabat (4/25/2012)

---

when i ran the select count (*) statement of the where clause, i got this error message: Msg 8114, Level 16, State 5, Line 1

Error converting data type varchar...

Any reason why you wouldn't shrink it? There might be a...

david.alcock (4/25/2012)

---

Just wanted to ask, if a log file has got too big and then subsequently a log backup has been taken, the recovery mode switched to simple but the...

You need to remember that SQL Server is a server tool and MS Access primarily a client tool.

It sounds like you will be able to get a long way towards...

Seriously? How about adding "rows > 1000" (assuming you...