I hope that someone can assist me with a little dilemma I have a database which as the following tables/fields Contacts ContactID LastName ...

Hi all I have an address file with 50k records The fields are Add1, Add2, - Add6, Postcode The postcode field has such information but this information is...

Hi all, I am struggling with the following: I have made a table where a define Case / Description Case / SQL-code The sql-code is the correct code (with !......

Hi I've a table that has one column with 2.5 million entries in the column. When I create a query to group and get a count of the entries Access locks up...

I have a query in Access2007 which contains reansactions of several years. I work in design mode and I want my query to return only transactions of a custom...

I'm trying to group items together based on a series of numbers but the last 2 numbers don't matter. For example 40-3558-23 40-3558-30 60-2583-13 I'd like...

I am attempting to append one table with another. I have several fields whose names are in the form of xxx - yyyy, aaaa - bb, etc. There is a space on...

I have a table that came from an excel spreadsheet. I then query that table and have a report based on that query that is used by people in my office. That...

Hello, I have a subform that queries based off selection in main form. One of the fields on the main form has a combo box with a list of operators: =, ,,...

Our business uses Client Codes to identify clients and to derive Project Codes. The Client Code consists of the first three letters of the client's last...

Hi. I'm having some problems in converting decimal values into hours. Sometimes my decimal values are less then 1, that means that the hours are less then...

Good Afternoon, I'm trying to write a query that performs a SQL join and returns all the records from a linked table on a single line. Ultimately, I want an...

I has found some sites with cheap marlboro cigarettes with delivery to usa and europe: === http://www.google.com/search?hl=en&q=cheapcigarette he can...

I have a team of people unable to work today!!!! When they run this command an error indicating Error 3075 - Function is not available in expressions in...

Hi All I am trying to add the hyperlink in my query. Its a combination file path and the file name is made up of 2 records. FKQuoteID and Revision followed by...

Hallo, I tried to update a connected SQL Server Table (with ODBC) in Access 2003. Like this -- I need the last day of the month in this table. UPDATE...

I have a query that has submit dates... 9/3/2007, 10/15/2007, etc. I need a way to group all dates together for one month and label it as September...

I am trying to run a query but I get the "action or event is blocked by the Diasbled Mode". Supposedly I can turn this message off on the "message bar" but...

Hi, I need to create a query to select dates that are between date 1 (1985-11-04) and date 2 (1985-11-11). Currently no records are showing up when I do...

I keep getting variable results from the following query. SELECT tktimcrd.employee, Trim() & ", " & Trim() AS EmployeeName, (Sum(IIf( Not In...