I've ready all of the postings about separating alpha-numeric, pulling apart numbers but none of the posts deal with decimals. How would I get a query to...

Hi, Maybe i am going about this all wrong... I have a CSV file that has 167 records in it. In each record there is a company name, a contact name and...

I need to accomplish the following. I need to count the number of loans by Lender that fall under three categories: FlatCancel, PartialCancel & Inforce. Here...

I'm trying to show the quarter of a date field but our fiscal year begins in July instead of January. Is there anyway I can make July-Sep 1st quarter,...

Hi, working with 2 tables (originally from Excel). One table has 90 rows, the other 25. Both have last name as a field. I created a query to match the...

Hi All, I have 5 queries which I have to "join" together into one full record source. All the data is already calculated, but I want to be able to view it...

Hi I was wondering if anyone could help me. I have a query that finds the last entry of a certain field. Is there a way for me to create a query that...

I am trying to create a query that will count the number of records per RMA Number at a location, I just cannot get it to show the when the location...

Hi...I have a program designed where we can input a specific vendor number, and the query will pull up all the data related to that vendor. I would like to...

I recently moved a user to a new computer, (windows xp w/ office 2003) i copied over existing access files and set up an ODBC sonnection. I can create new...

I am trying to add the contents of a field from one database to another one with the same field name. I want the contents to go into the fields with the...

Hi john, thanks for help. You are great, Your option working wonderfully. Now I small problem to compare result of top 20 with different last sr's and...

Hi: I have this formula: Q2$0: nz((nz()+nz()+nz())/IIf((++)=0,(++),(++))-1) But I still get the #Error when both, the dividend and divisor are zero; can...

I have a feild in my table that contains a bulleted list of items in html format. However, I need to split the bullet points into 5 seperate fields and have...

Hi, I would like to, eventually, create one master list using several tables, the problem i have is that there is multiple entries for some of the...

I have an append query that adds data to a table. One of the fields that is appended may be blank, in the original table. What I want to do, is if the...

Hello, is there a way, to use a table-valued function stored in an SQL Server database, to get the results into a MS Access database? It should also be...

I occasionally have a situation when typing criteria that I never saw in pre-2007 versions of Access. I type in a wildcard criteria such as 3*. Normally...

Salve a tutto il news, ho delle difficolta nel calcolo dei giorni.... mi spiego, ho una tabella nella quale ci sono campi "data" e "nominativo". Nella stessa...

Microsoft recently did its best to promote its Software Plus Services strategy at its S+S: The software giant’s chief executive officer, Steve Ballmer,...