Hi Allen. Thanks for your help. In my query, I want to search between two date fields that are formatted dd/mm/yyyy using the date field that is formatted...

I am trying to run an update query and MS Access fails to update any of the records because of type conversion failure. I am not sure what this means, since...

I have an ID field set to autonumber. The table has a primary key combined of three other fields, ID is not one of them The table is being populated via a form...

I've been having a problem with grouping in my queries and I finally figured out how to do what John Spencer suggested ... SELECT , Sum(IIF(30,CyTotal,0)) as...

Hi There, I have a query that uses the Date\Time function and displays it as DD\MM\YY HH:MM:SS. I'm trying to extract any occurance of where the time is 30...

Is there a way to write a third query that shows the records on a form to be from using either query 1 OR query 2 depending on which query was run? That is,...

I have this query (yes I know "date" is a reserved word). I would like it to find the maximum date per "cont_eduID" and only if it is over a year old return...

Hello, I have a SELECT statement (SELECT DISTINCT Products FROM Shelf UNION SELECT ' @#@#@#@#' AS Col1 FROM Shelf) that...

Hi, I have a querry field which is store some date value like this format "month&day" 0427 0428 0429 0430 0501 0502

I have a field containing which I want to switch into and . I need syntax assistance for an update query which I can paste. Data is Existing ...

I'm using a make table query to create a new table from Paradox tables. There are about 80,000 records in the Paradox tables and the process takes about 30...

I have Microsoft Office XP Standard, Version 2002 that I bought separately. I bought a third computer and I want to activate this product so I can use Excel...

Can someone suggest some logic for the following: I have two tables: one gives a listing of items and the second gives a listing of transactions performed on...

In a sorted table, is there a way to select the first record for a group?

Alright, so I have been scouring the newsgroups trying to find a solution to my problem, but it seems to escape me. Here is what I have. There are two tables...

Hello, In one of my fields, i have customers names so in the future i can tracks how many requests came from one certain customer.Is there a query search that...

Date By Week: DatePart("ww",.) in Field. This would show all records. But I want to have criteria to query records between today and back 10 weeks. I...

Hello I have a table which records the number of staff receiving an education class, with a separate field for different staff types. I can create a query to...

SELECT SUM (care_charges + other_charges + Pay_late_fee_daily + pickup_late_fee_minute + payment_amount) FROM payments WHERE ID = MMColParam AND...