Hello. I know how to construct a query that will search between two dates on *ONE* field... but I do not know how to construct a query that will search on...

Hi Need help with a updatequery. I have a textfield I want to run throw all records and find the "/" and replace it with a "-" The "/" can have different...

Problem#1 This query is supposed to generate a running total on a savings account. The RUNNING TOTAL column attempts it by using dates, the BALANCE attempts it...

I'd appreciate any help I can get...... let me know if it needs clarifying thanks!

Hi, I am trying to perform a delete query from a form. I created a button that invokes the query. When I perform the action I get the message that says "The...

I have two fields with customer name. One is copied from a tool that sometimes brings spaces after the name. Creating a join eliminates matches because of...

hi, in my main table, , each record has a date (mm/dd/yy). In my query I want to pull all the records of a single month and group those records together....

I have a form with a series of check boxes; the values of the controls are used as conditional criteria in a query. So if checkbox 2 is checked its value is...

Hi All, I cannot get a query with the Exists function to work properly. Using the In function gives the proper results, but it runs too slowly. The queries...

Hi, Could someone please help me? I have a make table query based on three different tables. In one of these tables there is the purchase date field. I would...

HI, I was trying to use Table Analyzer to split a table, and got this message: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry. I...

I have the following crosstab query. Can any one tell me how to get 0 for Daval when their is no value for that Value field. PARAMETERS ...

I don't normally right code this is just a small project for a rather large home office. So I am in way over my head...but willing to learn. Any help...

I have a database of club members and each year members who left are taken off and new members add to bottom on list and the table must than be renumbered...

How would I separate a text field in an Access 97 database, entered like this: A695 Item1/Item2/Item3/Item4 (say up to Item 10) A696 Item1/Item2 to separate...

there's a form that has 16 union statements in it. It is used to show the user the forms they can access after logging in. I've tried to add one more form to...

Receive a message when running a delete query as follows: Can't delete 0 records in the delete query due to key violations and 1 record due to lock violations....

I am creating a query with 10 different fields named categ_1 to caetg_10. I need to know if any of the records in any of the ten fields equal step up or step...

I have 3 tables - Resin, Criteria, and Application. Criteria and Application only have an ID number and a list of criteria or applications. These tables are...

I am updating tables from a server through a data extract process. I would like to delete records to the primary table (that don't match the primary...