Hi there Please help! I would like to place a command button called "Clear" on my form to delete the current active record and enable the entry of fresh...

!.!

This statement returns a syntax error, indicating I may have entered an operand without an operator: IIf(="no", "Unaltered at Intake", IIf (="spayed" And...

I have used Access for a number of years, although mostly just basic functions, and now have the new 2007 version. My question stripped down: I have a table...

I am looking at a formula that I wrote that begins Sum(... Problem Is, I NEVER PUT that at the beginning my formula. MY Formula started with IIF(... Access...

....much less a SQL statement. A supervisor several levels above my direct supervisor 'asked' me to include a chart view option in a database interface I...

I have a table made up of fields A, B, and C. I want to update the data in the table such that the value in fields C is placed in field A, and field C is...

I am working on normalizing a poorly designed database for a friends contruction co. using Access 2003 or 2007. I have a table with with each job info, the...

I found the code below on here for removing hyphens and adding zeros to a txt field. However, where do I put this code? How do I get this to do it's work? ...

I am trying to create a new field in which it shows the sum total of 10 fields (Charge Time, Charge Time 2, Charge Time 3, etc.); what is the easiest way to...

Hi all, In an Excel worksheet I have the following data: 4000 3000 2000 1000 400 170 130 90 50 300 160 120 80 40 200 150 110 70 30 100 140 100 60 20

I am attempting to track invoices and payments for customers, and appending "paid" invoices to a new table. Invoices and payments are entered by invoice...

I have a database with two text fields that contain numbers and letters that correspond to rule citations. I am trying to filter the database by trying to...

I am having an off-day today and am not able to figure out how to get the results I want from just one query. Instead I made multiple queries that cascade...

Hi, I have a query where I am using an iif statement so that my field we either equal text or number depending on the value of another field. Here is my iif...

How can I enter date parameters for a crosstab query? I have used the where date is between this and that expression in other queries however it will not...

I have a query that I am needing to pull certain data from a table. I have been able to get this query to work if I plug in the criteria manually that I am...

I have a file that I've pulled into Access. When the information downloaded, it didn't completely fill in some data, i.e. I have a customer column and an...

I edited a query in Access 2007, and when I try to open in in Access 2000, the program disappears from the screen. No error message, nothing. Just...

I have created a blank database in Access 2003. Now I want to create tables using scripts from queries, is it possible? And how if it is possible?