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

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 need to identify a short date field that has not had a date entered into it. Tried creteria ="Nul" but this doesn't work.

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 am using Like to search for certain text and Replace to replace it with some other text. Example: Like "*(*" Or Like...

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

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

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

I have a Report that runs fine, but the query will not "run" by itself. Any ideas out there. Thanks, Blaze

Is there a way to query a memo field to find out which record in the database contains the most text in the memo field? TIA

I have multiple tables that have the same fields. For instance, I have five tables that have the following fields: firstName, LastName, TelephoneNumber. I...

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

I have months (MMM-YYYY) in the columns in the crosstab query. I need to sort them according to time and not alpahnumeric. With MMM-YYYY formt they are...

Hello all, I am triying to use condition wtih some fields in the FROM clause of an Access query. But I get an error saying that "the conbination expresion...

I am new to SQL and need help in extracting some data from a table. My table has the following data...

I made a form with a button that generates a report based on the info that the user puts in the form. The record source of the report is a query that composed...

I have two tables where all records should match. One table, however, has more records than the other and I haven't been able to determine why. Unfortunately,...

IIf(!! In ("EAR/BAR Core"),Between 0 And 10,0) I have added the above statement to a query field critieria. I get no records returned. If I simply put ...