|
|
Count Records in multiple tables by
Jeff
I am trying to get a count of Appointments from multiple tables using this
statement - when I try to run it I get the unspecified expression...
|
March 16th, 2010 01:36 PM
by Jeff
|
2 |
189 |
|
|
SQL totalling items report by
Spike
I will be very grateful if someone will give me the SQL to run a query using
the Northwind data base that will produce a report that shows totals of
“Units...
|
|
1 |
213 |
|
|
'Type Mismatch' Error- PLEASE HELP by
khanner
we have a macro setup to update data info by uploading an excel spreadhseet
in the access database. However when i try this, i get a 'type mismatch'
error....
( 1 2)
|
|
13 |
467 |
|
|
multiple one to many by
Papa Jonah
I have a database with multiple tables that are populated with a form with
subforms.
Basically I have Table A with a record ID field that has a one to many...
|
|
2 |
205 |
|
|
|
|
2 |
212 |
|
|
Query not showing certain records by
Charlie
HEEELLLLP
I have a query which is used to feed to certain reports. It gathers
information from 4 related tables and has a criteria under the order number...
|
|
5 |
357 |
|
|
Show maximum date in a query/report - JCW by
JohnW
I am having trouble with a query/report that I run that should show the last
payment date that a tuition payment was made. It works for most records but
for...
|
March 16th, 2010 02:46 AM
by JohnW
|
4 |
244 |
|
|
Adding up row values by
kthomas
I am trying to add up all "fertilizer" costs by customer name. However, I am
getting 3 results per customer due to there being 3 types of fertilizer. How...
|
|
4 |
197 |
|
|
Remove dublecate post by
Highlight between 3 fields[_2_]
Hello
I have Table with two columns "Eng" and "Arb"
I found that contain dublecate posts with same information.
Is it possible to keep only one post that use...
|
|
5 |
225 |
|
|
|
|
0 |
250 |
|
|
Problem Passing Parameter from Form by
autigger
If I hard code in the following into the critera:
Like *
Any record that starts with T is not returned.
If I pass the same thing, *, from a form to:
Like...
|
|
3 |
182 |
|
|
Update Query by
Marc
I have two tables, Employee and Gaptable. In the employee table I have a SSN
field (social security number) a UPI field (unique personal Id numer) I want
to...
|
|
2 |
205 |
|
|
"is not a valid name. Make sure... by
AndrewB[_2_]
I just started getting the error message: "is not a valid name. Make sure
that it does not include invalid characters or punctuation and that it is not
too...
|
March 15th, 2010 07:13 PM
by Scott
|
5 |
360 |
|
|
Parameter in a critiria by
Dan
We do 3 different types of estimates, Cut, LCP & Misc with any possible
combination of them (7). I want to see how estimates were done for a
specific day. ...
|
|
3 |
168 |
|
|
|
|
2 |
173 |
|
|
|
|
3 |
226 |
|
|
query too slow by
angie
i have a table with 500000 records. it consists of pricelists from various
suppliers so i have duplicate products with diffrent prices and supplier...
|
|
1 |
212 |
|
|
Edit and save query criteria by
DNuding
I have 2 Select queries where the results criteria changes on a yearly basis
for 2 fields. There are 6 tables referenced in the queries. Only 2 tables...
|
March 15th, 2010 02:08 PM
by DNuding
|
6 |
270 |
|
|
|
March 15th, 2010 08:51 AM
by david
|
3 |
226 |
|
|
Parameter Queries by
goodgirlinterrupted
When you put in the Enter criteria for a query so that the user will have to
enter information first, such as entering a start date and then a finish
date,...
|
|
2 |
215 |