Hi I have a very basic phone records file which I download and run a query on. I have a couple of expressions for formating and calculation to make the data...

I'm looking at moving Access 2002 to 2007. There's a database query to extract accounting records and grouping/totalling by year. 2007 rejects the format as...

Hello, In Access 2007, whenever I try to view a query design that contains more than one table I get the above message. " '' is not a valid name." Also...

I have recently converted an Access 2002 application to 2007 and then tried to run under Acess 2007 runtime. I have found that any underlying queries or...

I am trying to convert an Access 2007 database to SQL. I keep getting the error "Upsizing wizard cannot run with any database objects open". But it does not...

Hello Access 2007 Google Groupmeisters, need your help and support on this one.... My Table: Field1 Field2 Field3 Field4 MPIID MPIID 07499750...

I recently upgraded to Access 2007 and I'm having trouble with one type of query from my database that I designed in Access 2003. Its a simple Access query...

Using the statement below, the criteria for Cust_Id1 field yields "00001" records as well as other records not = to 00001. This is a text field. I would...

I just updated and am trying to make an UPDATE QUERY like I did in Access 2003. When I try to update the value in one table with the value from another table...

As an experienced Access user I 've just started using v2007 and was very surprised to see that an update query like this did not work... update tableA set...

Is it possible to use the query wizard builder format to edit existing queries in stead of the SQL format, if so how is it enabled

I have a query and in the criteria for a text field (Route), I'm placing the following statement: Like "*433" When executed, the query will not return any...

When I create a new query in Access and go to save it I get the error "You do not have the necessary permissions to use the 'MSysTables' object."

Hi I have two tables that are used as the source for lookups in a third table, one called Process Group and one that is called Knowledge Area. The third...

I have one table – “DAILY INFORMATION� This Table contains sales information for each day. The fields involved in this issue are listed below SALE DATE...

I cannot open an update query to edit it. Help tells me to right click to open, however, nothing happens when I right click! Any suggestions?

Access 2007 has a great new feature which allows to easily filter by selecting different values from a drop down box on top of each column. However, sometimes...

Hello, I am building a criteria expression and I'm using a Val(string) expression. When I click Run, I am getting a data type in expression error. I have...

Beginner in Access 2007. Question related to queries: concatenante fields. Does the expression results show in forms? Also, pre-existing lookup data type...

Access 2008