Hi, I am running this query below which aims to consolidate the data from a table called Fin0AllAustria into a table called Fin0Austria. Fin0AllAustria's...

In Access 2003, we have run into a problem with binary field types when using make table queries. It occurs when we want specific data in a table to be...

Hi, I have created following query.. but i would like to know how we can use %% with the variable at where clause. I tried %% but its giving me...

My Table has duplicated rows for each item. I need to derive a query list from the Table that represents each item only once or only one of the...

Hi I have a basic query I wish to look up an invoice number in a table and for it to return the date value, table 1 invoice range invoice from - invoice to...

I hope someone can shed some light on this problem I am having. I am quering a database that has 5794 records, and when I use the LIKE syntax I will get back...

I have a table with 2 columns both links to other tables containing descriptions for the ids. I need a query to provide a recordsource for a form that returns...

I used a crosstable query to combine information. I need to know how to combine all date groups of the same date. I may have two or three fields of 5/05/05,...

I have created the following iff statement to key off of a text box on a separate form, but it is not working, what am I doing...

I am trying to create a query that will join 2 tables together when they have the same first and last name and same Date Of Birth....however the one table is...

Hi, I got a problem with this query, it always come out 1 record but it's include the other record with diffrent case_no ID. For example I search...

Hi. I have a query which selects data from 1 table. The query produces the following result... ID Station Amount 1 Receiving 54 2 Receiving ...

I have a database with the following fields: Date Volume Specifically, I am trying to write a query that will select the record (Volume) if it is the highest...

I feel really dumb that I can't get this to work, but here goes! A dialog box filters a report by way of a query. The underlying table has a yes/no field...

Hello all, I would like to know if anyone can point me to a good place to learn about date type functions, queries etc... for MS Access. I am trying to build...

I am having a difficult time trying to write a query that will display different outputs depending on what is listing in the text box. For example I have a...

Hi all, There is a text field that does not allow zero string and is not a required field. In SQL Server inserting a null value is something like this: Insert...

I have a table that has the following pertinent fields: Date, Qty Each day a new record is added with that date and the new quantity. I need to write a query...

I have a daily query that pulls a large amount of data (800k+ records) from a badly engineered Oracle Database. The query itself is pulling data from...

I have a query that is based on a table containing job numbers. When the query runs it prompts the user for the job number. How can I validate that it is a...