Replacing Tables in a Query
Thu, 28 Aug 2008 20:07:00 -0700
I analyze general New York state information and to do so I have a table for
that state. I also have thousands of queries dedicated to that state. Now I
want to analyze another state. So I set up a new table for the new state. For
each individual query I have done a "Save As" of the New York state query for
...
|
Access 2007 queries will not open in design view
Thu, 28 Aug 2008 18:38:07 -0700
Yes, I have tried the suggestions in thread "Can't access design view". I
get the error message (" is not a valid name. Make sure that it does not
include invalid
characters or punctuation and that it is not too long. ) I believe my
queries have open in design view in 2007 without problems in the past. All ...
|
Totals Query Help
Thu, 28 Aug 2008 18:12:02 -0700
I have a query with the following fields:
EmployeeID
DepartmentName
WeeksService: (CalcWeeks([DateStart],[DateEnd]))
I am trying to sum the total weeks that an employee has worked in each
Department. Example: An employee works 52 weeks in Sales, 52 weeks in
Purchasing, and then goes back to Sales where ...
|
Date order in a crosstab query
Thu, 28 Aug 2008 17:32:01 -0700
Hello all,
I am trying to create a crosstab query to look like the following:
Order# Total Hours Jan 07 Feb 07 Mar 07
1234 175 25 50 100
What I am getting is:
Order# Total Hours Jan 06 Jan 07 Jan 08 Jul 06 Jul 07 Jul 08
1234 1 ...
|
Multiple Median Calculation
Thu, 28 Aug 2008 16:43:00 -0700
Hello,
I am a novice to Access. I have been reviewing some of the Q&A threads and I
am not sure if they apply to my question. I am trying to calculate the median
of several categories as follows:
Class Name Rate Age MedianRate MedianAge
1 A $20 21 $17.50 19.5
1 B $15 18 $17.50 19.5
2 C $17 19 $17.00 ...
|
Show Zeros in Query
Thu, 28 Aug 2008 14:44:01 -0700
I did a google search and didn't get an answer to my question. Also, did a
search in the Queries group of the Access DG, still didn't find a SOLUTION.
My question is as follows... How can I display all records, even those that
are zero?
My SQL is here:
SELECT tblRegion.SalesRegion, Sum(tblRegion.Q308) A ...
|
Unique Query Dilema
Thu, 28 Aug 2008 17:40:36 -0400
I have a query that I have been asked to create that is very foreign to me
and I would almost think to be impossible. However, I throw this out here
to anyone that might know if it as some of the craziest things have been
shown to be possible. So, without further delay, here's my problem.
I have a query o ...
|
|
|
Setting program access and defaults
Thu, 28 Aug 2008 12:22:05 -0700
Windows XP Home Edition.
When I try to set the program access and defaults to "Microsoft Windows" it
refuses to do so and puts me back into "Custom".
I am the only user - ever - on this machine.
Can anyone out there help me?
Many thanks. ...
|
Iif not working
Thu, 28 Aug 2008 10:56:09 -0700
Hi, I'm new here. But this is driving me crazy! What is wrong with this IIF
statement? Sometimes, if I try to use "|" because of errors with a "," and
it works. But then I go back into design, Access does not recognize it. I
change the "|" back to "," and it still tells me it's an invalid character.
A ...
|
Please help a new user out...
Thu, 28 Aug 2008 09:53:04 -0700
I have a field titled Decision. There are serveral options writting under
decision. How do I run a query where everything but "TBD" , "In-Progress",
and "Pass" will print? THANKS. ...
|
