Hello all, ok I have an issue here.. I have a cross tab query that has to be used in a report and the columns will increase or decrease depending on the...

My (1)query of another temporary (2)query stops working when the temporary (2)query is deleted and recreated. It(1) says it can no longer find the...

Hello everybody. I'm new to Access, and I've been trying all day to write a simple query that will compare a field in two different tables and show me the...

I hate tabs and toolbars! Therefore I don't like Firefox either. Can I disable them? I might it try if so. I like maximum screen space dedicated to the site...

How do I query all cells or the whole column of a field in a table into one cell? I will then export the newly created table for use in a Word merge.

I'm needing to create a calendar table in my database - fields should be date, start time, and end time (hour blocks from 8 am to 8 pm). I want to have it...

I created a form with a combo box to select query parameters. I run the form from a report. Everything works, but prior to showing the data I receive an...

I am developing a small stand-alone Access application that uses many queries and I am constantly making changes to the queries. I would like to run the...

Errors about Format(), Right(), Left() functions started when I took reports and querys made in Access2000 and applied SP3 environment. Is this a dll or...

Hi, we use Access 2003 to hold our e-mail lists. Every month I have to import new e-mail lists as tables the database, but before I can use those tables, I...

I have a combo box that has a rowsource associated with a query/view. I'd like to add the option for "All" at the top of the combo box. I see this all the...

Please assist Need totals on 3 groups group 1: certain titles belong to exec group group 2: people with sales 10 group 3: muchkins group

I have a query that has a business type field. The field is populated with either a 1 a 2 or a 3. In the fields criteria, I've used a criteria that is...

I have a database that has two drop down lists - one for employees, and another for a group. I also have a checkbox that is checked whenever correspondence...

I am trying to generate output from a query for a large list of company names with associated individuals linked to these companies. Ideally, I would like to...

IIf (DLookUp("","","='" & !Product & "'") and ()= Null) , True , False Ok, first question is, can I put a formula like this in a query that runs a report....

I have 2 tables; Orders, and Time. Each table is related by the "Invoice Number" field. The "Time" table has several records with the same Invoice Number. I...

I'm trying to utilize the dsum command in my query. In this query the field should come up with the same name. However, there are several dates which I...

I am trying to create a Report based on a Query that prompts for a date range. I need to display a chart of the daily averages of the dates with in the...

Hi, Sorry if the subject is confusing, doesn't make sense, or just makes me look stupid. I've been learning Access on my own at work, and I need to...