Dear Hlepers, I want to change default settings (graph area colour, border, type, etc.) within the PivotGraph data viewer. COuld anybody give a...

I have two computers. a vintage Apple IIE run under Prodos and a Dell Pentium running under Windows 98. I produce mailing labels. My labels are selected by a...

SELECT TOP not working Hi, I have patched Access 2003 and XP SP2 but when I run a select TOP with: SELECT TOP 1000 ID FROM ORDER BY DESC

I have a Make Table Query that I use to make an initial table, the data type in one filed is TEXT. the Field Size is being set to 2, because the length I am...

Hi, can any one help please... I am writing a Data Definition query to make a table.. one field is for Dates of Birth.. How can i force the format...

I have a form to append information to a table. On this form their are several combo boxes. If a combo box is selected with information and when the form is...

This should be simple, but I haven't been able to figure it out. How do I update a field to uppercase? I tried building a SQL statement, but haven't got it...

A database was upgraded to Access 2003. The following query does not work: Select CurrentUser; The message "Unknown function..." is returned. Version of MS...

I have a mystery query called ~sq_csfrmModules~sq_cGradeId which I cannot view (it tells me I need read design permission), or delete (requires modify design...

I want to calculate the Median in a Microsoft Access query. How do I do this? Our office is using Excel to process large amounts of water quality data....

I've got a report where I need to get the record count of the RecordSource's query. The query itself pulls values from 4 different textboxes on a form for...

I've been running an application for 2 years with many Date functions. Recently the machine was upgraded to Windows 2000 (not sure if it's related) and now...

Hello- I have two DB's, say DB#1 & DB#2. DB#2 has two queries which look to DB#1 for information. I have two queries because I am looking at information in...

I'm using Access 2003 and I'm trying to get a list of names (and other details) but only want one result per person. However, they have multiple attributes and...

Hi, When i create a query for the top 3 items for my sales column i get the ties as well so sometimes I have more than three. How can i fix this? Gordon

I am introducing data in a table using a form with combo boxes and textboxes, with values selected from a query and from some tables. Begining with cbobox2,...

When I try to open a query that has been ran and used time and time again, now it says "type mismatch in expression". It says that on all of them in...

Table has fields and . Each is date/time, m/d/yy, indexed dupes ok. Query 1 retrieves ; query 2 . I limit return by using "BETWEEN #9/1/04# AND...

I am using the following expression in a querry to convert a text field to a date field. IIf(! Is Null,"",CDate(Mid(,5,2) & "/" & Right(,2) & "/" &...

I have a number 24.50. I'm trying to get the trunc of this value...no rounding (24) via a query. I couldn't find an excel equivalent for "trunc" in access. ...