I have been using this append query to add in the records for payroll for the week for years. for some reason this week it appended the 52 records but did...

I am new to Access 2007. I have been using Access 2003 to manage our membership list. I have dozens of queries built that are in 2007 now, but I cannot...

I have a calculated (expression) field in my query as an example Profit:/. I would like to use a parameter query to find less than 75% profit. Placing...

So, I'm trying to use a query to count the days of enrollment for multiple students in a given month. I have a parameter query set up to show which students...

I have a table (tblFeedback) which holds all the feedback from showings that have been done on houses I list. One house is listed mulitple times for each...

I have a date format of 01/01/09 12:59:59 AM that I formatted to be 01/01/01. When I run the query, the 01/01/01 field is put into the table as a text...

Hello, I have a table that has, among other things, "as-of date" and "balance". I want to have a running percentage change added to the table. Example of...

Hi, I am trying to find the average monthly dollar amount in inventory. I have five fields that represent: date in date out quantity cost of part

Hello, I have a multi step problem that I'm trying to streamline and automate. All of the required fields are in the same table. I'd like to reduce the...

Hi, In my query, I have renamed each field which looks fine on the results screen. However, when I export to Excel, the column headers revert back to the...

Hi, I've read many posts but cannot seem to come up with a formula or query for the following: I have two times in and out formated as date/time. In the...

I've been trying to figure out a way to do this for awhile, but I haven't come up with anything that works. I'm querying a table in my company's database...

I have a large dataset within which I need to calculate several averages across rows rather than within one field (I understand this is not an ideal design...

Hello, I have a form that has four check boxes and all of them work fine except for the last one which is to not exclude anything. Here is my sql: SELECT...

I got into a bit of a mess by deleting a query that had a form linked to it so deleted the query I made a new query and tried to link the data but there is...

I have a some action queries within macro that I want to execute, but when I fire off the macro there's some informational messages that I want to supress. I...

when attempting to open a query in design or datasheet view, I receive the following error message "is not a valid name. Make sure it does not include...

I have table and relationships scenario like what MVP Allen Browne has on his site at: http://www.allenbrowne.com/AppInventory.html which...

How to display text over 225 characters in excel cell when running select statement? The ouput in excel doesn't contain all words even though that the field...

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...