I want to run a query so it will give me all data from the last 5 years from today's date without having to specify the actual dates. Is there a way to do...

In a one-to-many table relationship, I need to show only records from the primary table where a boolean field is False in ALL related records. It seems simple...

i have just installed office 2003 on a new xp machine and when i try and open some documents in access i recieve the error, "The Open Report Action was...

I have a query that pulls info from a table and sorts it based on a particular field. Is there a way to assign a number to each record in the query (starting...

In the course of trying to normalize my database, I have split my data into multiple tables: Contacts (name, address, etc.) Statuses (active member, newsletter...

Is it possible to create an Access form...on which data is entered in one language, e.g. Russian and an English version is displayed on another monitor as the...

After running the "find duplicates" query, it returns all the duplicates in my table. How can I then delete one of each duplicate without manually deleting? ...

I have a log where I want to track whether a task has been done by just clicking on the 'checkbox' and the check appears. It serves no function except to tell...

Hello, I have an update query, but would like to limit the values to be updated to include only those values which appear in another query. Now, I can do...

I need to group the data within field1 and then retrieve (for each group) the record(s) where field2 is either largest and/or null. Please help!

I'm new to ACCESS 2002 and I have a question on a string. I have a password box that requests the user to enter a password. If they enter a password the...

I'm new to Access. I have a bunch of tables: 1. Enrollments for Fall 2003 2a. Graduations for Spring 2004 2b. Graduations for Summer 2004 2c. Graduations for...

I have created a few forms, and I would like to query and set a password to the forms. So that in turn, for example, when someone goes to the forms and puts...

Hi, i have a company table like : Company Product Sales Resp. category etc..... cmp1 prd1 SP1 ctg1 cmp1 prd2 SP1 ...

I am sorry to have to unleash this to you on a Friday but ....... From this table: ID SA KW Parent Where ID is autonum primary key, SA is a name existing...

Hello All, I run a query and get a set of records. Those records from query, I want to use for criteria to delete records from a particular table. Any help.

I need to create a query for a report. There is a column called Keywords which contains strings of keywords separated by semicolons I need to produce a report...

Hello, I want to have a parameter query to search by date----"from date" and "to date".Is there some default expression that i can use as a criteria instead of...

Hi all, I have an interesting issues trying to create a Recordset from a Crosstab query. I am making a report with some graphs and I want to populate the...

Hello All, I have an unbound multi-select listbox on a form. I am getting values from a column into the listbox. I want the values selected to be input for a...