|
|
Merging three tables by
John
Hi
I have three tables with a common id with which they can be linked. I need
to merge them in a way that the resultant table has all records from three...
|
|
5 |
141 |
|
|
Make Table Query Table name restrictions by
azpat via AccessMonster.com
Is there any way to create a table name in a make table query that will
include the date?
I want to have a history of tables and would like to have the date as...
|
|
1 |
71 |
|
|
Help with Query by
DeMangello1
This is my curent query:
SELECT User.PKey, User.UserId, User.Administrator, User.MedONLY,
User.FilterCRT1, User.FilterCRT2, User.FilterCRT3, User.FilterCRT4,...
|
|
2 |
78 |
|
|
concatonating by
Linda
I am attempting to combine 3 fields into one and not having much success.
I've created a new field called GRANTALL in a query to accept this. All
fields...
|
December 27th, 2006 06:26 PM
by Linda
|
5 |
78 |
|
|
Query Date by
coconutt
I have two tables joined one to many. The one is patient name, the many is
scan date. When I run my query it will give me the patient name as many times
as...
( 1 2)
|
|
11 |
164 |
|
|
Countif ? by
marcus.
Hi,
Hi I'm trying to do a countif function (although that does exist in access), but something else should be fairly simple...
I'm in a 'Totals Query' where I...
|
|
8 |
170 |
|
|
Date Range Issue by
Kevin
I have a database where I am attempting to create a complex weekly
report for employee production. I am struggling with the date portion
of this project.
The...
|
|
2 |
63 |
|
|
|
|
16 |
190 |
|
|
|
|
2 |
89 |
|
|
Delete query warning message by
WilliamP61
Hi
Thanks for reading my question.
I have a delete query that works fine. However, I want to circumvent the
Access warning messages so that I can add my own...
|
|
4 |
92 |
|
|
simple data replacement by
Novice2000
Hi,
This should be simple, but I am still pretty new at this.
I have a main table in which each record has a unique identifier (Policy
No.) and each record...
( 1 2)
|
|
10 |
151 |
|
|
|
|
5 |
115 |
|
|
IFF One Date = Another Date by
Nanette
I've been trying to get the below query to work. It only pulls a couple of
dates.
Any suggestions on how to fix it?
IIf(( = ), IIf(( = ), IIf((
= ), IIf((...
|
|
9 |
107 |
|
|
Query with most recent contract by
sarah
I could use some help. I have a table with customer info and a table with
contracts. They are linked by an ID field. I would like to create a query
that...
|
December 28th, 2006 07:16 AM
by sarah
|
2 |
70 |
|
|
Need help with query by
Darin Connors
Happy Holidays everyone. I have a task to create a report from a data set. I
think the quickest way is to query the data.
fields:
Date, Region (ie BC, AB,...
|
|
4 |
113 |
|
|
|
|
3 |
74 |
|
|
Making it harder than I need to by
Novice2000
Hi,
Thanks in advance for tyring to help me. Maybe I could have been more clear
about what I am trying to do, but I have posted before without a...
|
|
8 |
122 |
|
|
|
|
1 |
78 |
|
|
Join Problems by
Tonk
The qry COADS contains only 86 records, one for each county. The
qryScanLog contains 88 records, one for each county. I have tried all
possible joins and I...
|
December 28th, 2006 05:35 PM
by Tonk
|
4 |
95 |
|
|
update query design questions by
PJDooley
I'm using Access 2003 and windows XP. I'm building an update query based on
a select query to update information in one table with a new table. I have a...
|
|
1 |
66 |