|
|
|
|
5 |
108 |
|
|
|
|
8 |
156 |
|
|
transpose table query by
Souris
I have data table like following
Emp No Activity Date A1Value A2Value A3Value A4Value
1 3/20/2008 10 15 10 ...
|
March 25th, 2008 01:35 PM
by Souris
|
7 |
109 |
|
|
Compare numbers by
Abrm
Hi ,
I am making a comparison with 3 numbers in many records
Nr1 is a static number
Nr 2 and 3 are variabel.
I would like to get the number that is the...
|
|
2 |
82 |
|
|
Use response to prompt in a report by
lfcjr
I have a query which prompts for a date range. I would like to be able to
save the user's response and use the range in the title of a report. Is this...
|
March 25th, 2008 11:39 AM
by lfcjr
|
4 |
111 |
|
|
|
|
5 |
114 |
|
|
Why this is not working: column(1) by
Marco
HI.
I trying to create a query with this criteria:
!!!column(1) and it's not
working. It also retrieves me the folowing information: Undefined...
|
|
5 |
140 |
|
|
Date Range by
MRCUSA
Hi
I have a database for rentals, with an arrival date field and a departure
date field. It is easy to count the days between one and the other.
The question...
|
March 24th, 2008 11:43 PM
by fredg
|
7 |
112 |
|
|
|
|
1 |
88 |
|
|
|
March 24th, 2008 08:50 PM
by Rafi
|
3 |
119 |
|
|
Smart Parameter Query by
acss
I would like my parameter query to provide all records if left blank or if
the end user only knows the first 3 letters of a name then it should records
with...
|
|
1 |
61 |
|
|
If Null Update by
Aaron
Hello,
I am trying to create a update qry that if the value in tbl ITEM is null
update from table SUB on Field Description. So far I have..
Field:...
( 1 2)
|
March 24th, 2008 08:11 PM
by Klatuu
|
11 |
179 |
|
|
|
|
1 |
83 |
|
|
Separate Data by
rml
I have a table with a field that has data that looks like the following:
N0345, H4354, 48574, 48577
How can I create a query that would separate that data...
|
|
2 |
89 |
|
|
|
|
0 |
134 |
|
|
Query using criteria Like Get_Find? by
bmac
I've come across a query someone created and it has criteria pulling dates.
Could someone explain to me this criteria: Like Get_Find
Field : oDate:...
|
|
3 |
98 |
|
|
validation for append query help? by
Cam
Hi,
I am creating an append query so I can track all historical data because
once the orders in WIP (orderWIP table) are completed, they will be removed...
|
March 24th, 2008 05:14 PM
by Cam
|
7 |
104 |
|
|
Filter using a Macro that runs a Query by
Chris DP[_2_]
I am using Access 2007. In a previous version I created a simple query that
enabled a search on Company Name; Like "*" & & "*", which
was written under...
|
|
1 |
104 |
|
|
Query Date Help W/Avg work days by
aldunford
please note that in order to get the date 6/28/1979 I am using average work
days each month of 21.75
I have tried to Add just the total days to the date but...
|
|
7 |
100 |
|
|
Dialog Box - Drop down list by
Debra
Hi,
I have reports set-up which run from queries- the user is asked to enter the
month which in turn pulls all training records for the month entered. Is it...
|
|
2 |
135 |