|
|
Multiple look up criteria by
Dee
I have three queries.
First one: "Discrepancies in unit price":
SELECT Data.MANUFACTURER, Data., Data.DESCRIPTION, Data.
FROM Data
WHERE...
|
November 21st, 2006 08:07 PM
by Dee
|
2 |
70 |
|
|
|
November 21st, 2006 07:48 PM
by Andy
|
0 |
66 |
|
|
Selected Days Filter by
Simon One
I want to filter my data to return information for a specified date and for
the previous 14th Day, 28th day, etc for the previous 6 periods. i.e.
28/11/06 ...
|
|
2 |
81 |
|
|
Time Calculation by
Scott
I am calculating the amount of time that an employee is tardy. I am using
the following expression: TardyTime:
Format(/1440)-(/1440),”h:nn”). The...
|
November 21st, 2006 05:46 PM
by Scott
|
2 |
80 |
|
|
|
November 21st, 2006 05:40 PM
by RWilly
|
2 |
87 |
|
|
Return parent based on child by
ES
How can I build a query to return Jack from the following from two tables?
Table1 (parents)
1 John
2 Jack
3 Sue
Table 2 (child)
|
|
1 |
75 |
|
|
Update a boolean field by
jac007
I have two tables that are being compared. If field_1 from TABLE B is the
same as field1 from TABLE A, then there QCTV1 field from TABLE A should have
a...
|
November 21st, 2006 03:09 PM
by jac007
|
2 |
74 |
|
|
|
|
5 |
115 |
|
|
Criteria that allows to Query Upper Case by
Romin
Hi, I have a query where I want to retrieve only records from a Table where
one of th e Fields in that Table does not contain the two letters BR in upper...
|
November 21st, 2006 02:28 PM
by Romin
|
6 |
93 |
|
|
Bonus 10% of Salary by
na
Hi,
The query is:
Employees whose Bonus is at least 10% of their Salary.
Thanks
Myrna
|
|
2 |
88 |
|
|
Use Date as Query Criteria by
Dave C
Hi,
I hope someone can help me.
I have a query that I want to execute using a date range in the criteria. It
works fine if I prompt the user to enter the...
|
|
4 |
64 |
|
|
|
|
5 |
84 |
|
|
|
November 21st, 2006 09:08 AM
by Laputa
|
2 |
58 |
|
|
Missing Birth Dates by
na
Hi
The query I need
All employees, except those with missing Birth dates.
Thanks
Myrna
|
|
3 |
74 |
|
|
Help on Consolidating data by
The Dummy in Access for Dummies
Is there a way to consolidate data for one particular item (record), without
converting into a Pivot Table? Example: If I have 60 units for the year 2005
and...
|
|
1 |
65 |
|
|
Queries by
na
Hi
The query that I am having difficulties with.
Query. Employees whose first name and last names begin with the same letter
(e.g.
Jill Jones).
Thanks
|
|
1 |
60 |
|
|
|
|
1 |
49 |
|
|
|
|
3 |
93 |
|
|
Type Mismatch in Expression Error by
Bill
I am trying to run a make table query from existing related tables that are
linked through a connection that updates their information daily. I have
dragged...
|
|
1 |
61 |
|
|
1st Of Every Month by
Jose Aleman
Hi,
I'm trying to build a query that gives me the first day of the current
month. This is what I currently have:
When I run my query it returns 10/1/06 and...
|
|
2 |
78 |