Hi, Instead of having to go into design view and type specific queries, is there a way to create a friendly user interface, such as on a Switchboard, to...

I have a database and would like to make a search function on my form by our client's last name. The form is based on a join query. The name of the client...

I have a rather complex series of calculations I have to do on a field in a query for a silent auction. For instance: To calc the new field StartBid: If is 0...

I have a StartDate of type String. I need to query for all StartDates within the last week. Furthermore, I need to present those which are on Mondays (later...

Hello everybody, I am new to this forum and hope you will be able to help me. I am using Access 2000 and have a problem with a query. This one is composed of...

Hi everyone, Can anyone help me? I have a query that is giving me a problem and I cant figure out why. I am using the same DateDiff format three times in the...

Hi! Anybody help for the following: I am working on computerising Guest House Booking procedure. In a particular month there is one one person booked from say...

Dave wrote: I need to GROUP BY a date and also SORT BY the date. But the sort order in Access treats the date as a string rather than a date. For...

Hi, I jave just migrate to SQL Back end. My front end connect tp sever thru ODBC. Everything seems to work quite except that executing Store procedure from...

I have a table of data with lots of rows. One of my columns has a group of rows associated with one account number, then another group of rows will be below...

Back once again... Here is the following problem. In a query I want to calculate a moving annual total in which the total should be the sum of the previous 12...

I have the following query: --- SELECT .StaffNo, .StaffName, .DutyTime, .E_UniqueName, .E_UniqueName FROM qry03_DayRoster LEFT JOIN...

Hi Guys, I have two problems with the task that is killing me. 1. How do I ensure that a union query displays its result in the order that it was built? I...

http://www.goodugle.com

Hi Guys, I have two problems with the task that is killing me. 1. How do I ensure that a union query displays its result in the order that it was built? I...

The running sum function in reports is exactly what i need. But I cannot find the fuction in queries or forms I have a table with 3 field call term. Link id...

Access tables store data but not formulas. This would need to be processed in a set of queries. "Bronson" wrote: hi asked this question before then had to...

How can I make a "text box" have a default value that comes from a "query"

I have a query using 3 queries? In POS not in Store Query In POS not in TechDesk Query In POS not in Outside Sales Query I need to have a datasheet or report...

I created a query that combined the "Mr & Mrs" or other title with the first name field in order to be able to print titles where appropriate and still be okay...