Hi, I need to compare three numeric fields and pick the greater of the three; I will then have to use that number in subsequent calculations. Any help with...

Hi, I am using Access 2002 and I have a query that I would like to count a particular field, the problem is that my table has 500 records and I know that...

Trying to do a query with only records showing between certain dates in descending order. Not sure where I'm going wrong. Have tried several codes but for...

I have a number of Edit Queries that I execute as part of an automated process. I only want to display to the user the Edit queries that have results. I have...

Dear All, Till yesterday this database was working quiet fine. Today its throwing the error while saving or quiting "Operations must use an updatable query"....

I have 121 records in a Table called survey. When I run a Query, only 118 records display. What am I doing wrong? I have no filters applied.

It's been a while since I have used Access. I am trying to run a query so that I can use it for a report. I need to show dates for four different categories...

Table has a field named in second (Number DataType) I want to format seconds into "HH:mm:ss". What is wrong with following expression? \3600 & ":" & ( Mod...

I have a field in a database that contains several different possible values: ad, am, rp, etc. It is possible to have a combination of values, such as ad/rp,...

Would performance be better if I queried a linked table or if I used a pass-through query? and why? or would it matter at all?

Hi - I want to run an update a memo field using an update query. not sure why it will not let me update the field when there is more than 127 characters. it...

This is my second post for this - thank you Each month I create a new table using the SQL below, where the records are just copied from the GoalsMain table,...

I want a drop down box of valid values on my parameter query. Per online examples, I created a form, which allows me to see a drop down box of valid values...

I have a query that is pulling data from one talbe. If there are duplicateds, which there are, How can I combine them? Same customer number, same name, same...

Hi, I am new to vb and MS access and database programming. I am doing a project for Distributor Invoice system. I have problems as mentioned below. I have 2...

Hi all, I don't know if I'm drawing a blank and missing something easy and obvious, but what I'd like to to is take my table that has 2 date columns and build...

Hi, I'm kind of new at Access. I know how to do this in T-SQL script for SQL server but can someone tell me how to do this in Access 2000? 1. I need to...

Using Access 2003: I cannot seem to be able to use the operator in an IIF query criterion. Why is that and what should I do instead? Example: if a...

I have the following setup in a query. I need return all records if parameter is left blank. criteria = +Space(3) or = +space(3) is Null also have...

This seems to be a common problem from looking at all the other postings... Anyway, I have a very simple query that runs fine from the database...