I am trying to use a parameter search in my query to prompt the user to type in parts of the field three times before the query will run. I have the...

hi... Would like to use " a sting expression.. I have tried """ but doe not work.. This is what I have html: "option value=" & & "" & &...

I know the answer is right in front of my eyes, but its one of those days and I have wasted too much time on it already.. I have a column within a table...

How do I use the # sign as a field name in a select query, ex "Library #: column"?

I am creating a new field that doesn't exsist in a table. To do this, I must define how it is calculated. I need to do it so that "IF a value in another field...

How do you use "and" in a query to find where something appears twice? For example I have a table of Staff Names, a table of Departments, and a table that...

When using Simple Query Wizard, available fields will not display

Hi all, I'm trying to use a field (TaxNa)in a table (T_Ins) to determine wich of the columns (Tx1, Tx2, Tx3,..., Tx12) to use in another table (T_Tx). I'm...

I am trying to use the formula made in Excel and copying it to Access. In Excel, the formula looks like...

Expression's within queries????? -------------------------------------------------------------------------------- Hi People My sales manager has asked me...

What do I do if I want to join two or more tables with an inner join, but I don't necessarily want to enter a value in one (or more) of the primary keys in one...

Hi i want a select statement that will choose distinct and not distinct. i have a select statement with 10 field that is distinct select and i want the 11...

We have some users that we have directed to only get their information from a report that has been set up. Because of that, I set up a parameter query to make...

We have some users that we have directed to only get their information from a report that has been set up. Because of that, I set up a parameter query to make...

I have created a query and I have placed in the "criteria" so that when the query is ran, the user has to select a specific date to return those...

I have a two tables, Users and Requests, the latter which displays the daily log on's of 20 users. Both tables are related by a one-to-many relationship in...

Hi, I am converting from A97 to A2k3. I have a form that allows users to make choices and then hit a button to see results. Behind the scenes I'm making a sql...

Is there a way to capture the username in a query / form? Any edits to a record will show the last user who altered the record. Thanks!

Is it possible to build a query that launches from a form that allows the user to search a field using wildcards? for example, my database has variable names...

Hi All, I have 3 tables in which I need to routinely replace certain characters. As I am still using Access 97, I use a user-defined replace function...