Re: Problems with APPEND

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sietse Wijnker (sietse.wijnker_at_ATsw-software.nl)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 18:13:05 +0200

Hi Cindy,

I knew it wasn't a filtered table based on the calculated field and the
GROUP BY clause.
It was just to make a point, and make N! Xau aware of other possible
cavefalls.

Regards,
Sietse Wijnker

Relevant Pages

  • Re: COUNT(*) in WHERE clause
    ... > My question is in regards to the final line in the where clause: ... > declare @field_count int ... > inner join filexmetafield fmf on f.fileid = fmf.fileid ...
    (microsoft.public.sqlserver.programming)
  • Re: Calculated query field will not filter
    ... Repeat the expression in the WHERE clause: JET doesn't recognise the alias there. ... I have a query of addresses where I would like to filter on even door numbers. ... the numbers only as a calculated field called, ...
    (microsoft.public.access.queries)
  • Re: Can I get rid off the blank item in drop down list?
    ... >>> Regards, ... >> Please only reply to this newsgroup. ... >> I do not reply to personal email. ... Yeah, I just added the where clause at the end, but I should have ...
    (microsoft.public.access.forms)
  • Re: Query with 2 parameters asks for 3
    ... Your problem is that you cannot refer to the calculated field by name in the where clause. ... FROM Customer ... BigName comes up as a parameter. ...
    (microsoft.public.access.queries)
  • Re: Problem with attached view
    ... The view haven't clause where, it's a simply select * from the table ... > create view dbo. ... >> the trace give: ...
    (microsoft.public.sqlserver.clients)