Any help will be appreciated on this one. I have a database that tracks equipment rentals, the billing for the equipment is done monthly and is based on the...

I have 12 monthly excel files containing a supplier_ID and the supplier_spend for the month. I need to create a consolidation where all unique supplier_IDs...

I need to format a report to show only the last four digits of a social security number. The field is "SocialSecurityNumber" and the format is xxx-xx-. I...

In a query I have 2 Fields that has the following expressions Field 1 - Sum_Of_Count: Count Field 2 - Sum_Of_Failures: Failures Both of these fields...

I have 8 different tables. I would like to sum up that data in one column of each table and display all 8 sums in one query. I wrote this to test my...

I have a union query that pulls up a list of peoples names and some details from 2 tables. One of the tables may have duplicated names (with non-duplicated...

I have an append query to append table A to B in which there is a criteria in one True/False field that specifies False. Today, I had to first append some...

I can't figure out the syntax for my query. Here's what I need it to do: tb1 & tb2 are joined by both having the field If tb1.field1 = "my text" then I want...

Is there something that will allow me to round decimals such as 0.14 to 0.25? I know that Excel has a Ceiling function that works but I can't come up with...

I need my numbers to be exact to 4 decimal places. My data type is a number and the format is 'Standard'. The field size is Long Integer.

I have the following expression in a query. Expr1: IIf(1,"N/A",/) A sample of the results: 68.8008658008658 N/A 3.63636363636364 Is there any way to format...

hi newsgroup, can any one offer some advise? I am trying to create a conditional append query along the following logical manner: INSERT INTO TableB FROM...

I'd like to create reports that contain barcode equivalents of field data. Does Access provide this functionality? Help did not suggest so. Thanks!

I have a customer with a field in a table that I need to find the absolute value of and so far no syntax I have tried has been successful. The field is...

I am trying to extract a portion of a string Here is my string(s) I am playing with 165 E Oregon Ave, Creswell, OR 97426 1517 Bayshore Drive, Coos Bay, OR...

Hi All, I need to determine a future month. I have to days month and I want to add 5 more months. How would I calculate that in a unbound text box. I tried...

I have a field in a table that Utilizes a combo box that is populated by a field in a separate table. Then I have another field that I want to be populated...

I am trying to use the following two IIF statements in a query and the "like part of the statement is not working. column one MTD_Qty_Merch: Sum((IIf( Like...

When I try to put my nested IIf statement into a query, I get the "Text is too long to be edited" message. Here's the...

Hi, I currently have a table that designates tasks, and the people responsible for each task. Certain tasks have multiple people...