HELP! unwanted fields

Randy Harris and Bob Quintal have tried to help me with my data base report
problem, for which I thank them.

The suggestions they gave me still do not seem to work and I am still
getting false data showing.

Data base is of customers who book a car to pick them up on a certain date
to take them to an Airport.
They would also book a car for thier return on a date in the future.

I want to input a DATE to create a report showing down the left column,

CustomerID, OutwardTime, OutDate,

down the right column,

CustomerID, InwardTime, InDate.

So if I put in tomorrows DATE, I could see the list of customers going out
and customers coming in for that day.

What I am getting for each customer is the outgoing data and the future
incoming data.

I just want to see if the same car dropping off a customer could possibly
pickup another one arriving.

I have really tried to make the queries work properly but I still get double
data.



TIA,
Gordon.



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 777 spam emails to date.
Paying users do not have this message in their emails.
Try www.SPAMfighter.com for free now!


.

Relevant Pages

  • Re: VW Losses in North America
    ... up to about 2-6 years maximum, for enough customers to realize they ... new line up to restore sagging sales.. ... Because a rusty car in your, ... their cars, feel duped, and of course, become jaded to the clever marketing ...
    (rec.autos.makers.vw.watercooled)
  • Re: VW Losses in North America
    ... traditional marketing hype......Especially VWs.. ... > long, because their customers figured out, by owning them, that they are ... Because a rusty car in your, ... > with a new lineup, and starts their Very clever marketing campaigns, to ...
    (rec.autos.makers.vw.watercooled)
  • Re: Microsoft and trust
    ... for my Apps - and I use a whole lot of WinAPIs in them. ... regarding the type of Apps and customers *they* have. ... Try to compare, what we say about the ... And this car is not designed as a pure plugin - it is a hybrid ...
    (microsoft.public.vb.general.discussion)
  • Re: VW Losses in North America
    ... Anyone can find rust somewhere, on any car, anywhere.. ... DECIDED to raise the timing belt interval to get them out of warranty, ... those customers will not buy another one... ...
    (rec.autos.makers.vw.watercooled)
  • Re: OT: Car Sales
    ... Most customers would not bother to notice that the wrong wheels were ... on the car, and if they did, they would just delete the option ... If I didn't have to work nights and weekends, and had the sales manager finally been fired for his unethical and illegal behavior, I'd probably still be doing it. ... In fact, I told the dealership owner that if he ever decided to get rid of his sleaze-bag sales manager, to call me because I might be interested in that job. ...
    (rec.arts.disney.parks)
Loading