I need help in designing and creating a select or parameter query. The table has a date field which will need to be is a comparison with today's date. There is...

Hi, I want build a SQL query to generate statistical result from a table(students) in MS Access as below: Student# City Amount 001 toronto 1000 002 ottawa...

I have a program that uses Access 2003 and VBA. I have several queries that need to be dynamically generated. For example, I want to get all the information...

I am running a query on Sales data, which contains Opportunity Status and Fallout Reason field. In the Opp. Status field, the options are Closed...

Has something changed in Access 2003 using "Like" in criteria of a query that feeds a Word MailMerge document? I have several queries that use,...

Hello, NOOB HERE I was wondering if there was a way to replace a multiple numbers with one universal number. Lets say these are phone numbers without the...

Hi there, I need to truncated the content of a Memo field, but the Left,Right & Mid functions come up with an error message that a comma (,) cannot...

I am trying to do a database search using LIKE using the following code: Private Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs)...

I am trying to design a form that will be used for the criteria of a query. What I want the form to do is create a list of files and have those files be the...

I use MSAccess 2002. I have a table with the following columns: Part Description Price Form Button (Memo type) In the Form...

I am using a form to gather information which is used to perform a query. Up until now I have placed the information in textboxes, and then referred to the...

I have two fields. A return date and a sold date. I want to have the criteria for the return date to be "if the return date is greater than the sold date...

I have a drop-down menu that has 6 choices (A, B, C, D, E, F). They convert loosely to fields in a table (i.e. Last Name as choice, LName as field). ...

I need to make a DB with relationships so that I can compare results of a test with the real answers and other people and work out the averages of each section...

I import from another program the prestations of our workers, i have to add up the duration. In Excel i can use the custom format :mm. Is there in Access a...

Hello! Does anyone know how to make a query for this result: cust_id due_date special rank 180912 9.6.2004 1 180912 9.6.2004 1 180912 13.6.2004 ...

I can not sorting data in the program microsoft access for languge right to left .

Uhu, I see. Didn't think that 4 000 000 was to much for an up-to-date It's the sorting that's the killer. 4 000 000 sort queries takes a while, even on a...

If the number always in the same place, 9 then try this Order By val(Mid(MyField,9)) "jlig via AccessMonster.com" wrote: I need my output to like the...

I finally got a book out and read about ADO and DAO--neither one was assigned to my database by default (and I didn't know I needed one or both). I was going...