Search results for query: *

I have created a database with all our SAP users on Ms access.In the Username field of my query, in the Criteria text box, i tried to put in about 10 users(using their username) one by one.And it works fine, but it's time consuming.I then pasted the 10 usernames all at once in the criteria...

I’m trying to import a spreadsheet from excel into access there’s customer number column that has numeric values and text values. But I have converted the entire column into text in Excel before importing it. It doesn’t seem to work cause not all data gets imported.Only the numbers get imported...

I’ve just found out that some information has been entered more than once in the Customer Name & Plant Filed .So Now what I want to do is to write a query that will give me only the Customer names & Plant that were entered more than once. And leave out the Names that were entered once.This is an...

When i run my query, i got negative values for sales column.So i would like to format the sales values, so that negatives values will be red.Is it possible???Here's my SQL: select effmonth, s/man, sales from salestable.

Is there a way I can read data directly from an access query to excel without having to import it to excel??? If yes . How???

I have a table that links salesman to 12 months of commission he made. when I run a query for 12 months of the year I realise that there are missing months for some salesmen. It’s simply because they didn’t make a commission in those missing months .And therefore those months in which they...

Hi All Seeing that it’s hard to create a Graph in Access. I would like to create my graph in Excel, and then link it to Access. But How can I do this when my query that my graph will based on contains more than 100 000 records. How do I start??? I've tried it .My Graph has to be synchronised...

Hi All, tHERE'S a piece of VB code to synchronise my form to the value in the Combo Box. The VB code is attached to the After Update event of the Combo Box. And sometimes when I select a value on my Combo Box, I get the ERROR message. I suspect there’s something wrong with my code. I can’t seem...

I got a query that gives me the following results: Month 2003 2004 2005 Aug 03 11,000 Aug 04 3,200 Aug 05 700 What formula can I use to change the query into 1 line of August so I can have...

I’ve been trying to create a chart based on the below information. So far what I’ve been getting is, my chart is not at all CLUSTERED .For instance on the X-axis the months Aug’04 & Aug ’05 are at the opposite ends of EACH OTHER. Basically I want them to be side by side. And the Colour...

Broker No Broker Name Month Premiuns 1028811162 ABDOL,VE,MR 01/08/2005 3000 1028811162 ABDOL,VE,MR 01/09/2005 16692 1028811162 ABDOL,VE,MR 01/10/2004 48 1068787405 ABDUL,P,MS 01/08/2005 56100 1068787405 ABDUL,P,MS 01/09/2005 41376 1068787405 ABDUL,P,MS 01/10/2005 19092 I have a table...

I have a form with a combo box on it. I’m trying to synchronise the form to the value in the combo box. Here’s my code attached to the Apply Filter Action of the Macro. [Broker Number] = [Forms]![frmBroker]![CboFind] [Broker number] is the name of the field in the underlying table and...

I got a table and a form with a SMOKING field, This field has to have three checkboxes, the yes for smoking, no for not smoking, unkown for smoking status unkown. The boleean(yes/no) data type in my table, seems to accomodate yes/no and now i don't know how to accomodate "unkown" because...

I got a drop-down list on my form that lists table: Health_Production, Life_Production and Health_Activations.When I select each table it's supposed to open up the table selected.But what it does is ,it keeps on opening the first table. I've assigned macros using (OpenTable )action for each...

I’m trying to rank the brokers for this month(June) and the previous month(May) and then I have to find out for how many times has the broker been a number 1, 2 ,3 or 4 up 10 in a year : Here’s how it should look like Broker Pos(June) Prev(May) HowManytimes in a YR Beverly 1...

I got the follwoing DSUM FUCNTIOn: DSUM("APIMvmnt","HealthProduction"," [broker]=1000012946 ") I wouldn't like to specify the broker number in the criteria part because it only returns the values associated with this broker (1000012946),This formula doesn't cater for other broker numbers i.e...

I've been using the following formula to calculate the Average, but i get an incorrect answer for each field.please tell me what could be wrong.This thing seems very easy to do on Excel.In some instances it returns an average of zero even when there's a value in any of these fields...