I have an old Access 2003 table with logical fields to categorise my clients, once there where no multivalued fields in that version. I converted that...

Is there a way to insert a website link onto a report?

Below is my current Query. It behaves oddly. I am rather new to this all. At this time there is only 1 Record in the Address table, and that address is used...

I have checked AutoJoin in the Access Options, however, when i place two tables w/ identical primary keys, it does not auto join them. It appears to be not...

First post, after much lurking. I'm fairly new to Access, so please go easy on me, everyone! I'm having problems with deleting records. I have an archive...

Hi All, I have two large tables (year 1 and year 2) of financial transactions that contain a field with supplier name. I need to compare both tables for...

how do I correct this error?

How can I query a fiscal year of October 1,2009 to September 30,2010 with expression in a query? Is it possible to do this without changing the to and from...

I have a database made in ms 2003, i installed ms2007 and now the querry does not recognize dates in the year 2010.... anyone have similar problem and find a...

I'm driving myself insane trying to find the answer to what I believe is an incredibly simple question....trying to teach myself Access as I go along. I have...

Hi Guys, This is the first time after school that I am trying to use ms access at work and i need ur help in creating a query. Any help will be highly...

I have a table with a field for names. Some entries include the ampersand (&); for example, John & Mary Smith. The database is also FTP to our web site and a...

I finally got a query to pull exactly what I wanted from the table, however the query is based on a crosstab query and a select query. I'm trying to make it...

Is there a way to delete identical records in a table where all the fields are identical? The way I have been doing it is by creating new auto number field...

Okay, I am trying to put together a logical formula similar to what I would in Excel. This is what I have. But I want more options. For example, if they have...

Hi, I have 2 tables: tblRecord and tblRange tblRange contain 4 field: fldCode, fldStart, fldEnd fldCode (Text)(Only Manager will know the code, User will not...

Hi, I need to convert a QBE query to sql string The QBE in sql is as follows: SELECT EmployeePlant.EmployeeID, EmployeePlant.EmployeeName,...

I have access to a database that shows a list of department names in our company. The format for entering the names wasn't standardized, so the text can have...

I have a query with specific results that have fields such as concatenation, division, amount, etc....I want to have a field which numbers the rows in...

I'm using 2007. I have combo boxes on my data entry form. For example: Pipe Material. Choices a PVC, Concrete, CLay. The query does not return the...