Recent content by gaby

Thanks. I understand. Very Good Link. This is a daily call report and although I'll like it to be different that is the way I receive the data.

This file has call records. A call can repeat or have different status but basically the record is the same. What I'm doing here is correcting records were for some reason there was a mistake and the call wasn't marked as sale. If I change more than one instance then I'll duplicate the sale...

Since the record is repeated and you don't want to add it you can group by account number, print only group totals and instead of using sum you can use max, min or avg function as it will yield the same result. Even though it might not be a very elegant solution if you don't want to...

DateTime Stamp

It's just a matter of view, previous issues aren't exactly duplicates. You will search the table of issues where the serial number is equal to the serial number of the warranty. Create a query of the issues table and filter by the serial number related. If you want to make it more flexible...

A possible simple solution. Make 3 tables: 1-Dept_Colors (DeptID, Color), 2-Grade_Colors (GradeID, Color), 3-Emply (EmplyID,Dept,Grade). Make a query where you join the Employee Dept and grade with the respective table id. then filter results where the color form the grade matches the color for...

Expr1: IIf((Left([f1],1)<>"*"),(Format([F1],"00")),("*" & Format((Right([f1],1)),"00"))) This will evaluate if the asterisk is present and format accordingly.

I need to update a table using a query to reference the the records to be updated. The problem is that on the table there might be multiple record of the instance I need to update. I need to update just one and change it's status to SALE. I use a select query to retrieve a single record; this...

I'm having a similar issue as yours. Serching for an answer found this article in microsoft support com (can't include the link!) Article ID: 292634 How to use a query to filter unique data in Access. It explains how to use group and total functions together. Hope this will help you resolve...

use a query that uses one of the aggregate (totals) functions, such as First() or Last(), in the fields that do not contain duplicate data. In the fields that do contain duplicate data, use the GroupBy() function. So you could GROUP by account number and then ask for the First or Last record...

As I understand you are stuck to the way the data is collected and your issue is finding the last occurence of the record which is supposed to be the most accurate. I'm having a similar issue where I need to find the first ocurrence and then update. I'm able to find the first occurence using a...