Only updating a field once when running same query multiple times

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

Hi guys!

Kind of hard to put in a subject header for this.

Basically, I want to run a query so that it picks up which records have
today's date in a specified field. But when the query is run again, it
will not pick up that record again.

How do you go about this?

I've had a few thoughts on it: is it possible to create a query that
sets a field to true once the query has been run via an update, or
would this not work as it's separate from the select statement i.e.
access would complain that it's not a valid statement or somesuch
(apologies for not yet trying this out; I meant to, but didn't get
chance this morning, and won't have enough time to post this message
this afternoon)?

Have you guys any ideas about how best to tackle this? Your help, as
always, would be hugely appreciated!

Many thanks in advance.

Contro.

.

Relevant Pages

  • Re: Only updating a field once when running same query multiple times
    ... to implement an autonumber facility inside a report (so each report has ... > You can run a SELECT query and immediately after run an UPDATE query. ... Run the Update of the datetime field using NOW. ... >> access would complain that it's not a valid statement or somesuch ...
    (microsoft.public.access.queries)
  • Re: Only updating a field once when running same query multiple times
    ... You can run a SELECT query and immediately after run an UPDATE query. ... would be two separate queries. ... Run the Update of the datetime field using NOW. ... > access would complain that it's not a valid statement or somesuch ...
    (microsoft.public.access.queries)
  • RE: Weird Problem with a Subreport
    ... UNION ALL SELECT 1 As ListID, UNIT, Remarks, Place_Holder FROM ... I tried to add Place Holder to the Union query along with UNIT, ... Ok for the sorting i will try to explain it to you. ... Do you have a text box in the Goup Header? ...
    (microsoft.public.access.reports)
  • RE: Weird Problem with a Subreport
    ... SELECT 0 AS ListID, UNIT, Remarks, Place_Holder FROM AugustND; ... I tried to add Place Holder to the Union query along with UNIT, ... Ok for the sorting i will try to explain it to you. ... Do you have a text box in the Goup Header? ...
    (microsoft.public.access.reports)
  • Re: Remove repeat section headers
    ... I'll stick with my assessment that a union query might resolve your issue. ... 'Type' field names and data types, and desired display in your report. ... but I need to have a header for each and mess with the ...
    (microsoft.public.access.reports)