|
|
How to get the Value from a Table field by
newsneakers
I'm trying to call a "value" from a field in a table instead of the
underlying number -
Basically I have this:
A table called Projects with seven columns...
|
|
1 |
94 |
|
|
|
|
20 |
316 |
|
|
|
|
3 |
115 |
|
|
|
March 31st, 2006 12:16 AM
by Phil
|
3 |
184 |
|
|
How to use SQL variables in VBA by
schoultzy
Hello, I have the following SQL code:
DECLARE draw_num2 int
SELECT draw_num2 = max (draw_num)+ 1 --THIS LINE IS MY PROBLEM
FROM hdx_housing_assign_master
I...
|
|
2 |
82 |
|
|
Record the Record Number in A Query by
Ross
Is there a way to have a field in a query which displays the current record /
line number of each record in the queries' recordset.
I want to avoid using...
|
|
7 |
190 |
|
|
update select fields by
rcard-newbie
First - I'm a newbie to Access. I have 4 files (representing 4 FY quarters)
that I am trying to integrate into a single master file. I need to
selectively...
|
|
2 |
98 |
|
|
help with if statement by
dlb1228
how do i do this in a query if my field equals N then take another field
and multiply by 1 else if field is a T then multiply by 1.2
i thought it would be...
|
|
5 |
103 |
|
|
|
|
3 |
115 |
|
|
DateAdd by
Akrt48
I have a really weird problem and not sure why. I have a calculation doing
nested iif's seven of them. I kept getting an error message and it pointed
to the...
|
|
4 |
103 |
|
|
Struggling with query by
LHEMA
I am new to access...I am need of help!! I have been working on this project
for about a month trying to get it to work. This is the problem I am trying
to get...
( 1 2 3)
|
|
22 |
410 |
|
|
|
|
11 |
185 |
|
|
Can this be done. by
[email protected]
Can someone tell me if this is close and if it can be done
IF ctl.control Source in CurrentDb.Querydefs("Maps and Plans Query")
then
Wherestr = Wherestr &...
|
|
3 |
87 |
|
|
split address into 2 fields by
denise
I need help finding a way to do this. I have the addess in a field were addr1
is followed by a line feed then addr2 portion follows. I can identify...
|
March 30th, 2006 07:13 PM
by denise
|
5 |
91 |
|
|
Add a range of dates to a table by
Kevin
Can I write a query instead of using the append funtion to add a range of
dates to a table? If this can be done, what is the function for the query?
Thanks
|
March 30th, 2006 07:10 PM
by Kevin
|
2 |
102 |
|
|
Parameter query, null value in (table) field by
Graeme at Raptup
I have a parameter query with many criteria, such as ' Like !! & "*" '
I though it was working fine until I discovered that it only returned
records where...
|
|
1 |
92 |
|
|
Formula/table assistance by
Dechienne
I need help with the fine details behind this idea:
Need to pull a weeks worth of data from a database (Outbound - Total : Date)
I have a date conversion...
|
|
2 |
183 |
|
|
queries with combo boxes!! by
dara
Hi guys,
I was recommended this site as the best place to find solutions for those
problems that take ppl like me days to solve but you guys just seconds!!
I...
|
|
1 |
104 |
|
|
|
|
1 |
79 |
|
|
Showing No Duplicates by
Brad
Simple question.. I think
My query is showing the same name 2 times I want to only see the name one time
Example
Staff members Vacation Pay
John
Bill
Tom
Bill
|
|
6 |
116 |