formula need a fix. HELP!
Thu, 18 Dec 2008 10:55:01 -0800
I have a table with 3 columns:
Review Date
STDID
Answers
I want to run a query to calculate the % of Y/ Y+N for all the answers of a
specific standard (STDID) for a specific review date. Ignore N/A in the
denominator if the answer is N/A.
For example:
I want a query to calculate the percent Y/Y+N o ...
|
Trying to resolve with an IF Statement
Thu, 18 Dec 2008 10:47:01 -0800
I have a table that is an auto-number field that creates sequential ticket #'s.
During testing I created several records in my table that were not real so I
deleted from the table.
The result is gaps between #'s.
I want to query on specific ticket #'s and if they do not exist, return a
[Not Found] dialo ...
|
Trying to resolve with IF Statement
Thu, 18 Dec 2008 10:36:10 -0800
--
J ...
|
Group a range of numbers
Thu, 18 Dec 2008 09:50:01 -0800
Is there a way to group a range of numbers?
Acct Number
123 3606074087
123 3606074088
123 3606074090
123 3606074091
456 3608777353
456 3608777354
456 3608777395
Result:
123 3606074087 thru 3606074088
123 3606074090 thru 3606074091
456 3608777353 thru 3608777354
456 3608777395
l ...
|
Parameter in query
Thu, 18 Dec 2008 09:39:01 -0800
Is it possible when entering parameters in a query to have the dialog box
open as a list/combo box instead of having place in a form and if so how? ...
|
Find non sequential numbers
Thu, 18 Dec 2008 09:32:01 -0800
Is there a way to find numbers that are missing from a group? For instance,
find numbers that don't follow sequence. We have a receipts database to
track sales of a fundraising item. I need to figure out which receipts are
missing from the group so that we know whether or not there are outstanding
receipt ...
|
Imbedded Single Quote
Thu, 18 Dec 2008 17:18:32 GMT
I have a query where I am trying to select data based on a manager's name.
One particular manager has a single quote at the end of her first name
(Renee'). Since the database that I am querying contains the name with the
quote in it, how do I go about selecting the information for that manager?
I am using A ...
|
|
|
Need to optimize query...
Thu, 18 Dec 2008 08:52:37 -0800 (PST)
I have the following table and query (image URL follows) that
accomplishes what I need it to, i.e. return all records but the
preselected ones: http://www.dslextreme.com/users/madforplaid/Inovant_Table_and_Query.jpg
However, with larger data sets how can I rewrite it in a simpler
manner to optimize the query ...
|
How data can be consolidated in hierarchical/parent-child/Tree for
Thu, 18 Dec 2008 00:38:01 -0800
In the following example, each level has its own data (stand alone). And I
want to know, how can I get aggregate (shown under Aggregate) at each level
which is equal to its own date plus the aggregated date of its immediate
children:
Levels:
Grand Parent 1000
|
Parent 1100
|
Chil ...
|
run sum
Wed, 17 Dec 2008 21:52:00 -0800
i have a table call t_time_sheet. i want ot make a query that is based on
this table to do a run sum.
example,
ID Part Date Qty
1 A 1/1/09 100
2 A 2/1/09 100
3 B 1/1/09 100 ...
|
