|
|
Duplicated Query results by
Alex
I have two tables; "Orders" & "Cancellations". The Orders
table contains the following orders:
part# loc
1 a
3 b
1 a
5 d
The...
|
|
1 |
558 |
|
|
|
|
5 |
707 |
|
|
How do I declare a variable as a Variant by
Sandy C
I am running an append query and get this error:
You tried to assign a Null value to a variable that is not a Variant data type. Use the Dim statement to...
|
|
5 |
811 |
|
|
Return most recent record [Repost] by
Jordan
I have a table of payments made by clients. It includes
the fields:
PaymentID
ClientID
DateRec
AmtRec
I was trying to use the Last function on the Total row...
|
June 1st, 2004 03:27 PM
by
|
2 |
565 |
|
|
qry-SalesAnalysysCollectData? by
Maureen
tblInventory + tblInvoiceDetail
I would like to collect sales history for analysys. I'd like sales for
various periods (based on tbleInvoiceDetail.date) for...
( 1 2)
|
|
10 |
829 |
|
|
Return Left Portion of a String by
Bonnie
Returning the left portion of a string in a query.
i.e. if the string is: "
What combination of functions would return only "anybody"
or...
|
June 1st, 2004 02:23 PM
by Newbie
|
3 |
304 |
|
|
|
|
1 |
557 |
|
|
ADO Parameter Query by
Tony_VBACoder
I have a bunch of Parameter Queries that I have been
calling with VBA. But now I am converting my code to use
ADO recordsets. How would I change my old code...
|
|
2 |
332 |
|
|
HELP!!! Validation rule by
Chris
I have to introduce in a table some data, using a form with contrtols: combo
boxes and text boxes. The fields need to follow some VALIDATION RULES, and
to...
|
|
4 |
622 |
|
|
highlighting field in query or report by
Tony
Hi, I'm trying to highlight a cost field if there is a change in the field
value. eg if previous cost was $2.20 for the last 9 weeks and this order
comes in at...
|
June 1st, 2004 12:53 PM
by Tony
|
5 |
573 |
|
|
More dates issues by
Mike
Hello,
The dates in a SQL2k table are stored as nvarchar (yyymmdd). When displayed,
the CAST (DATE_FIELD AS datetime) syntax is used. Because of the...
|
|
1 |
362 |
|
|
Edit table using union query by
De'Ville
I am trying to create a form for a union query that
allows me to edit the data in either of the tables used
for the query, but I can't understand why with...
|
|
1 |
1,401 |
|
|
|
June 1st, 2004 08:17 AM
by Chris
|
0 |
590 |
|
|
Update query problem by
WWV
I have a table (table 1) with many date ranges in them for grouping by age
ie start, end dates for group 1, start end dates for group 2 etc. I have
another...
|
|
1 |
557 |
|
|
|
|
2 |
277 |
|
|
Help by
Andy
I currently run w2000 professional on my other pc. When I
shutdown my pc is won't shutdown automatically, I now have
to manually press the on off button. Any...
|
|
1 |
303 |
|
|
Query By Form by
Craig
I have a query by form whereby the form has a Command Button to run a module
which checks to see if the query has records. If the record count is 0 it
opens...
|
June 1st, 2004 01:10 AM
by Craig
|
2 |
974 |
|
|
Totaling selected records only. by
David
I have been attempting to total some fields from
individual records in a table and then display the result
in a text box but have been unable to do so. I...
|
|
1 |
568 |
|
|
Help! -Match problem by
Chengfu
Hi, group.
I need your help.
I have two tables, one is tblTutor with the names and their available
times, the other one is tblTutee with the names and the...
|
|
4 |
289 |
|
|
CrossTab Query with Dates by
GNTK
Hi All,
I have a database with 3 tables: TBL_Persons; TBL_Absence;
TBL_AbsenceReasons. When a person is absent I put a record in the
TBL_Absence with the...
|
|
3 |
323 |