Anyone Going To QCon? March 2008

Jan 25, 2008

http://qcon.infoq.com/london/about/

SELECT * WHERE Month = March

Mar 5, 2007

Hi,

I've got a news table in an Access database, with the following fields/datatypes:

=====
tblNews
=====
news_id (auto number)
news_headline (text field)
news_article (memo field)
news_date (date field)

I have a select statement from an ASP page like so:

SELECT * FROM tblNews ORDER BY news_date DESC;

What I need to be able to do, is to select all news articles from a particular year or all articles from a particular month, so the above statement needs to be something like this:

SELECT * FROM tblNews WHERE news_date = 'March' ORDER BY news_date DESC;

Clearly the above code doesn't work, since I'm passing a string into a date field, but this is the kind of thing I need to achieve.

Can this be done, and if so, how?

Thanks for any pointers...

View 4 Replies View Related

Linking Sage 2008 To Access 2007

Mar 17, 2008

HI All.

I am having trouble with filtering and linkoing data from SAGE to my access database where I want to produce some clever reports.

I have posted on the sage forum, but though I might get more help here, as I have in the past.

Here is my problem.

I am trying to create a report in Acces 2007 using the sales_order table.

If I try to read orders where despatch_status = "part" it's fine, but if I try to read orders where despatch_status <>"complete" I get the error message odbc call failed syntax error: Invalid filter in WHERE clause (#0).

If I try to use the criteria = "part" or = "complete" I only get those records that fit the second criteria.

I am also having trouble linking tables where. If I use an inner join it's fine, but if I try to use a left join (which I need to to not miss any records) It fails with invalid outer join specification (#0).

Anybody had this problem with SAGE? Any ideas would be greatfully received.

Thanks.

Sue

View 14 Replies View Related