|
|
Truncating data by
Alylia
Hello,
Sometimes ago, I requested and got help on truncating the last three digits
from a field with data of the following format ????-????-???. I...
|
September 14th, 2005 10:17 AM
by Alylia
|
5 |
120 |
|
|
Select Count Random by
Markus
Hallo
I have this select count query which i need to change into a random count
what do i need to change to make it select random. What it does it count a
Qty...
|
September 14th, 2005 10:40 AM
by Markus
|
2 |
159 |
|
|
Date Last Changed by
FA
Please help.
I'm trying to produce a product price list from a table that records all the
price history for each item. The query should show only the last...
|
September 14th, 2005 12:37 PM
by FA
|
9 |
257 |
|
|
|
September 14th, 2005 02:25 PM
by Tracy
|
0 |
83 |
|
|
unique values by
wimsan
Hi there,
i have a table that has duplicate values (maximum 2) for the field AWK_ID
which is OK because 1 AWK_ID can refer to different products.
i would...
|
|
2 |
94 |
|
|
ODBC call failed by
PegGall
I am trying to run an append query and am getting the following error:
SQL0952N Processing was cancelled due to an
interrupt. SQLState=57014 (#-952)
I am...
|
|
3 |
303 |
|
|
|
|
4 |
126 |
|
|
Runs on Theirs, Not on Mine by
Christopher Weaver
A query designed by someone else includes the following:
SELECT Left(,4) AS YR
It runs on my client's machine but not on mine. The error message I get...
|
|
2 |
88 |
|
|
|
September 14th, 2005 06:06 PM
by Victoria
|
1 |
75 |
|
|
Adding data in fields together by
Kristina H via AccessMonster.com
Hi there,
I am trying to make a referral database for my boss.
I have two tables REFERRALS and CODES.
In REFERRALS, the table contains surname,name, date...
|
|
2 |
88 |
|
|
Group by by
neeraj
Order # Service
1 A
1 B
2 A
3 A
3 B
3 C
.....
I have the above query in which orders...
|
September 14th, 2005 06:31 PM
by neeraj
|
4 |
94 |
|
|
IIf and parameter query by
Amy Blankenship
Hello, all;
I am trying to return just the records for a given course if the course id
is given in the parameter of a parameter query, or all if the course...
|
|
2 |
103 |
|
|
Query one record in table by
Gibson
Is there a way to query one record from a table. Specifically say the second
record or the third record. I mean the criteria would not be specific data
it...
|
|
1 |
84 |
|
|
|
September 14th, 2005 07:05 PM
by tina
|
5 |
295 |
|
|
|
|
2 |
129 |
|
|
Query from form - again! by
Gil Lopes via AccessMonster.com
Hi folks! Sorry, but I really need urgent help.
I have a table with the following fields:
Date info1 info2 info3 info4 info5
I made a...
|
|
1 |
77 |
|
|
SQL Join statement by
margaret
I have a table (Class Table) ....
Class ID (Key), Division, Class Description, and Class
On my second table I have
Entry # (key), Division and Class
I need...
|
|
3 |
116 |
|
|
need only the records where..... by
tamxwell
This query is for agings debts. I want only to pull the records that are 1-45
days old. I've tried a number of ways ,but it still gives me all 56000
records...
|
September 14th, 2005 09:16 PM
by tamxwell
|
2 |
85 |
|
|
ADD MONTH -1 by
ESHTA via AccessMonster.com
Hello...
I have table with these values:
Date Product Imported Exported Total
I want to view the data of the current month...
|
|
2 |
91 |
|
|
|
|
1 |
103 |