Search results

I have a report based on a crosstab query that I thought would be easy to do. It basically shows the information in the query and then puts a grand total at the bottom. Piece of cake until it asks for a percentage to be calculated off a portion of the detail. Example of Data on Report...

Just a quick question I have an Access database that when a button is clicked it will open an Excel spreadsheet for entry. When the entry is done it will call an Access function which will run some calculations and update a specific table stored in Access, then it will close the excel...

Just when I though I was done.....I have been instructed to Web Enable the database I am using to a sharepoint server. Looked easy enough. I ordered some server space and ran the compatability check. Had a few issues which are easy to resolve, but one I don't think I should have to and was...

I just want to tell the guys that helped me out thank you. You were very patient with my brain dead questions. The database is being distributed next week and works very well. I am to a point now where I am not putting in so many hours at work and have some free time.... umm... at least for a...

Ok... I am lost. I know how to create a querydef, but I have never passed a string of variables to select multiple records before. I tried creating an array, but even though the array populated, the querydef would not recognize it. I tried creating a string, but it recognizes it as a field and...

I have a report which has several subreports that make it up. When I am in the report view I can see all the subreports, but when I go to print preview, export the file to adobe or actually print the report, one of the subreports completely disappears. Because its in between two other...

I am building a button to export reports to an excel spreadsheet. I know how to use the OutputTo with variables to save a file to a specific place. Example: DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, stDocPath, False But they want the ability to specify the directory location...

This is the select statement from a (what I thought was simple) query. I have a table tblLogistics that I want to see all records from. I know that some of the lines will be blank from the other table because they don't all have the data I am looking for. I thought if I joined with a left join...

I need to have multiple subtotals for a group. I know I can add group subtotals, but that will break up the materials into different sections. What I am looking for is both the subtotals together leaving the material together. A short example of what I mean is this. Type Material Cost...

I understood that if you had a report which you wanted to insert into another report, that you could create a subreport and select none as the matching fields because I wanted the report "as is". But what is happening is, it is adding the sub report to the main report multiple times instead of...

In reading through some of the older posts on the different uses of DSum I am wondering if it is something like this that I should be using. My problem is though, its not letting me use the Dsum with an if statement. This is an example of what I have Code Desc Period Year amt 123...

I am hoping someone can give me direction on how to fix this. I am creating an Access 2007 database. Every now and then I have to save the database to version 2003 in order for other people to use it. Today, when I went to do the File, Save As to select the older version, the option wasn't...

I have two tables I am trying to join and most of the records have null values in the field I am using to join. I am getting an error: Reserved Error(-5500);there is no message for this error. Here is the SQL for the query TRANSFORM Sum(tblCSLData.QTYOrdered) AS SumOfQTYOrdered SELECT...

Is there an easy way to add a shape to an Access report without inserting an image?

Saw this area and thought I would take a sec to introduce myself. My career background is in accounting, but I do have an AS Degree in computer programming because I found I have a natural skill in designing programs. Currently I am developing an Access database which will gather data from...

I have a table that contains SCode FYear FMonth Qty Cost I need to create a report which will calculate the Year to date information and the Prior year Year to date information and show it along with the current month and the prior year for the current month. I created individual queries...