|
|
filter using queries by
priya
Hi
I have a data table A with several fields including cust #
and part #. I have another table B with cust # and part #.
I would like to create a query so...
|
|
2 |
116 |
|
|
Group by Month by
Liz Hansen
Hi,
I'm sure this one is an easy one, I just can't figure it out. I have
created a query looking at one table with Dates and Sales figures. The
dates are...
|
|
6 |
231 |
|
|
Users can't use createquerydef by
Mark Schirle
Hi,
I am converting from A97 to A2k3. I have a form that allows users to
make choices and then hit a button to see results. Behind the scenes I'm
making a sql...
|
|
3 |
158 |
|
|
Null value is paramet query by
JamiLynn
I am a newbie so bear with me. I have a database that is set up to track all
job by projectid.
I created a multiple parameter query to show all the amount...
|
|
9 |
521 |
|
|
using LIKE by
Alex
I have a "text" field with the data such as 02, 02A, 03,
03A, 123, 123B. It can be only two or three digits number
with or without A or B.
Table1
NumberOf ...
|
August 23rd, 2004 11:40 PM
by Alex
|
4 |
111 |
|
|
Select Most Recent Note for Each Employee by
Michael E. Hill
I have a table listing employees with a one-to-many
relationship to a table of notes; obviously each employee
has many notes associated with him/her. I would...
|
|
2 |
158 |
|
|
Crosstab - "Record is too large" by
Liz Hansen
Hello,
I have a crosstab query that when run displays the following error:
"Record is too large".
It is a large query, I have 235 columns, but as far as I...
|
|
1 |
173 |
|
|
Expression by
Floyd Forbes
I have a query that has a column name accounts. How do I
create an expression that will turn "mailroom" and "meeting"
in the account column to zero?
Floyd
|
|
1 |
75 |
|
|
|
|
2 |
377 |
|
|
Query Help Needed by
ChrisP
I have a Query that is like a Service Bill and I use it
for a Report that is a service bill that I want to print
out.
My query is working fine, but a minor...
|
|
5 |
121 |
|
|
how to query on two linked tables by
Patrick
I am new to access. I have a database that is too large
2gig, so I set up two databases each with a table that
are identical in structure but the data is not...
|
|
1 |
377 |
|
|
|
August 24th, 2004 02:05 AM
by
|
2 |
121 |
|
|
delete query 2003 by
phill
I would like to create a delete query based on an appened query. This query
takes information from two tables (2 op portfolio and 3 op contracts) and
dumps it...
|
|
2 |
106 |
|
|
query help by
Miranda
hi could someone please help me with this query
i have the following tables: projects, materialsUsed, equipmentUsed and
labourUsed. materialsUsed, equip and...
|
August 24th, 2004 07:04 AM
by Miranda
|
1 |
94 |
|
|
Query Problem - Leaving out Records by
ChrisP
I have a Query that is like a Service Bill and I use it
for a Report that is a service bill that I want to print
out.
My query is working fine, but a minor...
|
|
3 |
302 |
|
|
|
August 24th, 2004 09:49 AM
by a
|
0 |
126 |
|
|
|
August 24th, 2004 09:55 AM
by Franky
|
15 |
1,297 |
|
|
>0 by
Eb1mom
I am trying to get query to return records where PiecesLeft
field is greater than 0. When I put 0 in as criteria for
PiecesLeft I get a popup box asking for...
|
August 24th, 2004 11:45 AM
by Eb1mom
|
2 |
147 |
|
|
Optimised query by
Keith Emery
I have a report querying a table. It runs very fast with
normal selection criteria. However, i now need to further
select, searching for a word in a text...
|
|
3 |
98 |
|
|
specify data by
chris
I have queries which contain all of the information on our
companies clients. I then have a number of reports which
use this information for us to...
|
|
1 |
90 |