|
|
|
|
3 |
327 |
|
|
Query help with Modules by
Lucien
I have 3 modules that I would like to use within a query I am designing. I
currently have an expression in one field of my query that references one of...
( 1 2 3)
|
|
21 |
327 |
|
|
two criteria in DLookup by
Song Su[_4_]
No error when compiling but when open form, got 'type mismatch'. Here is the
code:
Private Sub Form_Load()
If DLookup("", "users", "Trim() = '" &...
|
|
5 |
327 |
|
|
|
March 25th, 2010 10:20 AM
by Ivan
|
5 |
327 |
|
|
|
|
5 |
326 |
|
|
|
|
5 |
326 |
|
|
Currency without decial by
Pat Diminico
I need a function to remove the decimal point not the decial place. I need to provide a data file with dollars and cents without the decimal.
Thank you
|
|
1 |
326 |
|
|
Adding Fields To Tables; by Query? by
Tim Fierro
Hello,
I could use a bit of help here since I have not
done this before.
Tables: tblVitem, tblOrderLine, tblInvoiceLine
1) I want to add a new field to each...
|
|
3 |
326 |
|
|
|
October 12th, 2004 08:41 PM
by Leo
|
1 |
326 |
|
|
|
|
0 |
326 |
|
|
|
March 10th, 2005 03:17 PM
by cnuk
|
6 |
326 |
|
|
iif condition by
Alylia
Hello,
My problem has got to do with the Purpose of
Travel field (query created field). Along with for e.g. object code - 2145,
purpose of travel is "Sick...
( 1 2 3)
|
|
21 |
326 |
|
|
Primary Key field validation in forms by
Steve
Hi ;
I use the forms function to record information into a table .
There is a primary key defined for one of the fields that allows me not to
input duplicate...
|
|
7 |
325 |
|
|
|
|
2 |
325 |
|
|
|
October 21st, 2004 03:18 PM
by LeAnne
|
1 |
325 |
|
|
Passing parameters in a query by
Ivan Debono
Hi all,
I've got a union query that requires 2 parameters. I'm using vb6 to make a
select statement based on this query but i don't know how to pass...
|
|
2 |
325 |
|
|
SQL database record locks by
Vaughan
Our business uses the SQL based Sage business system. I have written a large
number of queries on the Sage SQL database tables using the ODBC link to
Access....
|
September 29th, 2004 12:53 PM
by Vaughan
|
2 |
325 |
|
|
Access vs. Excel query w/blank field by
dutty
Here is the SQL for the two queries:
Access:
SELECT DISTINCTROW Delivery.Promised_Date, Customer.Name, Job.Part_Number, Delivery.Promised_Quantity,...
|
July 27th, 2004 05:46 PM
by dutty
|
1 |
325 |
|
|
Text to Date by
Jeremy Noland
Anyone know of an easier way to convert a 4-length string
to a beginning date (in my case 06/01/(XXXX-1) ) and
ending date (in my case 05/31/XXXX). XXXX Is...
|
June 24th, 2004 10:29 PM
by
|
3 |
325 |
|
|
"append query" issues by
BJMLaJolla
I have the same problem. I have 70 tables that I want into one table. All tables have the same structure with different content. I tried an Append Query but...
|
|
1 |
325 |