Hi there ... I want to DROP a PRIMARY KEY from an access table before I can add a new one ... The code I have now is ... ALTER TABLE info DROP PRIMARY KEY but...

I want a list of all the queries in an Access 97 database. Is there anyway of listing the names of all the queries?

I want to add a field to my query that displays "Approved" if the field contains certain verbiage and "Review" for anything else. IIf( Like...

How is your form set up? Is the data being shown on the form itself and the dropdown is associated with each record, or do you have a dropdown and a subform...

I have the form with 3 drop down lists. For the first drop down list (Alarm Panel) I have a command button to run the report. The Drop down list has A, B,...

Thanks that helps. You last line made me think though. There may be an occasion where one field is different so is there a way to set the criteria so that...

"reports" is the name of the form, apologies for that but I already have a crosstab query based on a select query. If I put the parameter into the select...

The first paragraph, second to last sentence answers your question. I have tried the Select query where I put without the brackets under each of these...

Wendy; Are you familiar with SQL? When you want to select more than one random number using a Query, it can get hairey. Len "Wendy" wrote:

Thanks so much, that worked perfectly!! "Ofer Cohen" wrote: First make a back up to your mdb You can try something like ...

I created an Access 97 database a year ago and it always worked fine. Since this morning, it does not work anymore. I received the error : This expression...

My next guess is that the form being named reports is messing up things. Try changing the name of the form slightly and make sure that all the code is...

I have a table that contains the following fields. Every 3 months i recieve a book value and MTM, i then have to use the last set of values to calculate the...

Thanks for the response. Some how count needs to play a role. In the above examples the numbers mean nothing. They are part numbers-I could have used A and B....

You need to change the Group by and Sort by to include both field name that you join together and not the new column name Try SELECT Master.Viol & " " &...

In my contacts, I have created a customized ID field. I did this by first creating an ID field with the data type as Autonumber. After Access populated...

Either i have a problem with this query or i am the problem. i have query that combines data from two tables. but somehow, when i try to add another column to...

I know this maybe in the wrong board but I thought it might be better here. I have a query that has a constant taken from an unbound text box, so the whole...

without the "e" !!! "Sonic-1968" wrote: I hope someone can help. I have received data which appears as 01/01/2007 12:25:45. I need to change the...

Can you post the full SQL? -- Good Luck BS"D "Jeff Kunberger" wrote: I am creating a "Round Robin" form (an interactive form that lets users