Hi I have a field that can have either A, B or C as its value. I need to write a query that will return the number of A's, B's & C's in the field X for...

I would like to determine which patients did not obtain the right number of vaccines by the age of 2. My database can tell me if each patient is not up to date...

Hi all, I have an Access 2000 mdb that I'm editing in Access 2003. I'm trying a simple left outer join query in the form: SELECT lefttable.id,...

I need to use a makequery in Access 2000 to build a table of customer's invoices. I want to use the query to generate the invoice numbers based upon a...

I have data in a table as follows: Company Location Number Comp A CA 3 Comp A WA 3 Comp B AZ ...

Can someone answer this for me. I set up an append query starting with a select query. It ran fine. I try and use the append query and get the following...

Hello, I hope someone can tell me what would be the most efficient way to update a table in the following scenario: A Students table with approximately 700...

Hello. I am a newbie in cleaning junk out of a MFG_Number field. This field contains 1, 2, 3, and 4 plus spaces prior to the valid number, which I would like...

I am simply trying to count records and use returned values in my report as I do often, but for some reason I can't catch my error...

Hail all, Suppose we have 2 tables (20 rows each) as follows: Table a with Columns A, B and C and an Index Table b with Columns A, B and C and an...

Dear developers – I have a problem that I can’t find the solutions for. I have a table with products. It is simple to find the max value, but is...

I have a program (Thermodata Suite) that has been designed to automatically download information from temperature data recorders (i buttons). The...

Hi, I have created an address table that I would like to use in a form via a drop down that would show all address fields. How can I make my selection show...

I have a query that is querying from a table with a memo field. When the query displays that memo field on a report, the field truncates the content of that...

I have a local table of twelve (12) records. These are utility rates, which include the date they became effective. Two (2) of these rates (flagged) have...

I want to query data using a dropdown box on a form. The possible selections a Any, 5,10,20,30 So, there are basically 2 possible selections- "Any" or A...

I could use some help. I'm using MS Access 2003 Long story short, I would like to create a query that displays only bills that were introduced and passed in...

I've created a table containing people's names, addresses, phone numbers, email addresses and other information. I'd like to be able to create a query/report...

I have seen posted (by Ken Snell) in several places in this newsgroup, instructions to open an export specification in the wizard and edit the data types for...

Here's what I'm trying to do 1) open a recordset RS based on a SQL query on a single table T. The RS should have 3 fields: T.pk (long, primary key), T.fld1...