My main table is and its data catagories into groups and groups are alloted value on certain basis and value stored in translation tables name like slotogr,...

I have a query consisting of 4 tables and 2 subqueries that returns a wrong value in a given field. This is when no fields are linked where the value is...

Hi. I am surprised by different result of a simple INNER JOIN query based on SORTING the result. Situation: There is Customers and Inventory table. ...

I have a query that is matching an ID to an ID. I am looking at the results, and the ID's are not the same. How can that be if I'm specifically saying that I...

Hi, I have to transfer a web-site to a new server. I changed nothing, but I always get this scary error: --------------- ODBC Error Code = 07001 (Wrong...

Can someone help me figure out what is wrong with this ? PAGE1: Mid(!,7,9) & IIf(!="Page_03a",".0" & !, IIf(!="Page_04" And (!10),".0" & !, IIf(!="Page_04"...

I am at a loss why my Group Query is not Working. I want to group by State. However when I want the student with the highest test score I get the student...

windows wants update for 2000 system has xp pro1-2cpu do I have a problem?

I have a table that is written to programmatically that has fields for INDATE and OUTDATE. In my stupidity, the line of code that records the date for these...

I live in Spain and here the date format is a bit different than in the United States. I've just upgraded to Office 2003 and now, when I combine my word...

Hi to all, I am getting a data type mismatch in the following query in the where condition: UPDATE tblBudgetBr SET tblBudgetBr. =...

Dear All, Currently I ask myself if the design of my database is wrong. I have several tables with a lot of fields which use 'Value List' as a row source...

In a simple query on a data table (design view) a Between And is placed on the criteria line of the field "first_attendance" which is formatted in medium...

I need to filter 8 pay periods (PP) from user selected PP. For example if user select PP 12, I need to show every entry between PP 5 and 12. I have set up...

Hello all, I recieved a database that has the "Middle Initial" data combined with the "First Name" data, which leaves the middle initial fields all blank. Is...

I have a query as shown below that is getting the wrong match. The Lead ID from Combine (which is a query itself) is getting a wrong match from the Lead ID...

Hi, what teh CDate convert myDate to wrong date? Please advice... Dim myDate As String myDate = "Jun 13,05" MsgBox CDate(myDate) Debug.Print CDate(myDate) '...

I have 2 tables and 1 query: tblPersonalInfo containing: dtmHiredDate for Employees (a for Bill, b for Sam, c for Tom) tblJobPromotions containing:...

can you write a syntax that says if text in one field is "x" take the date from another filed add 45 days and populate a third field any help would be...

Hello, I am using Access 2007 and writing SQL Queries. I insert some line breaks on my queries to help in visualization. When I close and the reopen the...