I am using Access 2007 and have created a query using several linked tables from a different database using ODBC connection. When I run the query as a SELECT...

To prepare data for an upload, we need to query for illegal characters such as & ? \ within descriptions and other billing info. This has been successful for...

I have a 2007 DB with first and last name fields. I am trying to merge them in a common field I know it is unusual. I have created a select query that...

Hi everyone! Using A02 on XP. I need to pull records based upon the originator which is either 3 initials (ABC) or a contract number (GP1234). I could say...

I am wondering if there is a way to compare data from August first of the previous year to the present date against Everything before August first of the...

Put the requirements in a translation Check table like this -- Check_Table LevelID qryNRS_SS_Low qryNRS_SS_High NRSLevelID 2 181 ...

what criteria can I use in MS Access in design view to only show the most recent date when multiple dates are resulted? for example if a query results in a...

tdp wrote: Hi--Forgive my question--I have used Access quite a bit but VBA hardly at all. I need to return a value based on two numerical values in a...

Hello all, I have the following 3 fields: Student ID (Row Heading), School Year End (Column Heading) and Data (Value) I create a crosstab query as indicated...

Hi - I have read all the "complex IIF" statement and research the Switch Function. I have a table that contains Instructors, various Dollar Amount to Charge...

I have recently name a query and it is working how it should. However one thing that I would like to add to it is a dropdown list of things to choose from...

Hello, I have a table that holds records of part numbers and also where the part is used. So, part A123 could be listed in multiple rows if it is used on...

I am trying to create a query with two tables; from one table I'm using the fields EmpName, DateAbsentFrom (specifying a certain date range), DateAbsentTo,...

I have a table that has a street name field it contains an address like 123 Main St. I want to know how to make a query that would look for street...

Hello, I am using the Stephen Lebans / Peter Schoeders serialize function as line counter in a query. Once I apply a criteria in the query, the line counter...

I am attempting to generate a query using two tables that have multiple relationships. When I run the query, I know I should get some results, but don't get...

Ok so here is the problem....I am using Access to track the keys we issue to employees from request to issuance to return. I have the employee fill out an...

Hi, I am attempting to create a running count within a group in my query (using design view). The goal is to time-zero the data so that rather than a date...

Hi Guys, I am trying to complete an update query, this is my SQL: UPDATE dbo_PROD LEFT JOIN dbo_DS_SKU ON dbo_PROD. = dbo_DS_SKU.SKU_code SET...

I posted this a few days ago, but no one has replied yet. If someone has any suggestions that would be great. I think the problem is with my coding in the...