I have an Update Query that asks for 3 fields with parameters. The first parameter is the criteria in the query to identify which record we are updating. ...

Okay, first let me say, I didn't create this query, but I'm trying to fix it or write it better. Now here's the deal, and then I'll tell you the problem. We...

I'm stuck, trying to base the contents of a listbox upon a query with a variable parameter. The trouble lies in the fact that if I set the listbox control to...

I have created an update query to update a master file. When I run the select query to view the records I need to update - I see the correct data. When I...

I have created a union query and now want to create a field alias to specify which records come from which query. The union query works as such: SELECT * FROM...

I've got a table I'm trying to update with data from another table. The table to be updated has multiple columns but I'm concerned with two: DEPT ...

Hello, I am rephrasing/simplifying a question I posted earlier so that somebody might know what's going wrong. I am using two action queries in a form. A...

I have a table with a date field that the user left blank sometimes. Now I need to use it to find out how many monts between todays date and the date in the...

I am using both Word and Access 2003. When I merge a Word Letter with Access, sometimes not all of the queries show up, in the drop down box, to link the...

I am trying to create a query that will give me a cumulative change in contract amounts for each change order that is issued. Each Contract can be identified...

Is it possible to sort 6-level WBS numbers in Access 2002 or 2003? Ex: A.2.3.6.5.1 A.1.6.9.1.3 to A.1.6.9.1.3 A.2.3.6.5.1 Thx.

I have a query by form whereby the form has a Command Button to run a module which checks to see if the query has records. If the record count is 0 it opens...

Can you have a criteria in a UNION query? If so how it is done? I've been able to get the original query working from VBA and it works perfectly thanks to the...

Good morning, I have 3 fields , , & . Rotation and adn are True/False fields. The printtab is a number field. In stead of having 3 SQL statements, I'd like to...

I have a crosstab query with Well Name as row heading , site visit Dates as column headings (formatted as "yyyy"), and averaged water level measurements data...

Hi! Say you have a table A with fields field1, field2, field3 and field4 and I want to shift values so field1 receives the value from field2, field2...

I have a database that tracks cadets that will commission into the military and they are broken into their year groups. My problem is that to generate a...

A co-worker and I are muddling our way through Access to try and build a report. I do Word, Excel, and VBA, and have tied myself in knots with Access before;...

The below query works well as a Select Query. But when I turn it into an update query, I get a whole lot of nothing in the results. Interestingly, if I try...

Hi- I have this suspicion that if I were to run an update query w/o cacheing an undo file, the whole thing would run faster. Does this sound reasonable? Is it...