Search results for query: *

Hi I am creating query where by I want to pull out all customers who have option 1 and option 2 products. How do I achieve this? Any help is greatly appreciated. I have tried doing "option 1" And "option 2" but it returns no records when I know there are examples of what I am trying to find...

I have created a query which works fine but when I create a crosstab query using this query I get an error details below, any help would be great. The error is due to the fact I have built the query to pick the data of an employee depending on which employee is chosen on a button in a form (this...

Hi, I am trying to create a query which has an expression as one of the fields. The expression uses 3 other fields but I don't want to see all the other fields in the data returned as I want a summary. When I change the total to 'where' to the field 'Sales Stage' in the data returned I get...

Hi, I need to create an expression in an MS Access query to return values depending on the data in other fields, easy to achieve with IF statements in XL but new ball game in Access... I need to achieve the following expression in a query: If field 'Stage' has the word "Won" in part of it...

Hi, I have an expression: Actual Annual Renewal Value $: Sum(([Amount Lcl]))*12*1.868 I want to replace 1.868 with a reference to a table record. It will always reference the same field and same table record. Lets say the table is called ex_rate and it is record 1. Can anyone help pls...

Hi there, I have a table saved which holds a customer's name and the account manager associated. In my form I want to pick a customer in one field and have the account manager field auto populated. I have no idea how to do this, can anyone help? Pete

Hi, I have a select query which is created from a crosstab query. I want to add a parameter to the query but the usual [Enter xyz...] method in the criteria row of the query doesn't work, returning the following error msg: The Microsoft Jet database engine does not recognise '[Enter XYZ]' as a...

Hi, I have a number of calculated fields in my query. How do I format the text to go red if is above or below a certain threshold say below 0 or above 100. I think I may have to add some code but have no idea where to start. Can any one help?

Hi, I have created a cross tab query based on another query with the relevant fields which returns customers down the first column, months as column headings and sum of $ as the values. I need to add a calculation field which works out month B less month A (variance) and does this for all...

Hi, I am trying to write a query which returns the data in such a way that it shows my customers down the column and months across the top so that I can compare how much a customer spends month on month. I need it to do this for all the months in my database, and including when new months are...

Hi, I need to record who logs in and when to my db and have been told to run an autoexec macro to record a log file. Bearing in mind I know nothing about macros or programming can anyone help? Regards, Pete.

Hi, I need to record a security log which will tells me who logs onto my database, when and what they do in it. Is this possible, if so how? Any help is greatly appreciated. Regards, Pete.

I have set up a couple of different user accounts with varying levels of security to my db. So the login box appears on startup and works fine when I open the db from my pc, but if i save it to the network drive the login box does not appear and anyone can access. I believe this is related to...

Hi, After being advised, I have added: Date Range: [Enter Start Date (Jan 2004 = 200401)] & " And " & [Enter End date (March 2004 = 200403)] to my query so that I can add the chosen parameter to a report. This works fine for a table style report but not for a graph. How do I add the chosen...

Hi, I have set a few reports up on my database from queries which have parameters. Does anyone know how to add the parameter value to the report so that when the report is run it can be seen on the report which parameters were chosen and therefore what parameters the report represents... Any...

Hi, I have a query which includes the field Report type. When the query is run I want to make a combo box / similar appear so that one of three criteria has to be picked from this field before running the query. Is this possible? Regards, Pete.

Hi, I have a query which includes the field Report type. When the query is run I want to make a combo box / similar appear so that one of three criteria has to be picked from this field before running the query. Is this possible? Regards, Pete.

Hi, I have an access db where I need to indentify the top ten largest customers together with the value of goods bought over a given period of time. I have created the query using the design view but have hit a brick wall in achieving the result. Because month is the field used in the query...

Hi all, I have created an expression in an access query which tells me a % discount, calculated from the list price and and net price: Expr1: ([List]-[Net])/[List]*100 . The problem is this lists customers many times so I just want to see the customer once and a total price (net and list)...