|
|
locating same text in multiple fields by
Mike Vet
I have a drug database that has 8 fields for indications. I need to search
for the same indication in all 8 fields. Example: Search for "inflammation"
in...
|
|
2 |
192 |
|
|
Query Needed by
carl
A sample of my data table looks as so:
Underlying ID ...
|
|
5 |
176 |
|
|
MS Access Query by
Bawa
Hi
I need help with this:
COnsider this Data:
Description // SW Version // Asset Tag // Machine Name // Name
Acrobat Standard// 4 // 12345 // abcde //...
|
|
4 |
208 |
|
|
Error in IIf Expression by
Pamela
I have an expression in my query to create a concatenated text depending upon
the value of control Measurements. If the control is skipped - meaning that...
|
|
5 |
148 |
|
|
Creating an index in a query by
michelle
Hello, I'm a beginner, so I don't know if this is possible. I have a query
that is pulling data from a read-only table. The two fields that I'm using
are a...
|
|
9 |
226 |
|
|
Group by month by
n09
Hey guys,
I have a table Table Children which records different vaccinations received
(children are identified by a unique ID). I want to create a query that...
|
|
2 |
164 |
|
|
Convert to text by
Prohock
I have a query that has one field that combines two other fields.
Date Length Combined
12/2/2009 3 Day 12/2/2009 - 3 day
I need the...
( 1 2)
|
January 4th, 2010 08:18 AM
by Prohock
|
13 |
266 |
|
|
|
|
11 |
440 |
|
|
Pivot Table Questions by
Jay CFA
In my access pivot table some of the data in the sheet is not visible without
scrolling. This is when I am in show detail view. When the row has 10-12
lines...
|
January 3rd, 2010 05:50 AM
by Jay CFA
|
0 |
120 |
|
|
Query needed by
subs
Table I
consignee dcity dstate dzip ocity ostate ozip
A d ak 560 b c 789
B e ck 869...
|
January 3rd, 2010 03:50 AM
by Ram
|
4 |
169 |
|
|
Week, monthly, quarterly by
Ranjith Kurian[_2_]
I have a table called as Task; this table has four columns Name, Task,
Frequency and Week.
Name: employee name
Task: Assigned work to each employee
Frequency...
|
January 3rd, 2010 12:11 AM
by kc-mass
|
2 |
197 |
|
|
How do I use varibale field names by
Greg
I have a table which has a current month info and carries a 12 month rolling
history. At the end of each month i must copy the current month's data to
the...
|
|
2 |
129 |
|
|
GANE DINERO VIENDO PUBLICIDAD by
robertcaceres6
Hola.. Os voy a contar una forma de ganar fácilmente un dinerillo
extra para
cualquier capricho o para llegar a fin de mes. Hablo de ganar dinero
por Internet...
|
|
0 |
119 |
|
|
Using " in a string expresion by
Biss
hi... Would like to use " a sting expression..
I have tried """ but doe not work..
This is what I have
html: "option value=" & & "" & &...
|
January 2nd, 2010 03:04 PM
by Biss
|
4 |
154 |
|
|
How do I count text fields? by
TonyWilliams via AccessMonster.com
I have a table which contains a text field where the value can be "PureABL"
or "HYBRID" I want to be able to count how many records where the value of
the text...
( 1 2)
|
|
14 |
216 |
|
|
Switch by
shank
Not getting the results I expect from the below Switch Function.
Given:
! = -1529
! = 12261
AOD:
Switch(!-!=0,1,
(!-!*-1)!,2,
((!-!)*-1)!,3)
|
|
2 |
166 |
|
|
querying a percentage of table info by
Cloudbuster[_2_]
If there are 3 unique groups listed in a table, is there a way I can make a
query that will show me the first 20% of records from each group, 2nd 20%,...
|
|
4 |
163 |
|
|
Update Query: Enter Parameter Value by
CC
I'm trying to set a field to a value that is stored in a variable using an
update query in VBA (Access 2003). The query prompts the user to enter
parameter...
|
|
2 |
182 |
|
|
|
December 31st, 2009 10:40 PM
by Dorian
|
4 |
254 |
|
|
|
|
1 |
136 |