|
|
Help to Exclude Records SQL by
rebelscum0000
Dear all
I have 2 Tbl's one Called Search_Tlb & Documents_Settings_Tbl with the
same fields
In the tbls I have a field called FolderPath, with these...
|
|
2 |
111 |
|
|
|
|
0 |
95 |
|
|
Searching on more than one keyword by
John
Hi
I have a client table. User provides four keywords and I need to select
clients whose names contain any two of the given keywords. How do I go about...
|
November 27th, 2006 01:33 AM
by JK
|
5 |
140 |
|
|
Help to find unmatched data by
Mattias
Hi
I am trying to find the best way to find unmatched data.
I have tried this below and found a few but not all unmatched data, still
having...
|
|
4 |
205 |
|
|
display even if no entry by
miss031
I made a query for an invoice. It has several tables in it. One of the tables
is the items that the customer purchased, and one is how they paid.
The...
|
|
1 |
99 |
|
|
Merging tables by
John
Hi
I have two tables with two columns each. Each table has an id column and a
value column. I would like the two tables to be merged so there are three...
|
|
5 |
113 |
|
|
access hell! by
Carrie
I am trying to find the average days between orders and shipments for
2001, grouped by employee. Every time I put the fields in it asks for
ship date and order...
|
|
2 |
95 |
|
|
Parameter query on expression field by
M. Halgas
I am trying to set up a query/report for exam due dates. So, for instance,
individuals should have a dental exam every 6 months. I would like to run a...
|
|
2 |
94 |
|
|
Running a saved query by
John
Hi
I need to run a saved query and just need to know if there are any records
returned. Not interested in actual records. What is the easiest way to do...
|
|
3 |
109 |
|
|
Help With Expression Query by
CS
I have a simple expression query that I just can not get.
I have a table called discs, in this table there is a logical field (yes,no)
called clubs. I want to...
|
November 26th, 2006 02:32 PM
by CS
|
3 |
103 |
|
|
Multiple Query Counts by
Jeff
I had a question about a count query. I have parent records (literally
about parents) that include a date when the parent came in for the
first appt. Based on...
( 1 2)
|
|
14 |
194 |
|
|
Vista and MS Access by
B Golden
Has anyone else tried MS Access (2003 or 2007) with Vista RTM? I have Macro
that lets a series of 130 or so queries that churn thru a large database
(280k...
|
November 26th, 2006 03:49 AM
by B Golden
|
0 |
87 |
|
|
|
|
9 |
139 |
|
|
Calculated field, sum/avg results of qry? by
Rwh5757
I need to calculate a field in query which uses two values in two fields
(field1, field2) to run a query, then sum and average all the values in two
other...
|
|
3 |
102 |
|
|
iif by
sierralightfoot
I have the following expression
GGWPERSQFT: IIf(IsNull(),/,/)
but I want to add:
if is zero, then null
otherwise IIf(IsNull(),/,/)
|
November 25th, 2006 07:09 PM
by tina
|
1 |
131 |
|
|
output query changes font color by
Kendall
I am trying to run a query on expirations of certifications of employees.
My query runs and checks 7 dates to see if they are expiring within the next
30...
|
|
1 |
112 |
|
|
Change title (?) by
an
Hi!
When we run a query, display title:
Enter Parameter Value
Is it possible to change this title?
Thanks in advance.
an
|
November 25th, 2006 11:57 AM
by Homie
|
3 |
97 |
|
|
Summing Checkboxes by
Jeff
Just curious -- why is it that when I sum up check boxes on a record,
the value in the query is Yes/No (even though I can click on the value
and see the...
|
|
2 |
95 |
|
|
Problems with date query by
Charles in Iraq
Greetings.
I am building a query to return all records between dates selected
by the user.
When I use the following code to build my query, the date...
|
|
3 |
110 |
|
|
|
|
5 |
84 |