|
|
date format conflict by
steve mckenna
I have a database that searches for documents by date of
document and date received. If the exact date is not know
I have set up a parameter query that allows...
|
|
5 |
223 |
|
|
parameter query by
brian
Hi,
I want to build a parameter query where 2 parameters are
selected from two comboboxes on a form.
My problem is I also want to have a "select all"...
|
July 13th, 2004 01:27 PM
by brian
|
1 |
239 |
|
|
Date Calculation by
KP
Hi, I hope you are doing well.
I have two dates, Last Reviewed and Next Review Due. I'm
trying to set up query to select records that are within
30, 60 and 90...
|
|
1 |
79 |
|
|
|
July 13th, 2004 02:12 PM
by JonR
|
2 |
141 |
|
|
Need Maximum Value by Day by
bill
I have annual data tables with 24 hourly values per day.
There are multiple columns containing different data
values, or parameters.
I need to do some quality...
|
July 13th, 2004 02:45 PM
by Bill
|
2 |
76 |
|
|
link data fields in a form by
Shannon
How do I link fields of data in a form
For example, i have an entry form for users that i want
everytime the user enters a particular ID for a new form,
the...
|
|
3 |
364 |
|
|
LIKE problem by
Alejandra Parra
h_anagra H0014
1/1
10/10
1024514785/PAIA811014
1234567890/PAIA810909
654/654
NSSTT000/TTTTT00000
124/1421
154/154
NSS002/CURP002
|
|
2 |
133 |
|
|
query by
Kathy
I have a parameter query. The parameter query dialogue
box works fine for our needs, however when the query is
run it only searchs the fisrt word in the field...
|
July 13th, 2004 08:29 PM
by
|
1 |
115 |
|
|
Switch function in crosstab query. by
Karen
I have created a switch function in a crosstab query to combine data into specific column headings. However, I need to have static column headings for the...
|
July 13th, 2004 08:36 PM
by
|
1 |
542 |
|
|
Query doesn't work on Win98 workstation by
Bill
Hello,
Thanks for looking in. Does anyone know why a query might
work on a win2k Pro workstation but not on a win 98
workstation. I am using Office 2000 to...
|
July 13th, 2004 08:53 PM
by
|
1 |
134 |
|
|
UNION query question by
Dale Peart
This question relates to an earlier post (7/9/04).
I am trying to combine all the records of Table1 with all the results of
Query 1 and Query2. The tables...
|
|
6 |
1,054 |
|
|
Table comparison problem by
Michael Pierson
I am comparing 2 cash receipts tables for the same time
period.
The tables are comprised of client,invoices and costs.
Table 1 has costs that total $1Million....
|
|
1 |
116 |
|
|
A tough problem by
Tim
Hi folks,
I need a urgent help on my query. I have Sales and
tblField tables
Sales table have the following field:
Invoice
Code
Amount
|
|
1 |
91 |
|
|
SQL Parameter Query Code & Nulls by
Ben Bayliss
Hi All,
I'm having a problem fixing this query.
Basically as the code suggests, I'd like to construct a query's
parameters on the fly depending on what the...
|
|
2 |
555 |
|
|
EXPRESSION IN A QUERY by
Peter Schweiss
Hello,
I need help to write an expression in my query. Here is
the criteria...
The field Is-Returned correctly..
There are 2 possible entrys for this feild,...
|
|
2 |
235 |
|
|
Add leading zero by
Jay
Location_Num Machine Number
06 DUD006
07 DUD007
07_1 DUD07_1
08 DUD008
09 ...
|
|
1 |
102 |
|
|
|
|
2 |
351 |
|
|
line numbers by
Al V
Hi,
Have a field for order number. An order can have more
than one line item. How do I create a field called "Line
Number" and force it to start at one and...
|
|
7 |
366 |
|
|
Averages in a report. by
Rog
I have a query that I need to run several times, each time with a different
filter on one specific field. I then want to run a report containing and
average...
|
|
1 |
93 |
|
|
Multiple Table Query by
GaryLancs
I have 3 main data tables, Table 1 “SR”, Table 2 =
“CN” and=20
Table 3 “NMPI”, and they have been linked so=20
Table1...
|
|
1 |
483 |