|
|
Rank Query With Groups (Array?) by
dmasch
Hello, I have a table of data with grades which are grouped by study. I need
to rank the grades relative to all the other grades in the same study. Below...
|
February 4th, 2010 06:02 PM
by dmasch
|
2 |
159 |
|
|
Find Duplicates within a string by
colin
Hi,
I have a contacts database and need to keep it data cleansed to avoid
duplicate records.
I propose to concatonate all fields into one and would then...
|
|
3 |
144 |
|
|
Formatting fields.... by
Rob Wills
Normally, if I want to format a field in a query – I set the properties in
the field using the GUI...
However, I’m doing a funky join, which the GUI is...
|
|
2 |
209 |
|
|
Storing Information From Queries? by
soma
I'm working with a 1gb database and have about 20 queries that analyze and
summarize the database in different ways. I tried running a separate query
that runs...
|
|
2 |
160 |
|
|
One query to multiple databases by
bvdahl
Hello,
I have five different databasesd that I access through five different odbc
connections. They bases are identical, but the data in them are not....
|
|
7 |
139 |
|
|
|
|
4 |
245 |
|
|
Convert annual data to monthly by
merry_fay
Hi,
In some of my queries, I'm having to take an annual number & divide it by 12
to get monthly information.
This is being joined in a union query to other...
|
|
8 |
164 |
|
|
query several fields by
goodmant
I have a data base table with the following fields:
Town
Last Name
Lot
I want to have one query whereby I can query for example 1 of 3 fields, or 2
of 3...
|
|
5 |
127 |
|
|
Quick Query Problem by
dannie
PARAMETERS !! Text ( 255 );
SELECT InspectionsDI.ID,InspectionsDI.Area
FROM InspectionsDI
WHERE InspectionsDI.Area=Forms!!cmbArea;
This code works correctly...
|
|
3 |
132 |
|
|
=Date() Problem by
Justin
I have a query and want to return records only with today's date. However,
when i use =Date() in the criteria field i only get one result (i have three
with...
|
|
2 |
97 |
|
|
|
|
1 |
115 |
|
|
COUNTING QUERY FOR ITEMS PLS. HELP by
Haas
I have the following two tables
1- Companies
ID, Name, ItemID, ItemDescription
(7560 records each company can have as many as items he can provide)
2-...
|
|
3 |
135 |
|
|
Joining unrelated data in query by
kemosabe
I want to take a single "StartDate" field from a table "Dates" and include it
on every record in a query "qry_tblShipmentTotals_ASSOCID". The "StartDate"...
|
|
2 |
136 |
|
|
Count or sum help on query by
jannie
This is my SQL code for a query I'm running that is working great for my
report. What I need now is that I need the total of Y's and N's for each
column. So...
|
|
1 |
129 |
|
|
|
|
1 |
140 |
|
|
cursor changes to hand when focus on label by
naveen prasad[_2_]
Hi ,
I have a form with different labels, when clicked opens appropriate form to
operate...
everything is fine in my application, only thing is when the...
|
|
2 |
147 |
|
|
Specific filter for the data in a field by
Dimitris
Hello,
In a field there are entries that have the symbol * entered for some reason.
For example:
DBW*R2
3*FLEW
QQ*IF94
How can I filter and find all the...
|
|
1 |
112 |
|
|
Help needed with IIF in my query by
jannie
I have several fields in my database that are date fields. The data type in
my table for these is date/time and formatted as short date. In my query
(I'll...
( 1 2)
|
February 3rd, 2010 01:16 PM
by jannie
|
14 |
278 |
|
|
last row or record by
igg via AccessMonster.com
there is no ID in this table.
table1:
col1 col2 col3
----- ------ -----
aaa bbb ddd
aab jjj fff
ccc qqq ppp
like to get this...
|
|
2 |
186 |
|
|
Sudden problem with functions in queries by
duck
I am using Access 2003. I have been using this for years now. I regularly
use Left, Mid, and Right functions, along with the CDbl function. All of a...
|
|
2 |
118 |