Re: Limit query to one result

Tech-Archive recommends: Fix windows errors by optimizing your registry

Stickman64 wrote:
Hi and first let me say I am a new user so thanks in advance for your
patience and help.

I am trying to run a query that will list the next available meeting
for each project. So I am using the >Now() in the criteria box. I
want just one entry per project. I would also like it if a project
doesn't have anything scheduled, it would pull that up and put TBD in
the meeting date.

What I end up getting is all future meetings for each program, with
multiple entries and can't figure out how to force it to output just
the next instance. Plus, if a project doesn't have a date for their
next event, it doesn't show at all.

Any help would be appreciated.
Please help us out with a description of your table structure. Also, it
never hurts to provide a few rows of sample data (relevant fields only,
and just enough rows to illustrate the problem) along with the desired
results given the sample data.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • RE: Outlook Meeting Invites
    ... Thank you for posting in the SBS newsgroup. ... since this issue occurs due to the user A send a Meeting ... Steps taken to remove the Delegate Rule. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Outlook Meeting Invites
    ... Microsoft CSS Online Newsgroup Support ... >Thread-Topic: Outlook Meeting Invites ... Using MFCMapi delete the delegate rule and add additional delegates ...
    (microsoft.public.windows.server.sbs)
  • RE: Outlook Meeting Invites
    ... > Thank you for posting in the SBS newsgroup. ... since this issue occurs due to the user A send a Meeting ... Using MFCMapi delete the delegate rule and add additional delegates back ... Double-click the Default Store for the user's mailbox (if there are ...
    (microsoft.public.windows.server.sbs)
  • Re: Limit query to one result
    ... So I assume you have to do this in SQL, not in the query wizard. ... say the meeting has passed and the next meeting is ... Access MVP 2002-2005, 2007-2008 ... never hurts to provide a few rows of sample data (relevant fields only, ...
    (microsoft.public.access.queries)
  • Re: Limit query to one result
    ... Save that query and now open your programs table and join that to the saved query. ... SELECT Programs.Program, NextMeeting ... I am trying to run a query that will list the next available meeting ... never hurts to provide a few rows of sample data (relevant fields only, ...
    (microsoft.public.access.queries)