|
|
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 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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
|
July 13th, 2004 02:12 PM
by JonR
|
2 |
141 |
|
|
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 |
|
|
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 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 |
|
|
querring from excel by
delali
Hi,
this is an excel/access question. i was wondering how to
make excel run a querry in access and put the result of
the querry into a spreadsheet.
thanx a lot
|
|
1 |
141 |
|
|
|
|
8 |
287 |
|
|
Finding Duplicate Records by
I have a table that contains the following information:
Auto ID, PersonName, EventName, EventDate
PersonName, EventName, and EventDate are not unique.
There...
|
|
1 |
924 |
|
|
How to work with "#error" result in a query by
David Jensen
Hi,
I have a query (below) that is returning a text string. This query will
then drive a crosstab query. in the dynaset, a few of the records are
returning...
|
|
2 |
459 |
|
|
Oracle to Access by
Ray
I am trying to create an Access dB with tables imported from an Oracle
dB....ultimately the data extracted from the Access dB will be in
Excel and dB4...
|
July 13th, 2004 02:48 AM
by Ray
|
4 |
301 |
|
|
Query by
Alan
I have a very simple database, storing information for
production Kanban cards. The user inputs how many cards
there are (ie. 1 to 12) and many other fields,...
|
|
1 |
163 |
|
|
querry newest service date by
justsomedumbguy
I have a querry named "reminder labels" that get data from "Service tabel" & "Customer Tabel'
what i need to do is have the querry get the newest service date...
|
|
2 |
292 |
|
|
Multiple if statements by
Big Tony
If I want to make an IIf statement that hinges more than
two situations (say three or four possible outcomes), is
it possible to embed IIF statements inside...
|
July 12th, 2004 10:33 PM
by
|
5 |
398 |
|
|
crosstab query by
chris morrison
I am trying to run a crosstab query based on the answer of
a query that has a select statement in the criteria for a
date range. The crosstab query says it...
|
|
2 |
551 |
|
|
multiple criteria by
Rob
Hi,
i have a table called receipts in which i store the past
12 receipts a client has paid. i want a way to find any
receipt from a particular month (say for...
( 1 2)
|
|
12 |
239 |
|
|
Data Type Mismatch by
Derek Wittman
Good morning,
I have a query that is giving me a data type mismatch error. I do not have join relationships. However, I do have a query criteria that should...
|
|
5 |
321 |