Search results for query: *

Been away awhile, working in finance now (not as much call for database design, until now!) I've been given survey responses in Excel in the following format: DataID recordid Q47_1 Q1 Q2 Q3 Q4 1 6347684356653 4356653 5 4 3 2 2 6347682756353 2756353 5 4 4 4 3 6347682233 2233 1 2 3 4 4...

Clinging to Access 2003... I have 2 versions of this 'sorta' working... SELECT qryGroupedQuantities.strMaterial, qryGroupedQuantities.strSoldToPartyNum, qryGroupedQuantities.strSoldToPartyName, qryGroupedQuantities.SumOfCalcQuantity, (SELECT Count(*) AS HowMany FROM qryGroupedQuantities AS...

Perhaps one (or more) of you can mediate here... There has been a debate raging around here regarding the use and meaning of comparison operators. For instance, there are some who say that using 'NOT <=' is not the same as using '>' (and that the inverse is also not true). There are those who...

edited... Let them hate - so long as they fear... Lucius Accius

I've been digging through search results and think this should work... but it doesn't. SELECT A.ID, A.First_Name, A.Last_Name, A.Address_1, A.Address_2, A.Address_3, A.City, A.State, A.Zip, A.Phone, A.Terr_Name, A.[PRS Mkt Vol Decile], A.Special, A.HomeCareRepID, A.ManagerID FROM...

I currently have each sales rep's information in separate tabs, each of which is named a rep's last name. Now, I'd like to set up a single summary sheet. Is there a way to use the cell containing the rep's name in the formulas to substitute for the tab name? ex: =A1!B6 where A1 is the cell in...

Cannot get into bios, cannot boot from cd... F2 gives me "please wait..." then it just reboots again. F10 shows me the memory check progress, the mouse and keyboard is recognized, etc - then it reboots. If I press F2 while on this screen, the message is "entering setup..." then it reboots. It...

Since adding the following, the person I've been trying to help with a database has been getting an error when trying to convert to 2007. It's 3356, telling her she is trying to open a database which is opened exclusively... I've run a decompile, used the Compile selection on the Debug menu...

... Completed 2nd interview - no mention of salary yet? arrrgh!! Not sure how to react to this one. The job has been reposted. Guess this is just one more that Im not good enough for. [sadeyes] Tried 10 times to compose an email to the contact person, to let her know I know it's still...

First interview was with the person I'd be working with most of the time. Second was actually a series of shorter (approx 45 minutes) interviews 2 with upper management and 3 with various VPs (one of these by phone to another location) It's been a number of years since I've gone through the...

Does anyone have suggestions for logo design software selection? Particularly, for designing logos suitable for online use and on marketing materials. Let them hate - so long as they fear... Lucius Accius

I have a DB with tblCustomers and tblMVisited. (I added tblMVisited - the original designer had added fields to tblCustomers as needed. These values have been copied to tblCustomers with the CustID) For each tblCustomers.CustID there are 0-3 (or more) entries in tblMVisited. For each...

The IS Director has tasked me with training a fellow worker who already has some basic Access training under her belt. There will be a reference book provided for her by the company and I need to make a recommendation. So far, I'm pretty sure I've narrowed it down to these: MS Access 2003...

Have the following: PropID EventDate EvtType 5 10/4/2005 CMA 5 10/10/2005 LDM 5 3/17/2006 LDR 5 3/17/2006 SIR 5 3/30/2006 AVL 5 3/30/2006 SIR 5 4/24/2006 PND_HC 5 6/26/2006 CLS How do I (or is it even possible to do...) calculate the number of days between each event? How do I...

Have the following as part of a larger query (Ive added line breaks to make it easier to read): (CASE WHEN DATEDIFF(WEEK, (SELECT AMDEVENTS1.CompletionTime FROM AMDEVENTS AMDEVENTS1 WHERE AMDEVENTS.EvRefNum = AMDEVENTS1.EvRefNum AND AMDEVENTS1.EvtType = 'PreConstr' AND...

CPCompCt: Count([ConstructionDateCompleted]) results in 29, right aligned in the cell CPCompCt: nz(Count([ConstructionDateCompleted]),0) results in 29 as well, however it's now left aligned in the cell. is this indicating the result is now being treated as text? Let them hate - so long as...

I am trying to select fields from multiple records in the same table as a single line. The table (SQL) has separate records for each task for each job. Im lost on how to have the 4 separate entries appear as the same "record". My latest attempt (not functioning...) is the following: SELECT...

have the following: function linkDisplay() { var links = new Array(); links[0]="View Your Report"; links[1]="Home Page"; links[2]="Why Choose A2Z?"; links[3]="Services"; links[4]="View Sample Report"; links[5]="FAQ"; links[6]="Standards of Practice"...

Acrobat 6 standard Have a 2003 Word document which I'd like to convert to PDF. Tried a few different ways, however, every time the resulting entire PDF (pictures and all) is coming out as black & white with a few exceptions - callouts I had drawn on some of the inserted pictures are still...

and unfortunately it's sporadic, there's no error message, and I haven't been able to duplicate it. Database is split FE/BE - 2 Operators are using a shared FE file (not my choice) As calls come in, operators are adding notes about the call to an existing record's memo field. Occassionally, the...