|
|
Removing Leading 0 by
AccessIM
I am trying to link two tables using a field but the po # in one
of the tables includes leading 0s and the other does not. As a result,
Access doesn't see...
|
|
1 |
489 |
|
|
|
May 25th, 2004 03:30 AM
by Gary B
|
2 |
488 |
|
|
SQL query help by
[email protected]
I have this SQL
SELECT QryHisacctable.CORP, QryHisacctable.DIVISION,
QryHisacctable.FACILITY, QryHisacctable.DST_CNTR,
QryHisacctable.PCC_SMIC,...
|
|
8 |
488 |
|
|
Create report with 2 queries by
sumana
HI,
I have a singe table and 2 queries based on the same table. One query
is a Select query with some criteria. The second query is one which
uses the...
( 1 2 3)
|
April 27th, 2006 08:04 PM
by sumana
|
29 |
488 |
|
|
Create a table from a query by
ktm400
Iam trying to create a table from a query that has 10 columns of data (real
numbers)
I would like to extract the data in the 10 columns row by...
( 1 2)
|
March 22nd, 2006 09:14 PM
by ktm400
|
11 |
487 |
|
|
Deleting a foreign key relationship in SQL by
Stevio
How do you delete or drop a foreign key relationship from an Access
database, using SQL, when the foreign key relationship was created within
Access so I do...
|
December 22nd, 2004 02:51 PM
by Stevio
|
2 |
487 |
|
|
Inconsistent square bracket in Query SQL by
Christine
It has come to my attention that sometimes, when I open a Query in SQL
View, the SQL that I see is not exactly the same as the SQL in the
Query's Querydef. The...
|
|
8 |
487 |
|
|
Unmatched records by
Mario
Have 2 queries the names are "CustomersNoSales" and the other
"CustomerSales", both have a field named "CID"(CustomerID) and another field
named...
( 1 2)
|
February 10th, 2010 03:08 PM
by Mario
|
14 |
487 |
|
|
Help with Query by
Maureen
Is there any way in a query to do a running total like
records?
the output that I am trying to acheive is this:
teacher class period student stu_no
Mr....
( 1 2)
|
|
14 |
487 |
|
|
SELECT DISTINCT by
MacDuff
Hello
Is there a way to group the fields in a select SELECT DISTINCT statement so
that the distinct part works only with the first three fields and...
|
|
3 |
487 |
|
|
Append Query Question by
Chaplain Doug
Is there a way to do an append query and set a particual
field to a value in all records appended? I am currently
using for exmaple:
INSERT INTO SELECT *...
|
|
2 |
487 |
|
|
query design view problem by
Lisa
I have a fairly simple table that I am trying to query and
am having problems with one of the parameters. There is a
field that simply holds a Yes or No. I am...
|
|
2 |
487 |
|
|
|
|
2 |
486 |
|
|
|
|
3 |
486 |
|
|
how to specify decimal on query by
Joe Au
I create an append query on Access as follow:
Parameters p_field1 decimal;
insert into table1 (field1) values ();
The field1 is a decimal field with 2...
|
August 1st, 2004 05:52 PM
by Joe Au
|
2 |
486 |
|
|
Append one table to multiple tables? by
Stranger
I currently have the computer inventory at work in one table. I have
created new tables with relationships and I want to append the data in the
existing table...
|
|
2 |
486 |
|
|
|
|
19 |
485 |
|
|
query based on a date field by
Richard
Hello,
I have a database in which I have two fields; called "1st Notice" amd "2nd
Notice". Both are date fields and are formatted as medium date.
I have a...
|
December 3rd, 2004 02:29 AM
by Richard
|
2 |
485 |
|
|
|
|
2 |
485 |
|
|
query works but error message in report by
Tony
Hi, I am building queries for duplicate payments reports. I have the query
working but when I go to run it in the report I get an error message (error
3079) in...
|
June 5th, 2004 12:43 PM
by Tony
|
2 |
484 |