I am making a table query however, I get duplicate records, the end of the table, the field Dossier, has a different one for each IDContribuable, however, the...

Hi All, I have a db which records referrals sent into the office. Data entered onto the db includes the usual name of student, school name etc, and also...

I found code to send e-mails via outlook, but can't find anything where you can include an MS Access report as an attachment Steve -- Message posted via...

The query below is suppose to present all the vendor records where = closed or open. The problem is, it does just that and only that. Is there a way to have...

Hi, I have a Query A which has fields F1, F2 and F3. I have another query, Query B which has field F3. How do I create a query, Query C such that it is the...

I have a database which has a list of products and prices in one table. I have another table which is updated each day from a file of new sales. If a new...

I want to omit ALL records if a duplicate entry exists in a query

I have a query that stems from a table with an autonumber field already assigned. One of the fields named 'bp_order' is a number. I need to assign a record...

Hi: I have two tables: T1 and T2 joined by Store #; I want to compare the T1 and T2; when T2 has a new record = new store, I want to append the record to...

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

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

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

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

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

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

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

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