Currently I have a simple query that runs calculations for my work orders database. I am pasteing the SQL version for Access 2007. Right now I have a macro...

A little help please. I have a Master Report that totals all reports for a full year. Below is the SQL statement written for the month of January... SELECT...

I have a Work Order database. To date everything works fine until now. I have 9 Departments and on any given day, they have outstanding work requests in the...

I would like to create a query that would detect the most recent month and would list those records as well as records with dates from the previous 2 months....

I am having a problem with my MS Access 2003. When I try to append a table to another I am not seeing the first table in the list. I have tried to force it...

I have a crosstab quary that with help from the MVPs its working perfect. When I go to report wizard and try to pull up the crosstab quary then ther are no...

I'm new with access. I have 2 tables. 1st is employee which has employee name, post, shift, and time,the 2nd is schedule which has date, hrs worked, schedule,...

I am having some problems with converting a string type data to long date type. Simply I am trying to compare two dates, the first being captured from a text...

hi all How can we delete a file using MS Access commands? -- Message posted via http://www.accessmonster.com

One of the queries of a DB I'm developing reads from two tables and two queries and includes 24 calculated fields. Although the calculations are not complex...

Why does the y-axis not have numbers rounded off? On several databases, on several machines, the y-axis by default have too many decimal points, and have to...

Hi , I am making a comparison with 3 numbers in many records Nr1 is a static number Nr 2 and 3 are variabel. I would like to get the number that is the...

I have a table with the following: Id Name amount Date 1 JOHN SMITH 10.00 8/1/2006 2 JOHN...

Hello everyone: I have a 97 MS Access issue, I need to get resolve. A salesperson goes one store and spent few minutes for try to sale products and then leave...

Hi, I would like to retrieve data records from either table or query, and then do the calculation from them. Below is part of code to get the records, and I...

Hi, I have a table collecting the data for division, people and cost. How can I write a query to find out who are the top 5 people spent most of the money in...

Hello, I would like to write an If statement with the AND operator in a field in a query. For example: I have a total yearFee, and have to divide by 12 and...

Hi, I have the Excel work sheet to calculate the data (about 25 columns and 300 rows) that are the data for making a chart in the Excel now. Because the...

Hi there, I'm creating a new table using the Make Table query in Access. The table has about 8 columns that should display percentages with 3 decimal...

Hi, I have a pretty simple query. One of the fields being brought into the query is a series of characters such as this: ABC-ABC-ABC-ABCD-1244-ABC In the...