Search results for query: *

what I want to do is compare the average monthly sales over the last 12 months with this months sales. The original table has the following fields: ID, StartDate, QBSales among others. The query where I am comparing data sorta looks like this: StartDate QBSales ThisMonth 1/1/1994 9,005.00...

oh boy, I hope I'm not repeating someone elses post. I have searched without luck. I am trying to pull a valuation of our stock on the first of each month and report this with the following 2 columns: Month/Year, stock (inventory) value (I want a total, not the value of inventory on each item)...

Originally I could use the chart wizard but now when I try I get the above error. I dont know what has changed but I even tried removing and reinstalling Office 2003 and still it continues. Any help would be appreciated.

In a query I would like to round up to nearest thousand if over 500, to nearest hundred if over 50 and leave any smaller values alone. Any thoughts?

I am an experienced Access developer new to .net. I have VS.net 2002 and I need to develop an ap that will allow a user with a plain jane computer to enter multiple name, email, zip in text boxes on a form which he can then upload or email. I have thought perhaps writing this to a csv file would...

I would like to add blank lines to the bottom of a repot for employees to make field notes. It is probably an easy fix but I am just not getting it. My problem is that if the sub reports are long the notes section continues onto a new page. I want to limit the report to one page and just fill in...

my original goal was to export 2 queries to an excel workbook with two worksheets when a user enters an incorrect password 3 times. that has been a problem so i would like to be able to export to 2 seperate workbooks then, from access, import the first workbook into the 2nd workbook as a...

i would like to be able to get it to look like a plain word document without the table frames visible. basically i want it to look like it prints. as is, it looks bad if its emailed as an attachment.

I have a new project that will involve pulling data from tables in SQL server. Any information that will make this process efficient would be appreciated.

i want to combine the "name" field from all records with the same "child id" into a string to insert into a text field. the fields are located in the same qry result "XQryTal". Any help would be greatly appreciated. i have checked knowledebase, help, and threads for...

i have a query that returns 2 columns. the first column has multiple instances of the child id, the second has related data. what i need to do is get a result that gives me one instance of the child id and combines the related data into one field seperated by a comma.

anyone have any ideas on converting "$132.00" to "One Hundred thirty two and 00 cents"

I'm looking for a payroll program for Access 2k. Any ideas?