Recent content by Artemis

SELECT dbo_tbContacts.[Company Name], dbo_tbContacts.[Contact Source] FROM dbo_tbContacts WHERE (((dbo_tbContacts.[Company Name])=[Enter Company]));

I have a SQL database which I am trying to run some simple queries on in MS Access. The first field contains Compamy Names: Activ Technology Services Limited Active Network Solutions Ltd Group Active Technology Systems Acute Sales Limited Wave-form Solutions Limited Addwell...

I have a series of queries and reports in Access 2007 that I would like to put on a dashboard for easy access and to make my database more antithetically pleasing. Is this possible? If so do I have to create macro's to run the queries and reports and then enter them on the dashboard. Any...

I am trying to create a query that will select a piece of text that always appears after another piece text eg: Request for manufacturers RMA Number sent to Zebra. RMA No: 318937 The words RMA No: are standard in every record. I want to display the following 12 characters the follow after...

RESOLVED THANK YOU TO - Speaker86 & HiTechCoach:o

Speakers86 Many thanks for the information however, when I change the fields property from Embedded Yes to No this grays the data out and therefore I can no longer edit it. If I was to delete the data and just close the form with out saving would this not delete anything from the SQL database...

I have made an ODBC link to a SQL database on our companies server so that I can interrorgate the table for information. This is working well and I can produce a form showing the data I want. My question is if I delete any text from a field on the form it deletes the information on the server...

A long sting. Example: Acceca MEZ 1000 Handheld with USB cable and 128MB Compact flash. I have managed to run a simple query which gives me 62 results. I would to show this in a report just showing: Aceeca 62 I hope this is clear Thanks for your help

I am trying to add the column 'CountOfDuplicates' to show a total in in a query or report. Example: Acceca 50 I need the report only to show the manufacurers name and the total for that manufacurer. I have tried to do this in a report however it shows me every line. Can somone...

OK, I have now got to the stage where the duplicates query shows the attached: I would now like to add up the different totals on the right so they show a single total for all Aceeca's irrespective of what follows the word. Grateful if the explaination could be as simple as posible Thank...

OK I can now run a duplicate query which will give me the Number if each instance of the word 'Aceeca' however, the word can be in upper case, lower case or be followed by other text. Is there a way of totalling the results? Many thanks

I am running a query where the result shows multiple instances of a word ('Aceeca') and I can see from the Record navigation bar that there are 62 instatances of the word. My question is, How can I show within the query or even a report how many times that word appears?:confused: Grateful for...

I have crated a small database which produces a query (see attached excel file) I want to be able to add up all the 1's at the end of the column. I'm sure there must be and expression to fit the bill however I have know idea where to start. I am also trying to find either in Access or on the...