I have two tables. One has "customer full name" in one field. The other is from another database and has two fields, : "first name" and "last name". I want to...

Hello, I'm trying to extract certain information from a column and I can't seem to do it. This column is called information and it contains a description...

I would like to create a query that contains an IN clause whose elements are determined by the value of a parameter: PARAMETERS VariableIDs ???; SELECT a.ID,...

Hi I have two queries, lets call them Query A and Query B, which run fine when they are executed in isolation. They are quite complex with lots...

I am using Like to search for certain text and Replace to replace it with some other text. Example: Like "*(*" Or Like...

Hi, I've got criteria in my query to be based off a combo box of my startup form which is linked to a table. It works fine, but how can I make it so it...

I need to identify a short date field that has not had a date entered into it. Tried creteria ="Nul" but this doesn't work.

I'm using an Access 2000 database, and another mdb file, where I'ev got froms, scripts and queries. I've made changes (using Access 2002) on the table database...

I have a table for work order information that has a work order id, type of work, a section where you can choose employee names to show who worked on an order...

How can I add columns without moving formulas. I need to have formulas stay in column a,b,c, When I add column formula goes to b,c,d, it needs to stay where...

I have a table with the following values: PatID TestDate Type ...

I set up a database for frequenty asked questions pertaining to specific products that our company produces. I want to set up a query that will prompt a user...

What do I enter in the criteria of a query to calculate number of weekdays between two date fields? example: find out how many weekdays are between field and

I am writing a database to keep track of program licenses. I have a service table and a user/serv table. I want to update service.total_users so show the...

is it possible to have multiple sortings in a select query i know i can do it in sql but can it be done in the query grid

3 - tables used 1 - list ALL purchase orders 1 - list ALL orders including details 1 - list only purchase orders that have shipped based on Shipped...

I am using a Like Forms!myForm!cmbMyBox in query to get data based on what is in cmbMyBox. If the user leaves it blank the cmbMyBox defaults to *...

Greetings, I have a complex query defined. Here is the sql: SELECT (Select count(*) from NewClientCaseMasterTable WHERE (((.) Between !! And !!)) ) AS , ,...

Hello: I have a tabe that looks like...

I am trying to create a query that traces our sales in the following manner: Sorted by Zipcode Sorted by Dr. Name Sorted by Patient Name Totalled by Dr....