|
|
Quering 2 unrelated (apparently) DBs by
Phil
I have a DB of parts requiring machining and a DB of machine shops that can
do at least one of the machining operations. I want to select a part, then
the...
|
|
1 |
141 |
|
|
User function on report? by
Starry
I have a report that has to do the following
take total number of hours for a given worker on a given day
send this through a whole bunch of rules to churn...
|
|
2 |
141 |
|
|
Calculating Date by
Yeahyeahyeah
Hi there,
I have a query that pulls information on contracts that run in annual
cycles. Each record for each contract has a "renewal_date" and based on this...
|
|
2 |
196 |
|
|
I need help working with parameters!!!! by
Kdahlbeck
Hello and thanks in advance for answering my question!
I am working on a query involving 3 seperate fields. What I want to do, is
to be able to use...
|
|
3 |
147 |
|
|
|
February 21st, 2007 09:55 PM
by Donovan
|
2 |
149 |
|
|
Convert Text to Number by
mattc66 via AccessMonster.com
Hi All,
I have data that is coming from an external source. I have to strip out a
number out of a text field. However I need to then link this number to...
|
|
2 |
220 |
|
|
Filter by date on a field that uses now() by
tarheelkate
In my table I have a field that calculates when any given record was created.
I did this by setting the defalut value to "now()". I changed the format so...
|
|
5 |
142 |
|
|
|
February 21st, 2007 09:38 PM
by Ric404
|
4 |
156 |
|
|
Count days with entries by
RA
I'm brain dead at the moment!
I need to count the number of days that have an entry in my data. Some days
may have multiple entries so if I pull a count I...
|
February 21st, 2007 09:34 PM
by RA
|
2 |
174 |
|
|
Create 3 separate fields from one by
SYDNEY02
I have a table with an item field that can consist of an item #, a sub
assembly item #, and sub-sub assembly item # separated by periods. I need to
break...
|
February 21st, 2007 09:12 PM
by Ron2006
|
1 |
148 |
|
|
|
|
1 |
146 |
|
|
|
February 21st, 2007 08:23 PM
by Sandy
|
2 |
152 |
|
|
Calculating Gross from multiple Tables by
Keensie
I really need someone’s help. I have two tables, one has employee’s
allowances and the other has their basic pay. I need to calculate their
gross. The...
|
|
1 |
231 |
|
|
|
February 21st, 2007 07:33 PM
by Steve S
|
2 |
376 |
|
|
problem with inserting in two tables by
michel
Hi,
i have to insert values into two tables in one transaction.
The first table (base table) has a primary key (type 'integer') which is
incremented...
|
February 21st, 2007 06:40 PM
by michel
|
2 |
184 |
|
|
STATE EMPLOYEE REQUESTS QUERY HELP! by
ST8 EMPLOYEE
I need a query that will give me a value of 1 for each record that is not
null in any one of twenty fields (text datatype).
In other words, I need to search...
|
|
3 |
178 |
|
|
Query on Change by
Novice2000
Hi,
I have a table with two columns where the value may have changed and may not
have changed - for example Group 5 to Group 10. I want to query so that I...
|
|
2 |
207 |
|
|
|
|
1 |
182 |
|
|
First record by
dc
I want to group data so that I can see the total risk applicable to a
merchant ID and name of merchant. The names of the same merchant are
recorded in...
|
|
1 |
161 |
|
|
internal OLE automation error by
xicogoes
When I was making a simple query I´ve got this message "internal OLE
automation error" and I don't know why.
Can anyone help me please?
Thanks
|
February 21st, 2007 02:52 PM
by xicogoes
|
0 |
307 |