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...

i'm doing this on a query.is there no way i can do it on a query

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???

This whole thing works .I get the combination of all the Sales Man numbers and dates.But the problem is with the commissions.The commissions fields that had previuosly no value now get populated when i run the query.which gives me wrong amounts.For instance when I run a query.The monthly...

When I run a crosstab query based on the query created from TblMonths and Salestable with no join. It works but the problem is I get the same value for commission for every months S/Man/No Month Sales 21010 01/01/2005 $234 21010 02/01/2005...

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...

Nope it doesn't work.Instead I get the ff: Month 2003 2004 2005 Aug 11,000 Aug 3,200 Aug 700 What I want is this: Month 2003 2004 2005 Aug 11,000 3,200...

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...

KenReay, everything seems to work perectly.Now the problem is when i enter the value that is not in the list .I want an error message to display that the value entered isn't in the list.And on top of that whatever value that was entered( not in the list must be deleted( reset to null) here's a...

KenReay, there's something baffling me here.Why is it that the ApplyFilterAction on the macro couldn't work.I attached the macro to the After_update event of the ComboBox. Here's my macro to find a Record using the ApplyFilter Section: Action Action Arguments ApplFilter Where...

Thanks KenReay, you are an absolute satr .it worked.

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...

some have suggested that i can only manage to to get what i want if i my yes/no field is bit data type.what does that mean?? and how to do that??Since i would like to have these 3 checkboxes viz( yes/no/unkown)one of the checkboxes have to ticked depending on which one the user clicks on the...