When I run my query, I get nothing. I know I should at least be getting one record, as there is currently only one record that contains this information.

Hello!! Sins I´m using a swedish Access 2000 I don´t know the english word for the different expressions but I will try to explain my problem the best I...

Hi, In a query I've Count(sold) as yr_total Salesman_ID Sum(cost) as in_total

I have two columns with the same data type of OLE Object. Is that possible to update one using the other? The following gave me an error: update table1 set...

i have the following table year # loans type percentage 1982 5 conv 1982 4 fha 1983 1 ...

I want to create a query where when you run it it gives you a pull down menu to choose the data to query it by. Basically I want the dialog box to have a pull...

I have ProductID Qty UP 75 20 4.9 75 30 4.8 77 22 3.9 78 23...

How can I force queries in Access 97 to use binary string comparison (as in an unmatched query) instead of case insensitive?

I'm trying to use the calculated value from one field in my query in another calculated field within the same query. The first field calculates a number for...

How can I take the results of a query's email address field and lump them together separated by semicolons so that they are ready to paste into the TO line of...

ho ho ho ho The primary key as autonumber in the my table was out of order and the program is to close and not save. The form input data from the source of...

Hi all, In my DB I have a table that contains for each date the price returns of a set of stocks: example: DATE, STOCK LABEL, RETURNS date1, AAA, 10 date1,...

Im sitting at home creating a Database using MS ACCESS 2000. i would like to use some of the dao commands in vba to create & run SQL statements. So, i was...

Access 2K/Win2K. Field has date/time data type. Data is only date - no time included. Using the criteria: between date()-1 and date() but getting error: Data...

OK. I have a crosstab query that needs to show the project name across the top, people's names down the side, and the time on each project in the middle. Along...

Hi, Every night I run a series of make tables that are based on some transactional tables. The field in the transactional table is formatted as a number...

I have two tables and I need to get a third table with the differences : Table 1 --------- Field1 :- A Field2 :- AAA Field3 :- Old table B BBB Old table C...

I am using Access to preform an Append Querry but no records will append.

Hello I have a table with a column named "Policy". Unfortunately, it is an imported table without a primary key. My problem is that I need to distinguish...

I am pulling data from 3 tables and it is possible a report may be pulled executing this query when no record has yet been created in one of the tables. When...