Here's my SQL statement
SELECT SV.EmpID, SV.PSV, ([PSV]+(Select SUM(PSV) From SV Where Employees.Boss = SV.EmpID)) AS GSV
FROM Employees, SV
GROUP BY SV.EmpID, SV.PSV;
Here's what I have...
A table of Employees (EMP) with a field that identifies who their Boss (BOSS) is. A table of Sales Volume (SV) conducted for each Employee.
What I need to do...
Construct a query to give me a total of their Personal Sales Volume AND the Group Sales Volume including all...
Hey all been awhile since I've been here so here goes...
I would like to set up data so it'll end up like this
101
102
103
104
105------109
106 111
107 114------115
108 116 117
110
112------118------120
113 119
Basically, it's the old boss employee thing --...
Tom and Ed
I appreciate your suggestions. To answer your question Tom...I'll be using Access2K. Additionally, I'd like to say that I like the idea of not storing stuff you don't immediately require. As for the sys-adjust field, that's a great idea. I've always wondered what the best solution...
I would like to design a db to track hours spent on projects. The one question I have is how best to design it so that staff cannot have multiple "timecards" for a period or more importantly overlapping times. Any suggestions would be helpful.
Basically it's a list of who's worked on...
I first must say that your links to actual views of the output and the pdf are wonderful.
I know dealing with pdf forms is a time saver...but when they are created by other people and you have problems with them, they can be a headache.
Have you check to see if the suspect font, which I...
This may or may not be of any help...But, I've done this utilizing a pre-printed form and a simple Access Database. Scanned the form and included it in an Access Report as a View Only object. I could then choose which records I wanted to populate the form. On print preview, the data appears...
Hmmmm...can you specify what printer you are using?
Various things come to the top of my head...Most of which are based on determining if the problem lies with the file(s) or the printer (or printer drivers).
[ul]Does this occur when printing all pdf's or just certains ones?
Have you tried...
I really don't want to get in the middle of this but I have to ...
Attrofy, I'll agree that you could use either (SQL/Query) to get proper results as long as data maintains proper form.
Your question - how do you keep your end users from having to click several buttons ...
Manipulate...
I'm not really sure if you problem lies with the application, it's settings, or something else.
But, check out Adobe's Knowledgebase Document #326346 (Unable to Print to Distiller Printer 5.x for Windows) at www.adobe.com/support/techdocs/2adaa.html ... or search for it by number on their...
Well, first...remember one reason why pdf's are useful.
The retention of formatting (fonts, etc.) whether or not the user/viewer has them or not.
Initial questions come to mind though...
1.Which versions of viewers are you using on each machine.
2.How was the pdf created and what options...
Ok, here's everything I can find or think of...Adobe and Microsoft both appear to indicate that the plug-ins Acrobat Reader 5.0 installs may not be read properly from the registry. It also appears that they suggest re-installing the Adibe software to ensure that the plug-ins are correctly...
My question would be...
First, does this happen with every pdf file, every pdf from a particular source, or with just one file.
Second, what version of Reader and Internet Explorer are you using.
Third, what Operating System are you using.
Forth, have you searched the Adobe Support...
I can't think of a way off the top of my head, but if I get a chance I look for ways to completly eliminate fields in the tab order.
In the mean time, some things I can offer is to force the checkbox fields to the end of the tab order. This would make the user believe that it's easier to hit...
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.