I have encountered problems in the past with Pass-through queries where changes to the query are not saved. Make a change run the query and the original data...

Right now, I have the following search query. It takes everything from the first name (fname) column of Table 1 that matches my variable_string (a string that...

I want to select records from a table where the text of a particular field contains "KB" for example idfield = "KB1234" Or "KB34567" I wouldn't want...

On my website (see sig below) is a small sample database called "TopQuery.mdb" which deals with duplicates in Top queries. -- --Roger...

I have created a query, from a table, that prompts user to enter the year for which they require, e.g., 2001. That piece works well. However, the question...

I want to perform a query that will look at one table, tell me what products are in that table, and then tell me what products are not in that table (based on...

I have a Query which Generates a list of Records with a name and email associated to each name. To put it simplier There are many records associated...

Hello, To simplify my question, I'll state it this way. Let's say that I have two tables. Table 1 contains two fields, SalesRep and RepAlias. In this table,...

Hi Ken, I have a similar need to list record number in a query. I tried your SQL text, and it works if I wanted ALL of the table records in the query...

Good afternoon. I seem to be having a problem utilizing data from a "combo box" in Access 97. The combo box exists as a lookup in a table. The field is then...

hi, i have a memo field which stores information about payment history. i want to search that particular field in the query and pull anything from july, 2004....

I have a table with a list of people's birthdates, and a resulting query calculating ages. What I would like to do is create a report that will tell me how...

I'm using the following in criteria: IIf(!.="All" Or IsNull (!.),,! .) It's working good except when cboTerritory is disabled or empty the query returns...

This thing is driving me insane. I have an Append Query that's supposed to copy a record from one table to another one, but it's not working. The tables are...

I am trying to create queries based on a General Date/Time field I have. The field contains both date and time in "MM/DD/YYYY HH:MM am/pm" format. Some of...

I need append to 2 values into a table. The first value is a list of ids selected from a list box where I can select multiple values at the same time. The...

I would like to change the font color when naming my queries in the Queries tab to coordinate queries. This way I can relate complex queries to each other by...

Hi all, Is it possible to have transaction-type process in Access similar with SQL Server transactions. Thanks in advance, Lily

Hi there, The Database records Department, Wastage, Type, Description, and Treatment(a Flag which is set to either 0 or -1), by Department. total Departments...

Good day to everyone. I have three tables in an update query and their fields are as follows: tblTransactionDetails tblTransactions ...