|
|
Different destination fields by
Shaun
Hi All,
I've got 2 fields in my database that represent Easting and Northings. Due
to the way the client's db is set up, I need to append each of these...
|
|
3 |
106 |
|
|
Change Table in query by
Aurora
I am using Access 2003
A couple of years ago, I created a query to append employee files from my
active Db to a Retiree Db. I need to do this again and want...
|
|
1 |
113 |
|
|
Update Query Help by
Golfinray
I am trying to do an update query on 07-09 A2 from 07-09 A. Both are date
fields on tables. The only problem is there may be 2 or 3 records that have
been...
|
|
3 |
93 |
|
|
re-coding values by
Bluesky
I know this is simple to do, but can’t seem to do it correctly!!
I have a “final_status” variable field that contains values such as “active”...
|
|
6 |
100 |
|
|
Complicated Query Update by
Alex
I have a table with a field called FUND (Range from 1 to 10,000) and another
called Class_Type, which is Null. Weekly, the data is deleted and replaced
with...
|
May 13th, 2008 07:20 PM
by Alex
|
4 |
98 |
|
|
Crosstab: how do I group dates by month? by
Rachel Garrett
I have a crosstab query where the dates are the column headings. What
is the best way to group them by month?
I found a Microsoft article talking about how to...
|
|
1 |
92 |
|
|
Between statement using Like by
Crazyhorse
I have a Timestamp field. It contains the date and time. I need a date range.
Between and works but this
field has a time stamp after the date. Like & "*"...
|
|
7 |
89 |
|
|
|
|
3 |
91 |
|
|
|
|
1 |
94 |
|
|
Append Problem by
Mart
Trying run an Update query to update table values with value(s) from a joined
Query. I've tried the usual JOIN options and the following is my latest...
|
May 13th, 2008 04:46 PM
by Mart
|
4 |
92 |
|
|
design grid total line question. by
JH
In the design grid I have created a total line that has several group bys and
firsts. I get the data I need but the column headings now say firstof and
then...
|
May 13th, 2008 04:11 PM
by JH
|
2 |
119 |
|
|
Form Questions by
benbanyas
I have a problem that I hope can be fixed by one of two solutions.
On a Form, I have a "Keywords" field for labeling items being entered into a
database. Some...
|
May 13th, 2008 03:50 PM
by Jake
|
1 |
74 |
|
|
|
|
1 |
90 |
|
|
Criteria by
JennBard1
i want to be able to pull up info from a certian company. Haw do i code it to
search for this company. My previous criteria wsa which meant
that you had to...
|
|
3 |
115 |
|
|
Syntax error in insertinto statement by
Sanju
Hai,to every one
here is my question
I have designed the coding to collect the feedback report from the user,
which includes Name of the user, staffno and...
|
|
3 |
121 |
|
|
Passing Function values to a Query by
FBxiii
Hi. I think this may be impossible but I will ask anyway!
I have created a function that evaluates 2 values from fields in a query.
The function passes a...
|
May 13th, 2008 12:53 PM
by FBxiii
|
6 |
93 |
|
|
Help with query by
SF[_3_]
Hi,
I have the following:
SELECT .Communes, ., ., (nz()-nz())/(nz()+nz()) AS
Percentage
FROM
ORDER BY .Communes;
|
|
2 |
112 |
|
|
|
|
2 |
98 |
|
|
Set up mask on parameter value by
John
Hi all,
I have a query when you run it then it will pop up a little screen asking to
enter begining date and ending date. I was wondering if I can set a mask...
|
|
3 |
143 |
|
|
Delete Query wont work by
duke_man
I have a table with some duplicate records I want to delete automatically.
I found this on line help...
|
|
3 |
125 |