|
|
Cannot Delete From Specified Tables by
Dave
I've got a VB.NET app that needs to delete all the records from a
single, unlinked Access table. The table has one field (non-key) of
type OLE object. When I...
|
September 20th, 2005 03:53 PM
by Dave
|
3 |
133 |
|
|
Replace two fields into one by
bladelock
I have three fields (all three text) in a table "a1", "a2" and "a3"
How can put all for a1 Plus (combine) a2 into a3 with a query?
Thanks
|
|
5 |
105 |
|
|
Simple Expression Question by
QRATRAINER
I keep track of training sessions in a table. I want to run a query that
will prompt me to enter in a Last Name, then First to list all training
sessions that...
|
|
2 |
95 |
|
|
Time/Date by
Jay
My table has a TimeInSec field (Time/Date datatype). This field has ALL
NEGATIVE numbers in seconds.
I used the following expression to change to regular time...
|
|
3 |
93 |
|
|
Format Yes/No fields after Union by
DD
I have 2 tables which have a field whose value is either Yes or No.
After performing a UNION query on both these tables the corresponding
resuting field shows...
|
|
1 |
87 |
|
|
Make table query with derived fields by
Andy
I am trying to create a make table query that contains an end value dervied
from numberic fields within the table. I have 9 different columns where I
need to...
|
|
1 |
111 |
|
|
|
September 20th, 2005 06:25 PM
by SusanV
|
3 |
84 |
|
|
Date restrictor for this week by
ChuckW
Hi,
I want to create a report that will always give sales for the current week
starting with monday and going to friday. We are closed on Saturday and
Sunday...
|
|
1 |
85 |
|
|
Delete query by
Bob
I have a table. the table has a field called "product_id". there are many
records with the same product_id. I would like to run a query that will
delete all...
|
September 20th, 2005 07:21 PM
by Ofer
|
1 |
80 |
|
|
Variable Table name by
SLeach
Hello! I am looking to create an SQL statement, or anything else, that would
allow me to create tables with a variable in their name. For example, I want
to...
|
September 20th, 2005 07:48 PM
by SLeach
|
5 |
113 |
|
|
Dynamic Set Query Feild Properties by
Aron
I designed a query with over 60 columns I need too enter information in each
columns for the 'Description Property' is there a way to add info into...
|
|
3 |
110 |
|
|
How to add just one field by
Bob
I have two tables. They both have a field "Product_ID", and are linked on
this field.
One table has a field Vendor, every record in this field is empty.
The...
|
September 20th, 2005 08:19 PM
by Rick B
|
1 |
73 |
|
|
name query by
Rowan
I have a query with 50 peoples names in, some names appear more than once.
What I want to do it to show all names that appear more than once and not
show any...
|
September 20th, 2005 08:20 PM
by Chaim
|
1 |
77 |
|
|
date parameter by
Jim
I have a query built with a "start date" and "end date" parameter. What can
I enter in the "end date" to allow the query to run through "current?"
|
September 20th, 2005 09:41 PM
by Chaim
|
2 |
110 |
|
|
|
September 20th, 2005 10:09 PM
by Alpha
|
12 |
220 |
|
|
Payroll Dates by
[email protected]
I'm trying to set up a cross tab query with the column headings as
payroll dates
(ex. 1/15/2005, 1/31/2005...etc). Is it possible to do this
programmatically?...
|
|
4 |
121 |
|
|
|
|
2 |
128 |
|
|
|
|
1 |
208 |
|
|
Searching for records that do not exist yet by
Sarah Stockton
I have 3 tables "Owner", Business" and "Annual Fees". They all have a one to
many relationship ie. one owner to many businesses and one business to
several...
|
|
4 |
125 |
|
|
|
|
1 |
80 |