Hi all, I am facing the following problem: Two tables: Table1 Name Code Hans A1

Hello.- I am having problems with a query that it might seem simple but is giving me a lot of problems. Most of the values given by the query are incorrect,...

I'm very new to this so forgive this idiotic question. I've managed to set up a parameter query. However, I don't know how to apply Boolean operators so...

Is there any way to avoid this damn error? Trying to convert using CDbl() does not work. As best as I can tell, all of the data fits 8.4, which is the way the...

Hi, I have 2 databases consisting of a table each.e.g. Database 1 has table 'A' with around 65000 records and Database 2 has table 'B' with around 85000...

Im running a query and normally there is only a field-name in heading. I have multiple tables with equal field names. Now I want to get table names in...

Hi guys, Basically I'm wanting a query to produce DISTINCT results for "gallery.prod_title" only; obviously there are two tables involved. With the DISTINCT...

And why did they choose to include crosstab queries? I suppose they make some decisions like any other implementation of SQL. I would rather have crosstabs...

Use controls on forms for users to select criteria values. -- Duane Hookom Microsoft Access MVP "Ron Berry" wrote: I am trying to create a report that...

Is the report grouped by position number? Do you have grouping and sorting you could share with us? Do you want to count the employees in each position...

What do you mean by "total number of incumbents for each position number"? You need to ask questions in terms of records, fields, values, calculations,... --...

Hi Karl, Tried the first one and does exactly what I want Thanks again "KARL DEWEY" wrote: Try these two queries.

My table has the following fields ItemNo Name Image DateRecd 123 Foo 00 1/1/06 123 ...

Hi I am Using Microsoft Access 2003. I have a problem getting the name of the Table. I want to prompt the user for the name of the table so that i could run a...

Try these two queries. Grd_Bonus_1 --- SELECT EM_List.PERSONNEL_NO, EM_List.HIRE_DATE, Grd.bonus, Grd.EffDate FROM EM_List, Grd WHERE...

Hi, I am having trouble with a query/macro that has stopped working. I have 618 records in the table, and it won't pick up any data after about the 615th...

I have created a report by department that shows the position number and other related data. The position number has multiple employees assisgned...

I have created a report that shows position numbers of employees in a department, but there are multiple employees in each position number (identified by...

I am trying to create a report that users can use that has drop down options for the user to use as filters - much like the "Filter by Form" option...

what does this error mean: "Operation must use an updateable query"