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

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

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

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

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

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

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

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

I'm trying to use the CHOOSE function as criteria in a query. Of course, it's pointed to an option group on a form. The form's option group has values 1, 2,...

Hello... I have table with these values: Date Product Imported Exported Total I want to view the data of the current month...

This query is for agings debts. I want only to pull the records that are 1-45 days old. I've tried a number of ways ,but it still gives me all 56000 records...

I have a table (Class Table) .... Class ID (Key), Division, Class Description, and Class On my second table I have Entry # (key), Division and Class I need...

Hi folks! Sorry, but I really need urgent help. I have a table with the following fields: Date info1 info2 info3 info4 info5 I made a...

Is there a function to take the information to the left or right of a comma? The issue is that I received a spreadsheet that has lastname, firstname and I want...

I have an existing database used every 3 months for the last 4-5 years. Today, when I tried to open an existing make table query, the entire database closes....

Is there a way to query one record from a table. Specifically say the second record or the third record. I mean the criteria would not be specific data it...

Hello, all; I am trying to return just the records for a given course if the course id is given in the parameter of a parameter query, or all if the course...

Order # Service 1 A 1 B 2 A 3 A 3 B 3 C ..... I have the above query in which orders...

Hi there, I am trying to make a referral database for my boss. I have two tables REFERRALS and CODES. In REFERRALS, the table contains surname,name, date...