|
|
combining temp & direct emp by
Mandy
I have a database with 2 different tables. I have one
for direct employees and another for temp employees. I
want to be able to combine them into 1 list and...
|
August 20th, 2004 02:53 PM
by Mandy
|
5 |
145 |
|
|
Selecting Blank Records as a option by
Lou
I have a query that is the Row Source for a combo box
that is used to filter a form by date field. Is it
possible to have the query pull only the blank...
|
|
1 |
402 |
|
|
|
August 20th, 2004 04:40 PM
by LeAnne
|
1 |
83 |
|
|
|
|
1 |
152 |
|
|
subtract dates by
a
Thank you
begin date end date subtract number in days
1/1/2004 5/1/2004 4
15/1/2004 20/1/2004 5
I...
|
August 20th, 2004 06:10 PM
by a
|
2 |
214 |
|
|
Union Query by
Paul
Hello and thanks in advance.
I have a database with SEVERAL tables linked together.
(using Office 2000). One table is an instructor table.
Each instructor...
|
|
3 |
128 |
|
|
Autolookup queries by
Brad@Zelle
Please help. I am trying to creat an autolookup fields.
I have 2 tbls a Calls tbl and Callers tbl. I want to be
able to select a callers name from a drop...
|
|
3 |
160 |
|
|
Update Query by
Stanis
Hello, i want to make a update query, but i can't. In my
event: i have a query1, with field Name, Number with SUM
for each record from table1, and group by...
|
August 20th, 2004 11:22 PM
by
|
2 |
126 |
|
|
Read only query/form by
Wayne
I have a main form called PrintRequisition with the
following query as its record source:
SELECT Print_Requisition.PrintReqID,
Print_Requisition.ProjectID,...
|
|
3 |
112 |
|
|
Parameter query and combo box by
Aniko
Hi,
Is it possible to make the parameter query so that the item
to be queried on can be selected from a combo box?
Many thanks,
Aniko
|
August 21st, 2004 05:15 AM
by Aniko
|
8 |
147 |
|
|
Auto-run queries by
sd
I need to semi-automate the following steps but I don't
know how. Can someone offer some suggestions.
First run a query that will append all the data...
|
|
3 |
79 |
|
|
Global Variable as query parameter by
Micosoft
Is it possible to use a global variable as a criteria in a query
Example:
I have a table:
year stuff
---------------------
2002 things
2003 more...
|
August 21st, 2004 02:17 PM
by Brian
|
5 |
335 |
|
|
dlookup and sql by
Johnny C.
I'm looking for an easier, more elegant method...I have code in a form that
creates a temp query using sql, then using dlookup to get data, eg. using sql
to...
|
|
1 |
126 |
|
|
query string error in format statement by
ABL
Basically, I have a string in a query (used as rowsource for a list box).
I've pared it down to try to find the error. Right now, I've got:
---
Outgoing...
|
|
4 |
192 |
|
|
Query selecting NOT Attended by
Brigitte P
I have a Seminar table and an Attendance table, seminars and Attendance
joint by Seminar Number (Attendance table also has attendees Social Security
Number)....
( 1 2)
|
|
10 |
178 |
|
|
using a query to construct a report by
dab1477
I've created a Time & Expense access program. I've created a query with
muliple headings. I want to create an expression that will combine the
headings into...
|
|
1 |
81 |
|
|
INSERT statement problem by
ChrisP
I keep getting an error message stating that there is a
data type conversion problem.
here is my SQL:
INSERT INTO Case_Issue_Tech_t ( , ,
TechID,...
|
|
1 |
373 |
|
|
Email a Queries data programtically. by
Ian D.
I have created a form that Prompt the user for criteria
used in a query. The queried data is shown in a
Subform Datasheet. I would like the user to be able
to...
|
|
2 |
138 |
|
|
Unmatched Query: Memo Fields by
Bernie
Is there anyway to compare memo fields using queries? I
can create Unmatched Queries to compare text and quantity
fields; but I can't perform the same type of...
|
|
1 |
564 |
|
|
MICROSOFT SHOULD HAVE. by
Dennis
Andy,
You must be frustrated about something? If you need help
just post it in the correct area and you will get help as
soon as someone can get to you. I...
|
August 22nd, 2004 07:43 PM
by StCyrM
|
1 |
94 |