|
|
Crosstab Query?? by
smith_gw
I have a table that includes and ID and language field where multiple records
include the different languages. Some ID's have up to three languages so it...
|
|
3 |
207 |
|
|
Data Access Page with queries by
Brennan
I am building a Data Access Page and I have a couple list boxes. I want one
list box to update the other. With forms, I would put the following into the...
|
|
0 |
88 |
|
|
Blank result, want a zero by
Ann
I have three fields. They are , and . I
need the sum of the field for that is either "comp
time earned" or "comp time used" so I created a crosstab...
|
May 21st, 2008 04:00 PM
by Ann
|
2 |
101 |
|
|
|
May 21st, 2008 03:53 PM
by Dram
|
3 |
151 |
|
|
Running Total Loop by
Jeff Garrison[_2_]
I have a table that has an accrual field and a running balance field. My
question is...how can I do an update query or vba that will process the
record,...
|
|
3 |
114 |
|
|
DSUM Error by
NeoFax
I am getting an error with the below DSUM expression:
LeadHours:
IIf(41200,nz(DSum("HOURS","tblUnitHours","='" &
& "'...
|
May 21st, 2008 02:17 PM
by NeoFax
|
3 |
87 |
|
|
Multiple Aggregate Functions by
Public[_2_]
Hi,
I am facing a problem of creating multiple aggregate functions in the same
query. What I want is like to get the number of courses for a certain month...
|
|
4 |
76 |
|
|
workingdays in Acess by
Johannes
Dear Forum,
I hope you could help me with my new MS access 2000 challange.
I would like to calaculate in a query the different between 2 dates.
Output should...
|
|
2 |
118 |
|
|
Left Outer Join - With Two conditions by
Vadhimoo
Dear All,
Good morning, I need a Left outer Join with two conditions:
The records not in Dept table and CONDITIONS: (Emp.Name=Dept.Name AND...
|
|
1 |
97 |
|
|
Count Distinct displayed on subform by
gmazza via AccessMonster.com
Hi there,
I have read many many articles on this website and I still can't get this
right.
I want a count of distinct RefNum displayed on my subform.
My...
|
|
1 |
122 |
|
|
subreport problems with multivalued fields by
Intouch
I have a query that runs perfectly well using a multivalued field (Access
2007), however when I base a subreport on it I get an error back claiming
that it...
|
|
2 |
119 |
|
|
Date()-14 by
Jacinda
Quick question...
I am trying to set up a query in access 2007 that will return all of my
customeers who I shipped to 14 days ago.
This simple function...
|
|
1 |
95 |
|
|
Concatenate WHERE Criteria Question by
Ray Todd Jr
How do I properly use the two WHERE conditons below? The OWNER is a literal
statement, meaning the owner of the property and will also remain the...
|
|
1 |
88 |
|
|
Group by week by
Alex
I have a user form where a user types a date. I then need to group and count
records in my table for the week of the date the user picked plus the past 3...
|
|
3 |
103 |
|
|
|
|
8 |
129 |
|
|
Query Resulting in Duplicate Records by
Singinbeauty
Hello All,
Ok, below is the SQL statement for a query I want to run to find the list of
open disputes and combine the current list of disputes with the old...
|
|
3 |
80 |
|
|
Run a Query from a Form by
JBad
How can i call / run a query from a form?
Ex:
EmpCode: ---
When the user clicks the Find Record button, the query is run which would
most...
|
|
6 |
130 |
|
|
finding duplicated id in a query by
Hlarkin
I am trying to build a inbreeding query. The basis of this is that I need to
find dog's in a certain pedigree that have the same ID number
Below is just...
|
May 20th, 2008 05:35 PM
by Klatuu
|
3 |
85 |
|
|
Query Help? by
Lisa
I would like to put in a sales number into a form and have the query calulate
what the royality and ad payments would be and then update those amounts into...
( 1 2)
|
May 20th, 2008 04:36 PM
by Lisa
|
10 |
133 |
|
|
Formatting a text file by
Mark
I need to take a text file with a list of numbers that are formatted like:
80012345
91290999
89894566
48277770
and so on.... and turn it into a one long...
|
May 20th, 2008 03:43 PM
by Mark
|
3 |
93 |