Hello. I need to merge the results of two similar/equal tables. The 00_tbl_Badge_Actual table has the currenter recordset/register and the...

Hi! I have an Access 2007 Table that I Have linked to a pivot inside of Excel 2007. I want to be able to pivot on a date field, and have identified the...

Hello all, I have a query that will return over 65K records (rows). My end goal is to export this to Excel via code. Excel has a limit of 65K rows on a...

I have a form with a combo box on it called I also have a text box call and i have a command button on the for called The question i have is the combobox...

hi is it possible for me to do this: where record says orange sum time where record says apple sum time2 where record says banana sum tim3 in a query

I have column A with about 10 different categories, and I want to create column B that is populated based on the entries in column A. If for row 1, Column A...

I have several queries that contain several hard-coded formulas. If possible, I would prefer that the formulas be referenced in a control or setup table. ...

I have a single table that has an employee and the manager they report to. This table consists of all employees regardless of management level. Since I...

A criteria "100" in a numeric field is successful. Using it in an IIF statement as IIF(1=1,100) dosen't work. What is the proper syntax? Dave

I'm trying to help someone out who is using tables linked to a sequel server database in Access. There are multiple tables set up the exact same way that are...

Hi all, I have a "large" (1GB) multi-user database that all of the sudden starting throwing the "invalid use of null error" for EVERY query in the database...

I have 12 tables named as: Sep06, Oct06, .. Aug07 (each table is ~ 30k lines) In each table there are 2 fields of interest: CINU, AUM (the 2 fields are named...

I have a very basic understanding of “coding� and am now way out of my league. I would like to be able to run Query(s) to get totals for “open� or...

Hi there, i have a db with tblclients and tbladdress. I have a one-to-many relationship between then two as i can have 2 clients (typcally Wife and husbnad)...

I have a form with a list box on it. The list box displays the result of a query. The Openargs which is input to the form contains a number. I want to...

Hello, I created a query from a customer address table to pull out the people who use aol. This query has the following fields: Name (this field compiles...

In Access 2007, when I set up a View to query some fields and then delete some of the fields from the query I get an error message. For example, I set up a...

I have a table which has various defects that may occur in an area. I want to create a query which views the data by the week in the year (i.e. the first...

Here's what I want to do: Get all the records where a date field is within the current week. Example: Say the current date is 12/6/2007. I want the records...

I am learnign Microsoft Access as I create a contact management database - (from the template). I would like to create a query the counts how many times a...