|
|
Query by
Ray Slayton, RN
I have a large database of patient specific information that I need to query.
I have times admitted and discharged into the unit stored in 10/2/2008 ...
|
October 31st, 2008 03:40 PM
by tedmi
|
3 |
84 |
|
|
Opening query as read-only by
mscertified
I'm trying to make it more difficult for users to accidentally delete table
records. This database formerly exposed the dataase window and since there
are...
|
|
2 |
98 |
|
|
Title of Field in Union Query by
ryguy7272
I got stuck on something that should be pretty simple, but a solution is not
presenting itself, so I though I'd post here.
SELECT , , , , , "C1 Q109
Pipe"...
|
|
4 |
101 |
|
|
|
|
6 |
99 |
|
|
MISSING ZEROS IN A QUERY by
William
I have a query that returns 50 counties in the first column. In the second
column, the query returns a count of a two-letter code (ET). In counties
where...
|
October 31st, 2008 01:59 PM
by William
|
4 |
81 |
|
|
QUARTILES in SQL/QUERY by
BlueWolverine
Hey,
MS Access 2003 in XP PRO.
I'm evaluating personel and I need to divide a rating into quartiles,
preferably in a query, not filling a table tiwh VB,...
|
|
3 |
77 |
|
|
Help with Grouping and NULL Values! by
Sussman, Alex
Hi, I am trying to eliminate NULL values when grouping in Access but
it does not seem to work!
I have a table that looks like this:
ID CreateDate ...
|
|
3 |
81 |
|
|
DateSerial by
Stefan
I need to produce a query that will search a date range relative to a billing
date.
Basically this is for medical billing. I am trying to return whether a...
|
|
4 |
75 |
|
|
Aggregate Function and Subqueries by
Bill B.[_2_]
I am trying to run the query below and I keep getting the error message
The syntax of the sub query in this expression is incorrect. Check the
subquery's...
|
|
3 |
64 |
|
|
Help with Group By by
DawnTreader
Hello All
i have a question about group by. do i need to do this:
SELECT
qryrptSerialCBARPartList.ProductID,
qryrptSerialCBARPartList.IMWPNID,
...
|
|
6 |
61 |
|
|
Select Query, next record based on date by
Sean
Below is a sample of my data set and "Material" will be the primary key.
Now, for every "Material" you will have "101" in the "Txn" field and
multiple...
|
|
2 |
77 |
|
|
Noobie Question by
James
Hi everyone. Im very new to Access. Im having trouble creating a cap for
hours in a time sheet database. Here is what I have
I have a SQL Table with Recorded...
|
|
3 |
160 |
|
|
Simple Event Management by
robboll
I am trying to set up a VBA routine (query) that counts the number of
days
HERE vs AWAY. The sample events start (e.g., a_s) and end (e.g.,
a_e) at random...
|
October 31st, 2008 06:09 AM
by JString
|
8 |
91 |
|
|
Not Like by
Stefan
I have a table with a large list of codes.
I need to create a query which will filter out a lot of different codes too
many to really list.
I am thinking I...
|
|
2 |
61 |
|
|
Removing partial character strings by
LSSR
I am using XP and Access 2003. I have 35,000 records in the table, of which
4,500 in text field address2 has characters such as “ # 101” (e.g., 123 Main...
|
|
3 |
82 |
|
|
Max again by
ooxx
Hi,
I am really shy to ask this question again since then from subject "Max no
group" .
You can refer to sample data.
SELECT *
FROM myTable
WHERE f3= (...
|
October 31st, 2008 04:58 AM
by ooxx
|
4 |
76 |
|
|
|
October 31st, 2008 02:16 AM
by sahafi
|
4 |
96 |
|
|
Inner Join with Multiple fields by
Ernst Guckel
Hello,
When i execute this it does not match up any contacts with any companies
without data in address1. It should just use address1 as criteria for...
|
|
3 |
121 |
|
|
append query criteria by
Bogazetti
Thanks for the answer Karl, but I need to know how to write the criteria so
all the records will go into the corresponding name fields. When I do an
append,...
|
|
1 |
77 |
|
|
Append query by
Ernst Guckel
Hello,
I have two questions... the first is that I am having a bit of trouble
writting the append query. It works great as a select query but when I...
|
|
3 |
88 |