|
|
Totals Won't Count Nulls by
jgraves
My Access Table has a columns containing various values, including null. See
below.
Error Code
------------
A
A
B
C
(Null)
|
|
1 |
148 |
|
|
iif function syntax problem by
angie
i have the following expression in the criteria row of my query and it
returns no records. can you help me with the syntax?
IIf(!! Is
Null,, Like "*" &
!!...
|
|
5 |
176 |
|
|
Crosstab query question by
CR
I have a question about using crosstab query of course maybe there is another
way and any help would be great appreciated. The problem is that the
crosstab...
|
|
2 |
134 |
|
|
|
|
4 |
98 |
|
|
|
|
7 |
201 |
|
|
Link multiple excel files at one time by
JE
I have about 60 excel files that I want to link in an Access database. Other
than manually link each file individually, is it possible to link all at one...
|
January 7th, 2010 01:11 PM
by JE
|
5 |
119 |
|
|
|
|
14 |
248 |
|
|
Date query from datasheet in subform by
Gamefewel
I have a database of diabetic patients. I have a form that has all the
patient info, like name, address, etc. I think have a subform that is a
datasheet...
|
|
1 |
126 |
|
|
One prompt for Four Queries by
Wendelin
I have four queries that are used as subreports in a summary report.
All four queries use the same prompt (for the same field):
How do I get only one...
|
January 6th, 2010 09:15 PM
by SteveD
|
3 |
188 |
|
|
|
|
4 |
144 |
|
|
Query 3 years by
woods1119
I am trying to query from a query to find how many people have a duration of
3yrs.
Query#1 (qrySeen2008) has:
ingPtID
LastOfdtmVisitDate
I need to find...
|
|
1 |
99 |
|
|
query a table and subform by
Icy
Help,
I have 3 tables
1. Printer table: printerID, ModelID, SerialNum, MACAdd
2. Toner table: TonerID, ModelID, PartName
3. Invoice table: InvoiceID, Date,...
|
January 6th, 2010 06:34 PM
by Icy
|
0 |
85 |
|
|
|
January 6th, 2010 05:26 PM
by Steve
|
2 |
162 |
|
|
Expression builder in a select query by
Krish
I want to determine the qualifying % of commission based on Margin $ as follows
74.99 0.00%
75 and 149.99 8%
150 and 249.99 10%
25 and 349.99 ...
|
|
2 |
106 |
|
|
Parameter Query Lookup by
Denise
When a prompt asks for the "Company Name", I want to be able to select from a
list rather than type in the name.
Any suggestions? What do I put in the...
|
|
2 |
190 |
|
|
formula by
Revned
Hi,
i have a select query with the following SQL
SELECT tblOrder.CustomerID, & " " & AS Name,
tblCustomer.SchedDelivery, tblOrder.OrderQty,...
|
January 6th, 2010 06:38 AM
by Revned
|
6 |
137 |
|
|
report format by
subs
ocity ozip dcity dzip consignee
a b c d clo
e f c d clo
l k c d clo
t ...
|
|
1 |
147 |
|
|
Max plus additional field by
Lorna_Jane[_2_]
Hello,
I've got 3 tables in a many to many relationship:
Table 1: Catchments
(AllCSL)
Table 2: Regions
(ProvincialEcoDistrictAttributes)
Table 3: Lookup table...
|
|
1 |
140 |
|
|
Group By, Max, many to many by
Lorna_Jane[_2_]
I tried posting this before, but it hasn't shown up, sorry if this ends up
being a duplicate.
I have the following tables and fields:
Catchments...
|
|
1 |
183 |
|
|
|
|
2 |
123 |