|
|
Keeping 12 months of records by
hoachen
The data i have is: Jan - dec 09 and Jan 10 and Feb 10 and will add each
month after that. I don't want to keep all of the months. I just want to keep
like...
|
February 8th, 2010 03:46 PM
by hoachen
|
6 |
142 |
|
|
|
|
6 |
215 |
|
|
Querying using SQL statement by
Joe[_22_]
Hi
Using an expression as follows...
SELECT IDCustomer AS Code, Name, Address FROM Customers
....the AS clause doesn't work in Access 2007.
Running the...
|
|
5 |
111 |
|
|
How to lock viewing Form Design. by
naveen prasad[_2_]
Hi all,
In my Access project every thing is perfect...
In Startup- main form as starup form.
unchecked view database window.
...
|
|
4 |
132 |
|
|
ODBC--Call failed. by
cluckers
I am running a query. One of the field's I am filtering. If I use a "Not
Like" criteria the query runs fine, takes a second. However, if a use a
"Like"...
|
|
4 |
144 |
|
|
|
|
3 |
155 |
|
|
|
February 7th, 2010 04:10 PM
by fredo97
|
3 |
108 |
|
|
|
|
1 |
156 |
|
|
|
|
1 |
141 |
|
|
DLookUp by
alhotch
I have two tables - tblEmployees and tblActivities. The tblEmployees table
has three fields - fldEmployeeID (number type); fldLastName(text type); and...
|
February 7th, 2010 05:19 AM
by alhotch
|
4 |
134 |
|
|
Find Min Value in Row or Selected Cells by
JCowell
I have a query where I have product SKU's with various Pgrogram Prices. I
want to create an expression to look at these multiple prices and return the...
|
|
1 |
108 |
|
|
sum for past tweleve months by
tighe
i feel a little retarded i can’t pull the available information together to
get the result i need. i have looked at
http://support.microsoft.com/kb/208714...
|
|
7 |
261 |
|
|
Check for Values by
alecgreen
Hi
I have 2 tables, requirements and stock on hand. In the requirement
table, I have a part number, qty and due date and a related record in
the stock on hand...
|
|
1 |
186 |
|
|
Crosstab Query - Column Heading Dates by
Bob
I am running a crosstab query however the column heading with the dates is
not in order. Instead of 1-2005, 2-2005.etc, I am getting 1-2005, 1-2006,
1-2007,...
|
|
4 |
128 |
|
|
|
|
1 |
180 |
|
|
|
February 6th, 2010 01:04 AM
by Antney
|
2 |
146 |
|
|
how do I put these 2 queries into 1 ?? by
dannie
What I would like is 1 query that displays the columns Area , CountofArea,
CountofArea2. I tried using the design query but it put a LEFT JOIN on the
whole...
|
|
3 |
124 |
|
|
group query by
Ian C
I'm trying to create a query that gives me the average price of each product
based on the last 10 purchases.
The table is called "t_worksheet", with fields...
|
|
1 |
128 |
|
|
Delete Query by
GLT
Hi,
I am trying to create a delete query that deletes records older than a
specific date, the date is entered by a field on a form by the user. All
records...
|
February 5th, 2010 11:33 PM
by GLT
|
6 |
138 |
|
|
Subquery by
hoachen
I am trying to compare two fields data if there are match.
Table 1:
item#
123
Table 2:
Item# ItemName Edition creator
123 Name1 05 ...
|
|
2 |
113 |