Hi, I created the Survey Database. I chose the Memo filed for my questions since all questions are long. I would like to give you an example of one...

Hi, Team Amount Date ------- --------- ------ Blue 100 01/03/2008 Blue 200 ...

I have a field that contains 6 digits, then an astrik, then 3 digits, then an astrik , then possible 2 digits, then an astrik and 1 digit. I need to filter...

I have two date fields and I need the number of days from one date to the other. My fields are and Date: . I want the number of days between the two. So...

Hi there As an example, my input table and output result as below Date AA BB AA(1+2) AA(3+4) AA (5+6) 090308 ...

I want to run a query on a table in which I have memo fields, thus they contain greater than 255 characters, and output all the values in the field, not just...

For testing purposes, I want to restrict the query to a range of numerical values e.g. 4999. I get error messages when I try to type 4999 in the criteria...

I have a series of daily date readings(over 3 years) and would like to sum those by calendar month and year. The table is: Date Volume 1/1/07 ...

My vb6 and vb.net application needs to be used with a jet database (already does) and sql server 2005. In the software, i have written all queries using...

I'm currently building a pass through query which ties to an IBM Iseries ODBC driver. Is there any way to include an "in" statement from another non-pass...

Hello, What do I put to trim off the spaces after a value in query? The table is obtained from ODBC link and the values on a field somehow got spaces....

greetings Lets say I have 2 tables: the 1st table has a field, ID1, with records a,b,c,d... and the 2nd table has a field, ID2, with records...

I used the dupicate wizrd in Access 07 to find dupes in my table; I have 5 columns: student id, courseid, semester, grade, and course year. I identified the...

Hi, So I've got a form based on a query with user input criteria - no problem. However, on asking the user for input, is there a way to restrict his/her...

-- Allen Phailat Wongakanit

I have a table, time (GMT +9) looks like this 11:25:00 AM 01:21:12 PM 03:12:00 PM I need to convert them into 2 hours slower (GMT+7) My Desired output...

Hi, I am trying to rank customers based on sales. I created the following...

Greetings all, I am attempting to create what seems (to me at least) to be a very complex query. I have a form (which will eventually link to my query when I...

I am school teacher and want to use my Access 2007 to rank scores of students in examinations.

My database is such where I have Stores at each location. Firstly how do I initialise a store such that it shows 0.00 if there is no stock. Then from say...