|
|
NZ Ain't Easy by
Gaetanm via AccessMonster.com
I have a subform in that I have a
in Ihave
=NZ(Sum(*))
On My MAIN Form I have a Text Box in it I have
=NZ(.!,0)
( 1 2)
|
|
16 |
166 |
|
|
Converting text to a number in query by
Stephanie
I'm having trouble with a conversion in order to get a formula to work. I
have text that = numbers. Example: G++=1, G+=2, G=3,G-=4,G--=5, etc. I
need a...
( 1 2)
|
|
16 |
420 |
|
|
sub query by
inungh
I have s ub query in my calculation field like following
Select MyMainField /6 * (Select SubField from MySubTable where SubID
=1) from MyMainTable
I got...
( 1 2)
|
August 14th, 2008 03:18 PM
by inungh
|
16 |
142 |
|
|
Create one to many join query by
deeds
I have a system table with Sales$ etc... Each customer may have 3-4
different ID's listed in this table. I want to combine all of those ID's and
produce a...
( 1 2)
|
August 21st, 2008 08:20 PM
by deeds
|
16 |
244 |
|
|
Re-run a Query Based on Previous Results by
RichUE
I would like to know whether the following can be done in one go, with
minimal input from the user, simply by entering a parameter and producing a
list of...
( 1 2)
|
|
16 |
123 |
|
|
Query Confusion by
Julius
I need help with this asap, I am running on a deadline that is almost up.
Question. I have a field name Category Code and I have the critera set
. I have...
( 1 2)
|
|
16 |
120 |
|
|
Query for a range of records by
leot
I have a table of salesmen and the contacts they make.
SELECT data.salesmen, data. , data. ,
data.locationofcontact
FROM data.salesmen
WHERE (((data. )...
( 1 2)
|
November 14th, 2008 07:23 AM
by leot
|
16 |
226 |
|
|
Changing the parameters of a form by
Amin
I have a form that has a start date, end date, and calculates the days in
between.
The control source for the calculated days is the following:...
( 1 2)
|
|
16 |
197 |
|
|
Narrowing query results by
RandieRae
I have a query that finds product information based on criteria put into a
form. Quite often, there are multiple results for one product, different
only in...
( 1 2)
|
|
16 |
388 |
|
|
Sorry! Parameter query / Again by
D
Hi everyone/ Doug:
So. in the below qry; I would like to do all the comparisons based on year
and month: yyyymm; I need to enter when propted, yyyymm; how do...
( 1 2)
|
|
16 |
180 |
|
|
|
|
16 |
213 |
|
|
conditional join? by
Bart
I need a query to that will combine data from two tables (photos,
proveniences) but the method of record selection needs to vary based upon
whether or not...
( 1 2)
|
July 4th, 2007 09:10 PM
by Bart
|
16 |
170 |
|
|
Without Matching Query Limit ? by
Stuart
Hi All,
The Without Matching query wizard works fine until you select more than 13
columns to compare. My guess is that the 13 " AND " 's in the SQL left join...
( 1 2)
|
September 27th, 2007 04:02 PM
by Stuart
|
16 |
202 |
|
|
Query to Count Consecutive days? by
Ann in CA
Hello,
I am trying to figure out a way to tell how many consecutive days there is a
schedule entry for a person in a table. I've set up a query to yield a...
( 1 2)
|
|
16 |
267 |
|
|
Sort multiple query results by
Opal[_2_]
I have a query based on 3 separate tables. The query calculates
inventory results for 13 Die sets. One table holds the total pallets
counted. The second...
( 1 2)
|
|
16 |
188 |
|
|
|
|
16 |
150 |
|
|
Work hours by Ken Sheridan. by
Keith
Can someone please help with the following function that was provided by Ken
Sheridan. I pasted this in the VBA but I guess I need to replace some of the...
( 1 2)
|
February 14th, 2008 01:26 AM
by Keith
|
16 |
153 |
|
|
if statement by
ncm
I have a list of students, parents and the school the child attends in a
table. I need to determine the number of students each parent has in a
school. I...
( 1 2)
|
|
16 |
200 |
|
|
If Statement In Query by
DS
Is there an easier way to code this for a field in a Query for a report.
The field will be in the detail section.
Thanks
DS
If CDTax = 0 And _
CDWhere =...
( 1 2)
|
|
16 |
286 |
|
|
|
April 6th, 2009 07:36 PM
by A.S.
|
16 |
179 |