In an Access query, I'd like to have an expression that takes the current day of the week (Sun through Sat) and returns the date for Saturday (in "Short Date"...

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

Hi, This is a continuation of a post a few days ago. Apologies about the time lag, but the question is from a contract I am working on only 1 day per week,...

I'd like to run a SQL statement which will return a single number, and assign this number to a variable. Here's the SQL statement: "SELECT COUNT(ReceiptID)...

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

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

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

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

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

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

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

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

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.

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

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