|
|
|
|
5 |
147 |
|
|
How to query by
Nova
I have 2 fields in a table
JobNo Employee
1 A
1 B
2 X
2 Y
3 H
3 J
3 ...
|
|
5 |
258 |
|
|
|
|
3 |
167 |
|
|
TYPE CONVERSION by
Access Rookie[_4_]
My goal is to automatically update the End Date to display the create date
from a record previously reported. For example the end date for the first
record...
|
|
1 |
176 |
|
|
Update End Date by
Access Rookie[_3_]
How can I automatically update the End Date to display the create date from a
record previously reported. For example the end date for the first record...
|
|
5 |
170 |
|
|
Find matching records based on two fields by
Damian
Hi, I'd be really grateful if someone could please assist with my query. I'm
trying to identify all records where is equal to 'Atlas' that has
matching...
|
March 24th, 2010 05:44 AM
by Damian
|
2 |
137 |
|
|
Delete duplicates with conditions by
Damian
Hi, I have a table with FieldA, FieldB, FieldC.
I want to delete records based on FieldA, leaving me with one unique record.
The corresponding data in...
|
March 24th, 2010 05:42 AM
by Damian
|
2 |
187 |
|
|
|
|
1 |
135 |
|
|
Making changes by
Tom
I have made a Join Query that works OK. In this Query I have a column that I
use to make comments. This column is in the table used to make up this query
as...
|
March 24th, 2010 02:09 AM
by Tom
|
4 |
126 |
|
|
dcount in a crosstab query by
inungh
TRANSFORM Count(MyQuery.ID) as CountOfID
SELECT MyQuery.Code, DCount("*" , "tblActivityDetails" ,
= #3/14/2010# and = #3/20/2010# and
=...
|
|
3 |
147 |
|
|
passthrough query question by
Phil Smith
Just to be clear. I can NOT create a passthrough query that references
a form control for criteria. I would have to generate a stored SQL with
the value of...
|
|
1 |
191 |
|
|
BUILDING UNION QUERY by
JB
I HAVE 2 QUERIES FROM 2 SEPARATE TABLES
ONE HAS THE TREATMENT SALES FOR THERAPIST BY DATE
ONE HAS THE RETAIL SALES FOR THERAPIST BY DATE
I JOIN THE INFORMATION...
( 1 2)
|
|
10 |
287 |
|
|
Query to find outliers by
ghetto_banjo
if i am reading it correctly, you just want the names that appear in
both tables? That would be a regular Select query Joining the tables.
SELECT...
|
|
0 |
204 |
|
|
Query to find outliers by
John
I have two tables, one table listing names of people who did not receive a
gift card and a second table of people who were taxed for the gift cards.
Both...
|
March 23rd, 2010 08:43 PM
by John
|
0 |
146 |
|
|
Select unique products per customer? by
Jim
Looking at the Northwind database as an example, I need to take all the
products from the Orders table and put them into one field in a table for
each...
|
March 23rd, 2010 08:40 PM
by Jim
|
7 |
232 |
|
|
Convert Text to number by
Silvio
How can I convert a text field to numeric value?
The text values a
35
15
1.5
0.015
9900
The desired result need to be:
|
|
8 |
217 |
|
|
Query Speed by
ErikFM via AccessMonster.com
Hi there!
I am setting up a database for our branch offices to use in a distributed
(FE/BE) format, and am wondering which would be better for speed:
1. A...
|
|
5 |
122 |
|
|
Odd Parameter request in Crosstab by
AccessKay
Good Morning,
I read the threads about creating parameters in crosstab queries and this
helped me to get it to work but the parameter box pops up when I try...
|
|
4 |
134 |
|
|
|
|
2 |
140 |
|
|
Return One Record Per Individual by
Bill B.
I have a Union Query that returns these results:
Department # Department Name IOD Paid WC Paid
106011 HRR THERESE SMITH ...
|
March 23rd, 2010 06:34 PM
by Bill B.
|
4 |
150 |