|
|
Match Query by
accessuser via AccessMonster.com
Hi,
I'm trying to create a database that will run a match against a text file
that I get everyday. I want to be able to run the text file information
against...
|
|
5 |
128 |
|
|
Simple Syntax Q for You by
Amanda V
Hi All,
I'm using Access and VB to make a program:
I was wondering how to make an SQL query that filters a recordset for
column A given that the...
|
November 25th, 2006 12:55 AM
by tina
|
2 |
75 |
|
|
|
November 24th, 2006 08:38 PM
by Song Su
|
2 |
95 |
|
|
Why add when you can concatenate? by
Gwen H
The following query, instead of adding the numbers 0, 0, and 1 to finish the
calculation in the last column, is instead concatenating them to come up with...
|
November 24th, 2006 07:32 PM
by tina
|
1 |
74 |
|
|
count problem by
Homie
i have a table with "client_id", "ethnicity" and "date". the client_id field
can have duplicates as the table only holds temporary information based over
a...
|
November 24th, 2006 07:08 PM
by tina
|
3 |
79 |
|
|
Making query to bring in an actual name by
Ray Murphy
Hi All,
My knowledge of Access is pretty limited, but so far I've managed to
get through with minimal help via these groups, but I'm stuck again
and the only...
|
|
3 |
106 |
|
|
Breaking ties in a Top n Query by
S Davis
Hi folks,
I received some excellent help on friday with a Top 12 query I am
working with. It works great except that I am having trouble creating
criteria to...
|
|
9 |
113 |
|
|
Why would this query give #Error values by
Matthew P
Hello ....
I am running the following query:
SELECT a.Area, a.Day, Nz(b.DayTime,0) AS DayHours
FROM AllDates AS a LEFT JOIN DayTimeHours AS b ON (a.Area =...
|
|
4 |
88 |
|
|
calculate date - no weekends by
Jenn
I am trying to write a query to calculate the date of a report three
days after the admit date. The report cannot be due on sat or sun so
if the third day...
|
November 24th, 2006 05:18 PM
by Jenn
|
3 |
75 |
|
|
|
|
1 |
71 |
|
|
Excluding Data in a Query by
WMorsberger
I have the following query:
SELECT tblAMUWork.ID, tblAMUWork.DateRcd, tblAMUWork.TypeOfWork,
tblAMUWork.MISNumber, tblAMUWork.RptName, tblAMUWork.AmtRcd,...
|
|
2 |
66 |
|
|
sub for parameter by
knowzero
I have a form and a sub from. one of the fields in the sub form uses a
parameter. I want to use a value from the main form as the parameter in
the sub form....
|
|
1 |
69 |
|
|
like [parameter]* by
knowzero
I would like to have a parameter in my query but it uses the like on
the parameter. If I want to select ABCD and ABCC and ABCE I will insert
in the parametr...
|
November 24th, 2006 04:25 PM
by knowzero
|
3 |
60 |
|
|
Multiple criteria to filter Query records by
CW
We carry out Quality Control by either of two methods on each of our jobs - a
phone call for certain types of work, a mailed questionnare for others.
I have...
|
November 24th, 2006 03:11 PM
by CW
|
2 |
70 |
|
|
Change Query column labels? by
CW
The column labels (headings) naturally reflect the field names.
How can I edit these as in some cases they are longer (wider) than is
necessary for the data...
|
November 24th, 2006 02:08 PM
by CW
|
2 |
175 |
|
|
Multiple Categories in a query - Part 2 by
Paid The Umpire
Some nice people gave me the following query to create a list of the
highest score in each of the Categorys overall for my sporting club.
SELECT *
FROM as...
|
|
1 |
64 |
|
|
|
|
1 |
84 |
|
|
Simple query - why having problems? by
Jen
I can't believe I'm having this problem, but I've been struggling with it all
afternoon and I just can't figure out the problem.
I have a database that...
|
|
1 |
69 |
|
|
need help for this query by
Song Su
I have a query result looks like this:
Sect ID
1418 7002
8018 7002
3355 7045
etc. etc.
based on above, I want to create a query with this...
|
November 24th, 2006 12:14 PM
by Song Su
|
7 |
74 |
|
|
|
November 24th, 2006 07:57 AM
by DaveP
|
4 |
133 |