bikefixxer
Last Activity: Dec 20 '09, 06:35 AM
Joined: Sep 7 '07
Location:
-
That makes sense and that also worked!! Thank you very much for your help! -
Hi. The query returned the same values as it has before, so still no dice.
However, I found that by entering some days into the hours table for the employee and just entering zero hours he now shows up. Normally there's no information there at all, which is causing the problem, but if I put in those earlier dates all seems to be well. So, it's not the ideal solution but it works for now. If you want to keep trying to help me out...Leave a comment:
-
Sorry about not being clear on that. I've pasted the new code below. The '<> False' thing didn't show up at first. I noticed it when I went into the design view after changing the query. After I changed it to true in the design view is when it started showing up in the sql query view. Thanks again for your help!!
...Code:SELECT Employees.ID, Employees.LastName, Employees.FirstName, Sum([Overtime Hours Query].TotalOTHoursWk) AS TotalOTHoursPP
Leave a comment:
-
Stewart,
Thanks for the reply. What you're saying totally makes sense. I made the improvements though and there is no change to the result. In the design view I noticed that it said "< > False" under criteria. I changed that to true and then the new employee showed up but it also added up everyone else's overtime hours from the beginning. Any other ideas?
Thanks for the help! I appreciate it.Leave a comment:
-
How to show records even if the value is null
I'm a beginner with Access and am using the 2007 version on XP. I've created a database that keeps track of employee hours where I work. Everything has worked fine until we recently hired someone new. I have a subquery that checks for the amount of overtime hours someone has between a specified date range, and the new employee doesn't show up at all. I'm thinking it's because no hours information has been entered in because he was new, so the... -
Worked like a champ! Thank you very much!!
On a side note, I don't have any formal SQL training or anything. All that I've learned has been through online tutorials and trial and error. The tutorials that I've found don't mention the convert function at all. Any good websites anyone can suggest that would talk more about that particular aspect? Thanks again!Leave a comment:
-
Changing decimal places in a query
Hello,
I've written a query that works well and that gives me a line by line discount percentage of each item. The part that is annoying me is that instead of giving me a whole number, like 25, it gives me 25.00. Is there a way to change this? I've attached the query so you have an idea of what I'm doing. Thanks for the help!
...Code:SELECT Products.[Store UPC] AS 'SKU', Products.UPC, SalesItems.Description, SalesItems.Price,
-
I had to negate it and change vendorproducts. id to vendorproducts. productid but then it worked perfectly! Thank you very much!!! I couldn't have done it without the help.Leave a comment:
-
How to write a query that selects all except...
Alright, I've been trying to figure this out for over an hour now and have been searching all over google but can't find anything, so I'm hoping someone here can help me out.
First, a description of the database I'm working with. It's a retail store that has multiple tables but the ones I'm dealing with are the Products table and the VendorProducts table. A product can be associated with multiple vendor products since a product can be obtained...
No activity results to display
Leave a comment: