|
|
|
|
1 |
106 |
|
|
Show result of TblA not in TblB by
Ian
I have a main tblA with all clients. If they have any current contracts they
are in tableB. How do I show the clients of A that are not in B?
Thanks Ian.
|
February 9th, 2007 02:36 AM
by Ian
|
4 |
84 |
|
|
Date stored as Number by
JanetF
Hi there,
I have a strange situation where I've adopted a database which I need to
take data out of and import into a new database. Unfortunately one of the...
|
|
6 |
84 |
|
|
|
|
0 |
117 |
|
|
Table list in CrossTab Pivot statement by
Biggles
There might be an eaiser way to do this, but I am in a hurry and have
existing queries I need to fix.
I have a crosstab query where the column headings are...
|
|
1 |
73 |
|
|
zero a field in duplicate rows by
Manny
Hi,
I have a table with duplicate rows, which is fine, that's what i need to
display.
i have the same field 'balance' in all those rows.
My question is; how...
|
February 8th, 2007 10:58 PM
by Smartin
|
5 |
79 |
|
|
aggiornamento form ricalcolata by
madmax71
qualcuno saprebbe gentilmente suggerirmi come fare per :
aggiornare da una sottomaschera il contenuto di un campo in un elenco di
record determinato...
|
|
1 |
112 |
|
|
|
|
0 |
89 |
|
|
round function in query by
mbr96 via AccessMonster.com
I have a table with a MonthlyPmtAmt field (Number data type, Single), that I
notice has varying numbers of decimal places when I export the table to Excel.
The...
|
|
0 |
101 |
|
|
filtering integers in a field by
IVAN
I have a problem in creating a relationship for 2 tables.
Table1 - represents a call list with destination phone numbers(
international).
Table2 - is a...
|
|
6 |
99 |
|
|
Joining Multiple Tables by
Harddrive747
I have three tables with the same amount of fields. They are Source,
destination and volume.
I'm trying to show trends from the source to the destination...
|
|
3 |
93 |
|
|
Delete all Records but... by
binder
Hello -- I have a table that list a set of records that I need data for
(tblScan) and several tables that contain many more records than I need. How
can I...
|
|
4 |
107 |
|
|
trouble with query results by
Slez via AccessMonster.com
I have a query that returns duplicate records as follows:
If I have 1 record in tblChangeItem, it returns the records for
tblChangeItemDetail properly.
If I...
|
|
1 |
97 |
|
|
Use of Variables in queries by
hkhella
I have multiple client names listed in a field. I need to build a report for
seperate clients with similar search criteria (i.e. search for reports that...
|
February 8th, 2007 07:00 PM
by Klatuu
|
4 |
99 |
|
|
|
|
1 |
78 |
|
|
|
February 8th, 2007 06:16 PM
by Klatuu
|
5 |
89 |
|
|
Converting partial date text to date by
B Rager
Access 2003 ~
I have inherited a table with dates displayed as text. Problem is the dates
are partial dates (i.e. 0705) 0705 is YYMM. I need to convert the...
|
|
1 |
89 |
|
|
Same week last year, MTD by
Steve Happ
Using Access 2003
I have searched for quite a while through the discussions but can't seem to
find answers to what I need. If I've missed it, feel free to...
( 1 2)
|
February 8th, 2007 05:01 PM
by Klatuu
|
14 |
187 |
|
|
Table Details not in Build by
Ken
I would like to use the value of a combo box on a form as criteria, and it
isn't working. I tried to build the criteria and the details of the form
don't...
|
|
1 |
97 |
|
|
query doubles up records by
Slez via AccessMonster.com
What could cause a query to return a duplicate set of records? I can view
the records in the table, and for example there may be 6 records associated
to the...
|
|
6 |
71 |