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 ...

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...

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"...

Running Access 2007/Vista Business I need help contructing a URL string from a query on a table that contains bibliographic data about a journal. The ultimate...

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...

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,...

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 ...

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...

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...

Hello All i have a question about group by. do i need to do this: SELECT qryrptSerialCBARPartList.ProductID, qryrptSerialCBARPartList.IMWPNID, ...

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...

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...

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...

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...

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...

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= (...

I have a union query (out of 10 Access databases .. linked) that I'm using as a source to make a table so I can link that new table to another Access dB. My...

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...

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,...

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...