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,...

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...

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...

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.

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 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...

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...

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...

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...

i did a qry, but in one colum the records are duplicate. i want no show those record, how i can do. my SQL SELECT dbo_CMC_PDVC_VAR_COMP.PDPD_ID,...

Hi! I want to create a relationship between two existing tables, but I can't find the query. I'm using an Access 2000 Database. I've tried these...

I have and complex table that is preceded by a heading (not part of the table) "Schedule "A" - Parties Responsibilities". No matter what I do the table is...

I have a form w/ continuous subform that switches between queries for the recordsource. The only difference between the two queries is that there is an...

Calculations for all costs are rounded up to the next dollar on our invoices. The business office personel inputing payments have entered dollar amounts, like...

I am having a problem getting all the records in my main table to show up on a query which has a Left Join to a second table. SQL follows for a Query - is...

Hi guys! Very noobish on Access here, so please forgive my ignorance. I' m trying to make a query where one of the fields is selected by a form. Something...

I need to create a number of Union queries, based on tables with a number of common ID fields, such as TraderID. My question is, is it better to join the two...

greetz and thanks in advance for assistance with what i thought should be a pretty simple task...... i am helping someone who has a single table (may...

Is it possible to find the value of a field in the previous record entered? I have a database which I update, but the value of one field is dependant on the...

Hi everyone: I am having a hard time trying to get my query to work. I only want to return the maximum record from group of records that all have the same...