Any help would be sincerely appreciated, I have an Access 2003 MDB that works fine under fully patched WinXP system. However the same 2003 MDB is throwing an...

I have a date ordered field and have been asked to identify the number of days since the last 24 hour or more period with no orders. So if I have orders on...

I have done this before but have forgotten and cannot find it on Help. I have a query to find a student by surname but I wish the result to open in a Form. ...

Below is an SQL asks me to enter a perameter value for X.MBFAM# every time I try to run this query. I have written several other SQL's just like this that...

I've a Table that has records regarding birthday, Wheight, Height, sex ond some others fields, I want to build a form to search/sort my...

Hello. I need to build a querie that delete a record if one of this values is the first of the day: "SaÃ*da torniquete 1" or "SaÃ*da torniquete 2" or "SaÃ*da...

Hello, I have a database of retail properties. I need to create what I think is a fairly simple query to find "similar" properties. I am comparing square...

Hello. I'm creating a querie that lists all employee activity. So the querie runs onver a table that has all In and Out of the employees registries....

Hi, I'm working on an application using Access 2003 English. My client is using Access 2003 French. There is only one problem with this "cross-languages"...

I am collecting 3 values from a form - ,, and appending it to a ScheduledPayments table through an "insert into" sql statement (append query. Query works...

May i know how to query all the jobnumber where it is in the same category ID? Because I want to use this as my list in combo box -- Message posted via...

Hi I have a web reporting application that uses an access db. Each time a user requests data the report passes 1 parameter (wonum) and the query creates...

Hello. In my query I need to insert two records set if the result has only two recordset. I need to insert on employees time table the time that they spend...

Hi, I've written a simple crosstab query based upon a select query which has several left joins and subqueries in the WHERE clause. The select query runs...

Hi I have a form named ParamForm that has two unbound text boxes name SartDate and EndDate. I would like to have my query open this form and to be able to...

Hello, I wonder if anyone can help me, I have crosstab queries set up to show orders recevied and orders closed for two teams by each week of the current...

HI I need to create a calculated field in a query in an Access Proyect (.adp) but I dont know how, if somebody can help I would appreciate it. Thanks

I have trouble believing that I can't figure this out, but I'm stuck. How do I set up a condition in a query where I want all the records that have the same...

I accidently replaced my files on access, can you tell me how to restore them back. Thanks, Lynda

I'm running a query on a table and the records that are returned are often duplicated (returned more than one). This may be to general a question, but what...