Errors about Format(), Right(), Left() functions started when I took reports and querys made in Access2000 and applied SP3 environment. Is this a dll or...

I am developing a small stand-alone Access application that uses many queries and I am constantly making changes to the queries. I would like to run the...

I created a form with a combo box to select query parameters. I run the form from a report. Everything works, but prior to showing the data I receive an...

I'm needing to create a calendar table in my database - fields should be date, start time, and end time (hour blocks from 8 am to 8 pm). I want to have it...

How do I query all cells or the whole column of a field in a table into one cell? I will then export the newly created table for use in a Word merge.

I hate tabs and toolbars! Therefore I don't like Firefox either. Can I disable them? I might it try if so. I like maximum screen space dedicated to the site...

Hello everybody. I'm new to Access, and I've been trying all day to write a simple query that will compare a field in two different tables and show me the...

My (1)query of another temporary (2)query stops working when the temporary (2)query is deleted and recreated. It(1) says it can no longer find the...

Hello all, ok I have an issue here.. I have a cross tab query that has to be used in a report and the columns will increase or decrease depending on the...

In access when creating a query I want to format the date of the output to dddd, d MMMM yyyy (e.g Wednesday, 15 Novemeber 2006). I found the function...

Hi everyone, I am using ADO with Microsoft.Jet.OLEDB.4.0 to connect to the Access97 database. The problem is every time when I use WHERE clause with...

Hello, I have an Access database with a table containing a decimal field wich has these properties: precision: 18 scale: 5 decimal places: 5 I need to change...

As part of a safety stock - reorder point analysis, I want to compute the historical consumption during specified time windows. As a start point, I have a list...

Here are my fields. This field is sometimes blank. I currently have: Expr1: & " " & & " " & The problem with this is if the field is left blank it...

I am new at the use of access. I am using Access 2000 on a Windows 2000 system. My question is (if possible). Select records with the greatest date...

I need to I need to set up a mailing list with criteria such as: 541101 - 541105. Is it possible to do this? I've been working on this for a while! If it is...

Hello all, I'm new to access and having some difficulities. Any help I could get I would really appricate. I have two tables from which im trying to combine...

I need to take a field value from multiple records in one table and append those values to the end of an associated single record in another table. (Or,...

Hi I need to summarise the amount of inventory used over a specified period, I have a query that gathers this data but I need to calculate totals for each...

I have two tables with mostly the same fields. Specifically, they both contain a field called "Author." I would like to design a query that allows me to...