Hi All, I need to run any keyword search on the 3 tables, each table has one specific field containing the information. For example, I type in "test" in...

Is there an easy process to convert decimal to 1/4 of an hour. I'm trying to do this, 46.10 - 46.25 46.37 - 46.50 46.67 - 46.75 46.98 - 47.00

I've got a table with the following column headers well, year, Jan, feb, mar, apr, may, jun, jul, aug, sept, oct, nov, dec. I want to make a query so the...

Hi I use Visual C++ MFC 4.2. I need to get the last support_code from the table so I make query like this: CString sSQL; sSQL.Format( "SELECT MAX(...

Hello, This is my first post, so if my question sounds all jacked up, please let me know. Background: Multiple Buildings with varying amount of Rooms and...

Thank you all for looking. I have been struggling trying to put together a query that would keep track of innactivity between "requests." Here is the...

How can I parse the last name (Jones) from a string that might be Mr. and Mrs. Bill Jones or Mr. Bill Jones or Bill Jones? -- Dave

Hi Using ACCESS 2000 I have a tbl.contacts with all the obvious contact details for my 'constituents'. When my user is creating a new record, I want a...

Good Morning, I am trying to update an existing report based on an existing query. The additional field includes data (made of scores) that are both numbers...

I have done this before and forgot how to do this. In my query, when the field says yes, I want it to display in red text. What is the formula to do this? ...

I'm trying to build a query that will allow me to search a list of data to see if any of the searches in a table are similar to information contained in a...

What would cause my dim statements to show lower case dao rather than upper case DAO? I checked my references and intellisense puts the "QueryDef"...

I am using this Dlookup statement: DLookUp("CUSTOMER_TYPE","PUBLIC_CUSTOMER_ACCT","CUSTOMER_ACCT_ID = " & ) to lookup the from the companies Oracle Database. ...

I have joined data in a query from one table e.g. & "" &. When I add the criteria 'Like "*" & it does not work properly. Has anyone tried this? any...

I'm in charge of putting together Ad Hoc reports for my department. What I want to do is create a form where any user can choose certain criteria from drop...

I have written a query in access that uses a drop down in a form to allow that user to alter the parameters of the query. What I would like to do is within...

Is there a way to enter a Parameter entry in a query that if you enter NO data it will show ALL data. For example, is left blank and it will show all...

When I open a querie from inside a form, I can not see the list of items, I know the items are there, because I click inside this area and it shows on my...

I have WindowsXPpro & have just downloaded SP3. I have Access2003 Can anyone help me with solution to this. Frank

Having a problem counting with queries. I'm pulling data in several different queries. When I go to put the data in a report (using the souce record query...