I have a Make Table Query that I will need to run every morning. Is there anyway to have the query add today's date to the name of the table (without going...

I am running a query that is based on 9 other queries and 2 tables. The query runs for about 5 minutes then I get Error 3183. I confirmed that I do have...

Hello I need to find a way to have Access 2007 run a report or query at 00:01am of everyday and then to generate an email, containing all the information...

Okay, I asked this question a few days ago and did not get a repy as of yet. But I want to approach this problem from another perspective so here goes again in...

The simplest way to do this is just to set the OrderBy property of your form to the name of a field. Remember to set OrderByOn as well. This kind of...

Hi - Any idea why the SQL queries that are created by the Cross Tab Query Wizard cannot be ran in VBA? It starts off with the 'TRANSFORM' statement, as...

Hi Folks -- My apologies for the crosspost, but this one just seems to need multiple perspectives. I've googled and googled, but not come up with a "best"...

I have 3 modules that I would like to use within a query I am designing. I currently have an expression in one field of my query that references one of...

Hello, I am trying to create a crosstab query that will display rep ids for people who are assigned multiple reps in a non-normalized table. For...

I have read the web pages that some have referred me to regarding time calculations, but I still can't get it to work. What I have is: STATUSDATE, a number...

Hello, in GUI of Access 2007 (12.0.6423.1000) SP2 MSO (12.0.6521.5000) is generally very simple to make a select query between two tables joined with two...

Hi Guys, I have a database a programmer created years ago in Access 2.0. It is now converted to Access 2000 and I want to join a few tables together to get...

I have a main form that lists a part number for an item. I need to build a query that returns all other part numbers that match certain attributes of the...

Hello, My problem has got to do with the Purpose of Travel field (query created field). Along with for e.g. object code - 2145, purpose of travel is "Sick...

I can't seem to figure out: A) where to write the expression to calculate serial numbers of weeks. B) how to get the expression to calculate the serial number...

I want to increment a field, within a sorted table, resetting the counter to 1 when another field within the same table changes. (I do not want to know that I...

I need a function to remove the decimal point not the decial place. I need to provide a data file with dollars and cents without the decimal. Thank you

I have the same problem. I have 70 tables that I want into one table. All tables have the same structure with different content. I tried an Append Query but...

I have a combo box that displays three related pieces of data. Grade1, Grade2 and Rate. I update the Rate field in my form with this combo box. What I would...

I have a table with 2 date fields startdate and enddate. They vaules are long int in yyyymmdd format. I want to check for any overlap between records. Eg if...