Re: 6 Months Due

On Tue, 30 Jan 2007 18:37:00 -0800, blink
<blink@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

"John Vinson" wrote:
BETWEEN DateSerial(Year(Date()), Month(Date()), 1) AND
DateSerial(Year(Date()), Month(Date()) + 1, 0)

I have added the code to the "DateAdd("m", 6, [Date Start])" and it is very
close to what I am looking for. My result is a -1 for the true fields and 0
for false. How would you filter it to show only the true results? In other
words I have 'DateEntry' + 6 months and expires this month?

I'm sorry, you haven't mentioned any yes/no fields before, and I have
no idea how your table is structured.

You can put a criterion of either True or -1 on a yes/no field in a
query to select records where the field is true.

Could you open your query in SQL view and copy and paste the SQL to a
message here? Perhps it would also help to describe the structure of
your table.

John W. Vinson[MVP]
.

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: set first record to zero in a calculated field
    ... John, after playing around with the FOrmat comand, I think I managed to get ... I resolved it in my previous query by using the Format command in the SQL, ... Center for Health Program Development and Management ...
    (microsoft.public.access.queries)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Import and append a column from excel to an existing db
    ... John W. Vinson writes ... OK Here's the SQL for the update version of the query, ...
    (microsoft.public.access.gettingstarted)
  • Re: Query for Left(String,5) - Access 2007
    ... Hi John, wanted you and Klatuu know I solved my problem. ... The Query design view actually creates SQL. ...
    (microsoft.public.access.queries)