Search results

I can't access the SQL in web based queries. Attached is the database. I'm not using SharePoint lists but rather converted the existing tables to web based tables and have referenced them the same way minus the fact that you can't have more than one join between two of the same tables as you...

To whom can help me. I am converting my database to a web database for sharepoint use. Besides the fact that you can't do all kinds of things with web queries my particular issue is my query is returning more results than it should. There is no distinct value option, you can't create and use...

To any who can help me. I have been converting my database to a web version for sharepoint use. Besides all the issues you get when trying to do this my particular issue is I have some code in my report. Code:Private Sub Report_Load() Dim dbs As Database, rst As Recordset Set dbs =...

Which other all 3 new queries required??? In the database you sent back to me it had 3 new queries, query 1, query 2, and query 3 but you only refernce query 1 in the code for the text box. Here I can't give you a clear yes/no, the databases I work with on the Internet is based on ASP...

Perfect it is working. Thank you. And thanks for not looking at my database and saying what the heck is he doing. lol. Questions: I understand you can't count the number of times a control appears in a report or form but how or can you just count the value within that control? (i.e...

Gotcha, so open the Form "Report Generator". Using the "States" drop down select "TX" leave everything else blank. Click the button "Design Ans. Query". After the query runs a table and a report will open. The report that opens is "Design Report". In the blue header you will see totals...

So I compacted and repaired the database and it brought it from 1.8GB to 6MB then zipped it and now it is at ~500kB. I checked and it seems to be working fine but it is confusing me that it dropped so much maybe another convo on why that is. So if it will open up it should open at a form...

I am working on zipping it. I don't know what to strip that will allow it to still function properly. I checked the names and they seem to be good. I don't know if this matters but the situation I described is a text box in the Report header referencing a text box in another header of the same...

I have a report and within the report I have added some text boxes with some simple logic such as sum, count, etc. These text boxes function well as long as the logic is referencing exisiting fields. The minute I try to have a text box reference another text box I get the "Enter Parameter...

I want the count of unique values in a specific column of the query results. (i.e. Column A going down has cow, cat, cat, cat, dog, dog, fish, fish, fish, fish) Summing in the footer returns a value of 10 when I want the count of the unique values which would be 4)

My query is set up such that the footer won't work as it sums all the rows instead of the distinct values in the particular column. I had to right a function to make it work. As I am a novice in Access I am pretty sure why mine isn't working the way folks are suggesting is due to the way I...

I want the sum of the unique values in each column of the query results. Each row in the query is unique but each column may contain the same data over and over again which is causing my summation to be more than it needs to be. If I could count unique values in each column of the query...

PS summing in the footer still provides incorrect data. When the query runs the field I want to sum is associated with each line item thus the sum is each line item when I am looking for the sum of the unique line items. i.e. WRNumber is assoicated with many different points and each point has...

Some of the reports are long so I was hoping to keep it in the header.

I have a form that users can input data into and based on that data it runs a query and generates a report. These reports can be different based on user entered data on the form. My issue is within the report I would like to sum certain fields. The problem with trying to sum theses fields is...

Hello All. I should be on here quite a bit asking questions. I appreciate any and all responses.:)