When I split may tables to properly handle one to may relations, I noticed than when I link these tables back through a query then I can not update any...

I would like to know what percentage of orders in my database fall into discreet price ranges. i.e. 0 to 10K, 10-25K, etc. I have been able to set up formulas...

Thank you in advance for your help. Basically what is happening is that after much harping, my department is going to start analyzing the access statistics...

I'm an access novice, but I've created a query using two tables, "Location" and "Products Shipped". The query works fine but not all of the locations ship...

I am tryimng to run tjhis query and it is not doing what I want it to do. I have types and I want a count by type for the month of jan, feb, mar, etc. so I...

I have posted before trying to figure this out so this time I will give more info to help. Say I have three programs: Alpha, Beta, Gamma. Each program has...

hello all i have need of how to figure out the number of days since a date to a date. for example, jan 1 2007 to july 25 2007. i am tracking the year to...

Hi, I keep having problems with a pivot table that I created. The data and the query is in access. I refresh the pivot table daily and then print it out....

I have a menu form that allows a user to input from/to dates and to check off any, all or none of checkboxes for five warehouses; the user can then run a...

I want to append data to a table with a "concatenated" primary key - 2 fields (OrgID + autonumber). I set up the Append Query correctly (Pretty sure - do a...

Hello, I have a field that has 12 digits - Example AS0090040101. What I want to do is to pick up only the number 9004 and put it into another field in my...

I have a table linked to a spreadsheet and on that spreadsheet there is a column (H, F8 on this query) formatted in currency with no symbol. The link table...

I have a database that tracks a lot of information on an electrical distribution system. I have an Equip_table that list all equipment in the database. ...

hello. How can I transform this: ID_Cabec ID_Lote Lote QTPalete QTExpedida Palete Cestos Cap 56 1486 A023 0,4 0,4 14171 ...

I am trying to Export to a spreadsheet using the following code, but I keep getting error "Run-Time error '2302' Can't save the output data to the file...

I have a form that has not data source associated with it but has 2 subforms embedded on it. The form has 1 text box and 1 combo box where the user files in a...

Morning, I have a table which contains a record of every transaction we process. That table contains the following 2 fields, and for the date and value...

I have a query which calculates the total profit costs from other table/queries by Case Reference. This takes the cost value by code and multiplies it with...

Hi: Someone has probably figured this out, and I need your help on two issues:. I am working on a Time & Billing database in Access 2007. I have several...

Hi All, I am working with 'Microsoft Access 97' on a query that concatenates comments recorded against a unique ID, which is then displayed in a column...