Greetings, I'm having trouble getting unique results from the a query which uses the "last of" a date column and any other fields. Whenever I select...

I have 3 different fields in 2 tables and wish to display them. all the 3 fields have different names in the 2 tables. How do I create a union based on any one...

My query either returns 1.5 million records or it wont run due to the following error. "The SQL statement could not be executed due to an ambiguous...

Hello I’m having some problem to make a query that joins 2 tables. The two tables (by kind of product) have some identical fields and others that are...

I have an Access db that keeps track of employees and dates that tasks are assigned to them, along with their completion date. I have a query that counts the...

I need to do an AND query on the same field in a table. For example, in the simple table that links documents and their associated keywords I might have doc1...

This is a logical question I need answered to help develop a query... We clean things brought into our facility... we want to know what jobs were not completed...

I have a field named Due Dates and also a field named Overdue which is currently blank. When the Due Dates is past due, I want to display in the Overdue...

I created a action log database and I have a field named Due Dates. I named another field Overdue Dates which is currently blank. I the Due Dates are past...

I want to change number datatype to text datatype in quary design grid. I used CStr(number) function. It did not work. Why not? Text is a string datatype? Any...

I have a subreport that is based on a summary query that is based on the same query as the main report. It is my date parameter "Between And " that pops up...

I need to check a large amount of sequential data for duplicate items, missing items, start and end of sequences, and other anomalies. The approach I am using...

Hi, I have two tables that contains almost the same information. The only difference is that one of the tables (Dagsrapporter) has about 400 more records than...

Dear all, I am looking for some assistance with getting some information from a form into a query that goes directly to JET. Presently I am having the error...

Hello all, I'm trying to create a query, but i've problem because i'm not an expert! I have these two...

Hi Guys, I do an import of a number of spreadsheets and rather than simply append the data I want to update or add, anyone help? This is my code: Sub...

I need to create an expression to total 2 columns. The 2 columns are Qunatity 2 and Quantity 3, I would like the 3rd coulmn to be Total Shipped:... Can you...

I have numbers like those below in a column of data I am using in a query. I need a formula to change it. 1013-14 123-1 1233-5 569 I need to get rid of...

I have a database that is just huge, and at some point in time the company will have to archive the data in the tables, for the most part I can do this, the...

I'm trying to figure out how to make the results of one query be available as a dropdown menu prompt for the criteria of another query. Is there an easy way...