Two similar, crosstab queries that act a little differently: The first one, hand-built, repeats "Pcent" for all column header fields, whether or not I enter...

I am having problem creating this query. I have a table with about 5 fields that have a drop down value list with (Complete, Incomplete, and N/A). I would...

I use the switchboard wizard in 2007 to create a switchboard but when I go to look at the finished product the main switchboard page shows no items. If I...

Hi Guys, I am just wondering if it is possible to run a query ever 24 hours with no user intervention? I have some data that comes in at regular intervals...

In my query I have: Division: & this pulls a division name and a district. It is linked to a report and I want it to appear as Division - District. How...

When I run this code: SELECT OE_Interchanges_tbl.PART_NO, Concatenate("SELECT comp_no FROM OE_Interchanges_tbl WHERE part_no ='" & & "'") AS OE FROM...

I have a series of queries in a report database that pull information from other Access DB's and display it in one summary report. This was working fine,...

For clarity, I will try to be specific. Hopefully it will not come out long winded. I have a query drawing from several tables. Here's a sample of data...

Hello, Thought I’d post this question before I tinker with it myself. I have a field “details_xml� that contains xml information like the below...

I need to make a table to store multiple measurements on parts and I need some ideas how to proceed. Each measurement job consists of up to 289...

I have a table that records all time off for my employees. To simplify entry, I used "begindate" and "enddate" for consecutive days. I have created a...

I just created a simple table in a data base that compares two test fields within a table and produce not matching rows. The query resulted in very few rows...

I have an append query in an Access 2007 database that uses a linked Excel spredsheet as its source. When I run the query it appends about 65,000 records to...

I'll try to keep this as brief as possible. I am working with "one" massive database that, due to size, has been broken down into 37 separate databases. I...

I've tried Like "*" but get the error message You can't specify criteria on the same field for which you entered Value in the Crosstab row.

I have a form with a start date and an end date field. I want a user to either put dates in these fields or leave blank for all. I can't get the query to...

I'm trying to do time value investment calculations in a small Access database I've been building. For the sake of this discussion, we're talking about a...

I set a query to pull its`criteria from a form using Forms!. That said, I now have a twist and need help in addressing it. The control in question is a...

Hello, I am new to this forum and I have this question to start me off: I am attempting to find the percentage of Males Hired and Females Hired in the...

I have data that starts with $ which is easy to find. But sometime the $ is blended in the text please note this data is in Access??? But if I have to move...