Search results

Actually the above arguments would result in records for only half the month as the other half would be in the future (silly me) so this is what I have but it still doesn't work properly. I get all results for this month but no results for later days of last month: SELECT * FROM articles WHERE...

I would have missed articles if that had worked out but here was the correct format: SELECT * FROM articles WHERE ((([ID] Mod 2)=True)) AND articledate < (date() + 14) AND articledate > (date() - 14) And for the Evens: SELECT * FROM articles WHERE ((([ID] Mod 2)=False)) AND articledate <...

Ok, here is my next task... I want the results to display only a months worth of articles, say half of the month for the odds and half for the evens, here is my unsuccessful attempt: SELECT * FROM articles WHERE ((([ID] Mod 2)=True)) AND articledate < (date() + 14) AND articledate > date()...

Ok, found this too, SELECT * FROM articles WHERE ((([ID] Mod 2)=True)) AND articledate < date() SELECT * FROM articles WHERE ((([ID] Mod 2)=False)) AND articledate > date()

What I would like to do now is add an AND clause where one is before the current date and the other after. I am not sure what the current date clause would be. I tried DATE and now() but neither seemed to work.. the articledate feild is designated as text, but the date is entered in short format...

Yes, I found this solution for the FP query: SELECT * FROM articles WHERE ((([ID] Mod 2)=True)) False for the evens Thank you

Is it possible to sort by weather the ID is even or odd? I want to display articles in two columns. I am pretty sure I can figure out how to write the date filters, but to get non-matching articles in each column I would need to filter some other way and by ID is the best I can think of...

Using FrontPage against Access DB... I have a search form, displays mathcing records with an update button. Update button submits data to update form, update form updates record and returns to search form. I want it to return to the record I have just edited. Here is what I have attempted...

This was my solution... SELECT * FROM SearchActive Where title LIKE '::title::%' OR author LIKE '::author::%' OR subject LIKE '::subject::%' I got it from the FrontPage 2003 Bible (Wiley) Thanks for all your help :)

Would [MyForm] be the name of the page that the form is on? I am using FrontPage DRW...

But '::title::' represents a text field in a form....

I get no results either way with that query '*title*'

SELECT * FROM SearchActive Where title LIKE '::title::' or author LIKE '::author::' or subject LIKE '::subject::' What am I doing wrong? Say I search for the word 'Time' in the title, I should expect to get all of the items with the word Time in the title, but I do not. If I search for the...

I am having a problem passing a variable to a DAP. In the simple search form, the variable (textbox) is called 'parameter' in the query it is written as [parameter]. When I open the query in access it asks me for the parameter and then it provides the appropriate results. When I submit the...

Thanks to this forum and the internet at large, I am becoming very good at developing using FP, ACCESS, and ASP. My question is, How do I create a pop-up that asks 'are you sure you want to delete/Update this record?' before the data is sent to the update form? Thanks! :) Oops! I put this...

What I need is for the addresses with similiar dates to be merged into one data field.

I need to consolidate this data so that the values for 'Address' and 'City' are merged into one field or 'cell' according to the similar dates. This is a query result from two tables, one containing the Skip (Addres/City) information and another containing the Mileage and Route data. The query...