|
|
Like / IIF issues (as query criteria) by
sha123
I have been working on this for hours and still cant figure it out....
I have a combo box that selects a description call "land"
I want my query to be able...
|
|
2 |
108 |
|
|
Summing Check Boxes by
GoBrowns!
Can someone please check this over?
I am trying to create a query to sum some fields and some check boxes.... I
keep getting an error that I am missing an...
|
|
3 |
102 |
|
|
|
|
3 |
120 |
|
|
|
|
3 |
115 |
|
|
|
July 17th, 2009 02:13 AM
by Miltos
|
2 |
117 |
|
|
Sorting in a Cross Tab Query by
PerryK
I have a basic Cross Tab Query that is feed by a table that is updated monthy.
The months are labled as 200901, 200902, 200903, etc..
The are also lines for...
|
July 16th, 2009 09:36 PM
by PerryK
|
2 |
116 |
|
|
Combining Queries by
AGOKP4
Hi,
I have a query I'm trying to "split" so it comes out by sex. the original
query is:
TRANSFORM Count(.) AS
SELECT ., Count(.) AS
FROM
GROUP BY...
|
July 16th, 2009 09:20 PM
by AGOKP4
|
4 |
116 |
|
|
Date subtraction by
Stephanie
Hi.
I'm trying to perform a date subtraction between incident date and discovery
date, but I can't get the syntax correctly. I'd like to have the output in...
|
|
3 |
121 |
|
|
|
July 16th, 2009 07:31 PM
by tpeter
|
11 |
179 |
|
|
Pull criteria from a Form by
QB
I set a query to pull its`criteria from a form using
Forms!.
That said, I now have a twist and need help in addressing it.
The control in question is a...
|
|
2 |
103 |
|
|
"Enter Parameter Value" dialogue boxes by
zufie
I can't figure out why when I open my database the "Enter Parameter
Value" dialogue boxes for the Date From and Date To textboxes appear
on the screen.
These...
|
|
2 |
137 |
|
|
Report Summary by
LG
I built a query with the following:
Date ID Num of Clms (control source= countofbatchid)
I created a report and would like to have the total number of...
|
July 16th, 2009 06:45 PM
by LG
|
2 |
90 |
|
|
making age group query work by
Linda in Iowa[_2_]
I recently posted this and received a reply as follows. Can anyone tell me
how to make it work as I have not been able to get correct results if any.
I am...
|
|
7 |
141 |
|
|
Maximum Value in 2 fields of a record by
Williams
My table has 2 fields and . I need to
compare these fields if they are both not null and take the latest date. Is
it possible to compare 2 fields in the...
|
|
1 |
100 |
|
|
Importing Date fields from Excel by
Pete
I am importing a worksheet from Excel. The date columns are displayed in
mmm-yyyy format, though the data shows on the formula bar in mm/dd/yyyy
format. ...
|
|
2 |
155 |
|
|
|
July 16th, 2009 03:26 PM
by spark
|
9 |
174 |
|
|
Convert Date by
Jennifer
Our DB2 tables has the create date field data type as "text" with the
yyyymmdd format. I'm trying to convert to mm/dd/yyyy; but also need to change
it to...
|
|
1 |
84 |
|
|
Case Sensitive Query by
carl
I posted this question a couple weeks ago and want to thank you for offering
your help. I tried to follow the replies but still cannot get a quesry to do...
|
|
7 |
123 |
|
|
|
|
3 |
110 |
|
|
Date Difference limited to 100 years by
Richard S.
I have a query to extract all persons with an age eaual to or greater than a
user-entered paramater (criteria). The expression
(Year(Date())-Year(.)) when...
|
|
6 |
110 |