Thanks for the quick response, but it still dropped a vehicle that is active but no transactions. Your statement about using transactions in my WHERE clause defeating my LEFT JOIN, makes sense to me so I tried this
WHERE (((Vehicle.Status_ID)=1)) OR (((Transactions.TransactionDate) Between...
I am new to Access and I am in need of help.
I have an automobile ledger that I am trying to create in access which
keeps track of Gallons, Gas & Oil, Tires, Repairs....etc. My problem
is that the record for the Automobile is dropping if there is no
transactions on that particular...
I can not thank you enough... I have read...search...tried one thing after another for several days trying to get this.... As I said....Very new user and trying to learn.
Once Again thank you that is exactly what I needed.
Be patient with me as I am a new, very inexperienced user of Access 2000 and my question my be very simply to solve. However, I am an Accountant that has made a database to track the Market Values of our employees 401k’s. I am trying to use a query to Pull the Contract#, Date, MValue...
This is probably a simple question, but after I do a shutdown -r on an AIX RS6000, I get the following message on my terminal
Suspending Desktop Login....
Press [Enter] for a login prompt
Log in. Desktop Login will resume shortly after you logout.
This scrolls continually without end.
If...
I am running the following script for our dailybackup and and having a problem with the tape rewinding itself when it reaches the end and writing over itself. The command tctl -f /dev/rmt0 rewoffl has been placed in the script, but the tape is still rewinding instead of ejecting and asking for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.