|
|
writing syntax by
aubrey
can you write a syntax that says if text in one field is "x" take the date
from another filed add 45 days and populate a third field
any help would be...
|
|
7 |
191 |
|
|
|
|
5 |
343 |
|
|
Case or IIF? by
NBullock
Might there be a better way? I am trying to pull text from a field in one
table and then assign those records to that result. For example, if the
printer...
( 1 2)
|
|
18 |
322 |
|
|
|
|
1 |
181 |
|
|
Query Question - I don't know by
Golfinray
Is there a way in a query to have let's say three fields and do this:
If this field is not null OR if this field is not null OR if this field is
not null then...
|
|
4 |
180 |
|
|
Help Designing a Query to Count Classes by
Robert T
Hello:
tblClasses
-----------
I thought designing this query would be easy, but it's turning out to be
harder than I anticipated. Obviously I'm doing...
|
|
7 |
189 |
|
|
Help needed with SELECT query by
PO
Hi,
I need some help with constructing a SELECT query:
WONUMBER PARENT AMOUNT HASCHILDREN
===========================================
1234 ...
|
|
2 |
216 |
|
|
|
July 3rd, 2008 03:09 PM
by hfrupn
|
4 |
261 |
|
|
Crosstab Query by
acccessaccess2003
I have a crosstab query created and generates the following result set.
1 5 4
2 4 2
3 3 0
Is there any way...
|
|
2 |
155 |
|
|
Combo box use as a Query... any help by
fossy
I have a query (qryTrainingByTile) and a form (frmUpcomingTraining). In the
form is a combo box (Select Title) that selects the title record from a
separate...
|
|
3 |
191 |
|
|
Query on a Query by
Brampton76
I have a query that has presented the following result: Name, Competition
Name and Playing Option. I also have a separate table that contains the...
|
|
4 |
188 |
|
|
"Setwarnings" option not available by
theintern
I'm trying to supress those warning messages everyone else is annoyed with
too, but I don't have the "setwarnings" option in the pull down menu of the...
|
|
2 |
253 |
|
|
|
|
2 |
204 |
|
|
Annual update of Queries by
mimf
Is there a shortcut to updating the table name that is in all of my Queries?
Each year we start with a new table again and I have to go in and manually...
|
|
4 |
174 |
|
|
Switch not working by
Student Databaser
So after trying about a million things, i figured out how to use the switch
function, but now for some reason it is excluding some records. When i run
the...
( 1 2)
|
|
10 |
305 |
|
|
Total count for crosstab query by
HOCSMGR
I am working on a query to show the vendor_name and the total number of
pieces the user completed for a certain date. I am pulling the info i need
but having...
|
|
5 |
149 |
|
|
Query set-up help by
Michelle
I need some help. I have multiple tables that I want to combine. All of the
tables have the exact same setup. Let's say there are 2 fields, ID and
Amount...
|
|
1 |
166 |
|
|
|
|
7 |
288 |
|
|
Which Query by
DNork
Situation: I have a table with many fields including a "status field" and a
"dues amt" field. Status is either "member, "Non member" or "LOA Member". I
am...
|
|
3 |
170 |
|
|
|
July 2nd, 2008 06:14 PM
by Sajit
|
7 |
163 |