I have a field that I need to replace Co with Company Most of the time Co is at the end of the CompanyName but sometimes it is in the middle of CompanyName ...

I have a query with 5 fields , ,,, Permit Type has 3 values, either "Season Ticket, Standard Ticket & Concession" There are approx 70 different schools I...

I have a text field with date like data in it but its text data. THe field looks like 31Dec2009 - how can i reformat that so its a recognized date field that...

Some people decided to play a cruel joke and pulled two commas into a name field and i need to split the name into a first and last name column. Normally i...

Just like using the Forms!FormName!FieldName....can I use that same logic with Tables? I have a start and end date in two fields within a single table. I...

I'm working in Access 07 but creating a database that is 2003 compatible. I am absolutely sure that I am over-thinking this but can't seem to resolve my...

I have developed this query for my 7th term inventory balances: SELECT ., ., . FROM WHERE (((.)0)); This query for my 8th term balances: SELECT ., ., .

I am working on upsizing my access backend database to SQL Server. I have linked all sql tables to the frontend and am now running into the issue of slow...

I am trying to develop a union query for my 2 inventory balances. the query comes back with the first 2 fields correctly but when it comes to the balances...

Hi I want to join two tables (by UNION ALL). In order two identify the source table I'd like to add a column that would contain a table name (typed in in...

I have a table where the field is a TEXT field 20 characters long that I need to join to another table with a field that is a NUMBER field 50 characters...

I have a check box in my query. When I type "Yes" into the criteria row and run the query, I get the results I want. However, when I change it to a parameter...

Hello I'm looking to create a querey that will take mulitple records from a table and put them in 1 record in my query For example, Lets say I have 2 tables,...

In one of my forms I want a subform to be updated the moment I enter it and one of it's combobox be reflecting all the entries in one of the filed in the...

I'm using Office 2003 in a new windows 7 computer. I copied a database to the new computer from the server. When I try to run the following query, I get a...

Access 2007 has a great new feature which allows to easily filter by selecting different values from a drop down box on top of each column. However, sometimes...

Hi all , In my project in Access, i have converted to acess 2003, then I tried to create an MDE but not able to do it. when i tried to create any other...

Ten calendar harm one of the products www.laptop-battery-inc.co.uk/spy-pen.htm

I have an excel file that I'm importing to Access. This field consists of "time"...hours, minutes, seconds. The format in excel is set to "Custom" -...

I've created Query2 based on Query1. When I select individual fields from Query1, the datasheet view displays the original query name in the column heading...