Hi, I'm having a problem with an update query. In one case the query reports it will update 56 records but on inspection only updated 8. Changing it to...

Hopefully this will be an easy question. I have a main table and three other tables that hold descriptions for some of the columns in the main table. I put...

I'm using the DateDiff function in a query and it works fine until I try to set a filter to only show the records where the difference 0. When I add 0 to...

I have a table that has a company name and 8 different ratios for the fields. (nine fields in total) What I want to do is run a query where the results will...

Hello: I have 2 tables set up as such: TABLE1 MAP# (Initially Blank) ADDRESS1 ADDRESS2 STREET Other misc fields also

HI people, What's wrong with tusing this as the criteria: IIf(!=!,True,False) I got the error message: Data type mismatch in criteria expression. Thanks. David

In my query I made an expression to show month and year. However the value of the year returns in another value. The value must be 2006 but shows...

Here's the situation, we have a school. Some students are part of a paid work experience program in another part of the school. Student records are kept in one...

When I try to filter records using Filter-by-Form button I get a syntax error when the fieldname I want to search for contains a bracket - Is there any way I...

I am trying to pull out all records where the field (text value) does not have "cell" in it. The feild has phrases in it, ie. "cell phone" or "dell server"...

Hello, How can I, using one parameter (for example weeknumber) letting this parameter be the base for two or three queries? Now I must enter the...

Hi I'm using DateDiff() in an expression in a query which works well until I try to use the SQL as the source of a report. (I'm using Access 2K) I get an...

Good Afternoon, I created a deadline list (an access report)for our department based on a query. The information, based on the week it is due, is sorted by...

when i try to copy one access table's records to another table w/ the same format, i keep getting an error message: data entered is not compatible w/ the...

How do you go about adding or summing columns were some columns are empty (Null?)?

Hello, I am creating a crosstab query. The query works fine, however my value is coming up with too many ending zeros. For example, what i want is to see the...

I have information listed in a MS Access Database (Office NT) in fields FirstName and LastName there are many duplicates. And of course there are...

I GET THIS WHEN I WANT TO COPY, WHAT DOES IT MEAN...REALLY? MOST OF THE TIME IT GOES GREAT...THEN I FIND A REALLY GREAT PIC AND THIS MESSAGE COMES UP.

Hi - what is the SQL syntax Access to return the top 'x' rows from a query? Thanks --------------- Luke Bellamy Newcastle, Australia

Access 2002 Win o/s XP I created a report of monthy cash receipts based on my invoice table. The invoice table is joined to the parent table by a case number...