|
|
|
|
2 |
79 |
|
|
a little complicated for me by
Claes D
Hi.
Since I'm just a novice, I need some help with this.
In a query, I need to have a category on each article.
The Category is based on the size and code of...
|
|
4 |
101 |
|
|
Show records with dates 30 days old by
Lewis M
I need to know how to build an expression or use a date/time function in a
query to show records with a date that is more than 30 days old.
|
October 15th, 2006 11:30 AM
by Lewis M
|
6 |
84 |
|
|
|
|
1 |
101 |
|
|
|
|
1 |
96 |
|
|
if null or zero by
sierralightfoot
Simple but I can't get it:
if is null or equal to zero, then , otherwise
|
|
9 |
133 |
|
|
Totaling Query by
F1stman
Hey all,
Let me try to explain this. I am creating a query to take the sum of
transactions for a certain ID# in one table and subtract them from the
original...
|
October 14th, 2006 06:53 PM
by F1stman
|
3 |
79 |
|
|
|
October 14th, 2006 03:41 PM
by Kc-Mass
|
3 |
72 |
|
|
Data in table but not in Query/Report by
magicpatel
I have a form that saves data to various tables using code, and this
all seems to work.
But when i try to run a query on some of the tables, some data...
|
|
3 |
65 |
|
|
|
|
1 |
64 |
|
|
exporting to excell by
Neal
Hello,
I have a query that excel pulls from. When excel pulls the data I lose all
formatting in the cell and then have to go through each line and hit...
|
|
1 |
76 |
|
|
Date Criteria - Last Month same day by
yasser
I'm trying to run a query from the Sales Table that will give me a snapshot
of today's sales. I want to compare today's sales with sales from one month
ago,...
|
|
2 |
59 |
|
|
query speed / table design by
Jim
I have two HUGE tables that don't have keys but are indexed (Yes
(Duplicates OK)) on the fields I use for the join and select. There's
no keys because these...
|
|
6 |
83 |
|
|
Totaling Query by
F1stman
Hey all,
Let me try to explain this. I am creating a query to take the sum of
transactions for a certain ID# in one table and subtract them from the
original...
|
|
1 |
68 |
|
|
|
|
5 |
79 |
|
|
|
|
4 |
120 |
|
|
|
|
3 |
65 |
|
|
split text in access 2000 by
Stupid and can prove it.
My Access 2000 database has a field that contains variable quantity
of chars ending with an alpha "A". I want to remove the "A" at the end of
each one. ...
|
|
2 |
72 |
|
|
|
|
1 |
68 |
|
|
Not updatble query by
Raul Sousa
Dear all
I have the fowling query statement, returning a non updatable query.
I can not understand is it not updatable.
SELECT FacturaVenda.NIF,...
|
|
1 |
69 |