|
|
Time() - 5 minutes by
Scott
I have an update query that adds the time to a field as well as various other
updates. I am trying to run a subsequent query that I am trying to get it to...
|
May 2nd, 2008 08:00 PM
by Scott
|
2 |
101 |
|
|
|
|
7 |
134 |
|
|
Help with and Update query by
Brian
Hello,
I have an Access table with
tmpReportIndex PgNo AcNo NumPgs
1 0010 0
2 0010 0
3 0108 0
4 0108 0
5 0108 0
6 0138 0
|
|
7 |
115 |
|
|
COMBINING TWO QUERIES by
JOE POLLOCK
I HAVE TWO QUERIES WHICH I HAVE PRODUCED REPORTS FOR. ONE QUERY REPRESENTS
SALES FROM YEAR 1 AND THE OTHER SALES FROM YEAR 2. WHAT IS THE BEST WAY TO
COMBINE...
|
|
3 |
152 |
|
|
Union Query Removing records by
Emma Aumack
Does anyone know why a union query would remove records?
I have three data tables that I combine to get total sales and for some
reason when I use the union...
|
|
4 |
153 |
|
|
|
May 2nd, 2008 05:08 PM
by Freida
|
4 |
107 |
|
|
convert to number by
Rich[_14_]
When defining a field being used in a query, how do I convert it's
format from Currency ( typical ex. $12,575.22), to the straight number
12575.22 ...
|
|
4 |
125 |
|
|
|
|
1 |
105 |
|
|
Delete dups in a table by
Dominick D.
Hello, I have a table of 280K rows; in this table, I have many dup rows. It
looks like this:
101
102
..
..
20405
20405
20405
|
|
3 |
129 |
|
|
HELP with Query by
Robin
Here's my problem: Sales tax= If a customer lives in CA, calculate the sales
tax as 7% otherwise calculate sales tax as 5.5%. How can I build a
calculation...
|
|
3 |
138 |
|
|
|
|
3 |
96 |
|
|
Selecting Distinct Memo Fields by
Daffy
I know that an error will occur when setting up a Query to display Distinct
records of a Memo field. I also know that there is a work around this, which...
|
|
1 |
84 |
|
|
Top 3 of multible catorgies by
Ed Jordan
SELECT Patrols.Level, Events., Patrols.,
Patrols.Troop, !*0.75+!*0.25 AS Expr1
FROM Troops INNER JOIN (Patrols INNER JOIN (Events INNER JOIN Score ON
Events....
|
|
2 |
93 |
|
|
Problem with percentages by
Golfinray
I have a table and query for an index. The index runs from .0000 to .995.
There can be many different numbers of decimal places, like .333560000 or
just...
|
|
2 |
98 |
|
|
Help with Query by
SX
I have a set of data.
In the field there are datas such as
Diet, Health
Diet, Non-Fiction
Romance, Health
Non-Fiction, Diet
Romance, Diet
|
|
2 |
98 |
|
|
|
|
2 |
121 |
|
|
|
|
3 |
122 |
|
|
Crosstab query problem by
Bongard
Hi I have a crosstab query that only has two records. It is a very
simple query with a sum field that is working for one of the records
but not the other. Here...
|
|
6 |
101 |
|
|
|
|
1 |
114 |
|
|
|
|
1 |
98 |