Im trying to build a form with multiple check boxes that each apply a filter to the records displayed. I need for the user to be able to select any...

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

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 a call database that includes a field for length of call. I have created a query that includes employee, date, and length of call. I need to calculate...

I am trying to decipher the “status� of records in my table based on two date fields and the name of the agent assigned to each record. The fields are as...

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

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

hello i have been trying to export a query to an excel file. this query will run once and the data that it selects i want it to export to excel. then the...

I have a query based on two joined tables and need to know how to insert SQL into existing sQL so my query counts "Assigned Consultant" Properly. if the...

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 tried to change the field name in a query using "New Name: ". It did not work at all and just display the caption of the Field Name. Is it possible to...

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