I have a table. the table has a field called "product_id". there are many records with the same product_id. I would like to run a query that will delete all...

Hi, I want to create a report that will always give sales for the current week starting with monday and going to friday. We are closed on Saturday and Sunday...

I am trying to create a make table query that contains an end value dervied from numberic fields within the table. I have 9 different columns where I need to...

I have 2 tables which have a field whose value is either Yes or No. After performing a UNION query on both these tables the corresponding resuting field shows...

My table has a TimeInSec field (Time/Date datatype). This field has ALL NEGATIVE numbers in seconds. I used the following expression to change to regular time...

I keep track of training sessions in a table. I want to run a query that will prompt me to enter in a Last Name, then First to list all training sessions that...

I have three fields (all three text) in a table "a1", "a2" and "a3" How can put all for a1 Plus (combine) a2 into a3 with a query? Thanks

I've got a VB.NET app that needs to delete all the records from a single, unlinked Access table. The table has one field (non-key) of type OLE object. When I...

Dear Sir / Madam I'm Viveck from India. I'm using office 2003 in MS Access i've got an Error, the message is Overflow Please give me the quick reply. Thank...

I have a report that run a query which a user enters a date on a dialog box and the report runs, which works fine. Here is the twist. The use want to run the...

Good afternoon. I've written several INSERT ... SET format queries for my Access FE/MySQL BE, but Access will not let them through. It reports "syntax...

Hi, I have a field called Booking in Date and I need to subtract that from 1/25/05 to get a new field called Days in Jail. I am not sure how to go about this....

Hi, I have just taken over support and development of an Access 2000 database with data held in SQL Server, there are several queries that use linked tables...

I have a few pass-through queries which execute SQL Server stored proc. After I run these queries, Access slows down and become unresponsive - the only way to...

Hi Group, I have downloded Duane Hookom's excellent sample database for Concatenating. My problem is that it is set up to run with primary keys that are...

Hi there, Here's one that's bugging me, I'm developing a quotes system and I have a table containing job quotes that can contain more than one record (version...

Hi, This would be a great help if it can be solved. I have 4500 applications for funding. Each application must meet max 6 conditions to receive...

Hi all, I couldn't find any documentation concerning this topic. I want to put a regular expression in an SQL query under Access. As for an example, under...

I have a table with a field "product_id". The table has a lot of records with the same "product_id", I would like to write a query that will delete all the...