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

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

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

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 am running this query below which aims to consolidate the data from a table called Fin0AllAustria into a table called Fin0Austria. Fin0AllAustria's...

I have a form based on a user input query (single field, which is indexed) that pulls data from a linked table with over 376,000 records (and growing). It...

I need to check for a date in three fields use the following in the criteria field. The fields are Date1 Date2 and Date3. I need to print a report showing...

Hello. I'd like to create a query that checks for duplicate records and deletes the record that, on an autonumber field, has the smaller value? Thanks.

Hi. I am very new to access, and I want to copy data from multiple tables into one table, based on criteria and such. I have tried an append query, and I do...

Access 97. I've got two tables. The first table has 3 fields. Sample data as follows A 06/01/2005 06/07/2005 B 06/08/2005 06/15/2005 D 06/16/2005 ...

In my table I hve a field named photoCount, which contains the total number of photos related to this record, and one called Photo, which gives the name of the...

I have two table; TableA and TableB having the same structure. TableB has some records that do not exist in TableA. How do I write a Query to update TableA to...

..

I am getting an error message with my SQL statement. It says "syntax error (missing operator) in query expression 'Unit_Names.UnitLong WHERE (....)". my...

I have two queries that were working fine using left outer joins. The first, ALLPASTCLASSES, still works great and in SQL (which I really don't work in much)...

I have created a search query within Access 2002 which looks for partial details within a field as below: SELECT Stock., Stock.Description FROM Stock WHERE...