User Profile

Collapse

Profile Sidebar

Collapse
dontfwithchuck
dontfwithchuck
Last Activity: Jan 18 '09, 04:32 PM
Joined: Jan 18 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • dontfwithchuck
    replied to union query, different WHERE, same table
    in Access
    I've solved it!
    The proper code should be:
    Code:
    SELECT Title, Rating, Date
FROM Movies
WHERE (((Movies.Genre)="Drama")) AND (((Movies.Date) Is Not Null))
UNION ALL SELECT Title, Rating, Date
From Movies
WHERE (((Movies.Genre)="Drama")) AND (((Movies.Date) Is Null))
ORDER BY Date DESC , Title;
    It's just a simple matter to format my report now, and...
    See more | Go to post

      Leave a comment:

    • dontfwithchuck
      started a topic union query, different WHERE, same table
      in Access

      union query, different WHERE, same table

      Hi, this is my first post.
      I use Access XP.

      I have a single table called Movies containing the following fields:
      ID, Title, Genre, Rating, Location, Date

      I want a datasheet with the Titles that have a date sorted in Descending order by date, then the Titles that don't have a date sorted by Title in Ascending order.

      I have this:
      Code:
      SELECT [Title] & " " & "(" & [Rating]
      ...
      See more | Go to post
      Last edited by pbmods; Jan 18 '09, 03:03 PM. Reason: Added CODE tags.
      No activity results to display
      Show More
      Working...