I have around 1500 products with pictures and they both share the same name. The are associated with each other using this product code.Now i have to update...

I am trying to automatically send an email to a clerk to show the most recently added record so that she can forward the request for approval. Users,...

I have a column in a table that contains rates as text data type. Here are some examples Prime Rate + 0.5000% Prime Rate - 0.2000% Prime Rate - Cap Rate I...

I created a form with two bound list boxes using the method found on Woody's Access Watch by Susan Sales Harkins. I added the following criteria to the query...

Hi, I have written stored procedure, which accepts input and produces results set depends on input parameter. How can I export stored procedure results to...

Is it possible to UPDATE more multiple tables in a *single* UPDATE Query? Something like: docmd.runsql("UPDATE MyTable1, MyTable2, MyTable3 SET...

Hello I have 2 tables, one called tbProducts the other tbOptions, basically I want 5 like records in tbOptions for each record in tbProducts no less no more!...

Hey everyone I need help with an up-date query. I have a txt file I would like to import into access and update a table containing three columns. The txt...

I have two time fields ( and ), where some of the data contains both the date and time (ex: 10/15/2006 11:37:12 PM), some is just the time, and some is null...

I have a control table(pay_period) with 1 row and 1 column called pay_pd_id the value is '070105'. I'm trying to join to a table with many rows for the same...

Hello, I am trying to find all records in a table (whose entries have either 8 or 9 characters) where the value of the 8th character is either N, E, S, or...

Can I run a make table query using two tables and also add a begin date field and a end date field that will prompt the user? Thanks,

Hi i have a field in the following format 'Surname, Forename'. I want to split this info two fields - which is the best way of doing this please./ Tks A

I have a problem with this update query I'm trying to make. I'll try to explain best I can. I have I table that contains a list of companys I deal with all...

Hello, I hope you can help. I am trying to get a set of results from my data (a sort of pivot table.. the number of clients referred by banks within a...

Other than changing the type of field, is there a way to convert dates to their numeric values? For example, 5/28/2006 to 38865.

I have a table which shows visits to different units by dates and then whether there was a problem found (using Yes/No) and then several other fields to...

Lets say I have a few tables; table1 Customers: CustomerID, Name,Address,.. table2: Products: ProductID, Description, Cost table3: Transactions: CustomerID,...

Hi, I'm using Access 2002 I have a Query (Query1) which creates 3 sum totals from a table of numerical data. I'd like this query run and the 3 totals...

I ran a "Make-Table Query" to create a new table in Access 2003. I sorted the "Make-Table Query" in ascending order on a Number field. However, the new table...