I have a report (report1) which is based on a single query (query1).
There is a second query (query2) which returns just a single value (say 100) and I want the result of the query2 to appear at the bottom of the report1. The query2 is not related to the query1 so I cannot join them.
When I insert a text box in the report1 and choose the query2 from the control source Access gives the error, "The Microsoft Access database engine does not recognize '' as a valid field name or expression".
I want to add a number to my results within a query depending on the month and how many results. For example I have 10 results in my query 3 from January, 5 from March and the rest from April. The 3 from January would be 1,2,3. The five in March would be 1,2,3,4,5 and so on. Is it possible to do?
I want to present some data in what seems to me like it would be a very natural and normal format, however have so far been unable to figure out how to do it.I record attendance data for a children's after school club in a table as follows (simplified):
AttendanceID - autonumber AttendeeName - text AttendanceDate - date Attended - True / False
The data looks like this in the table. I would like to be able to easily see who attended on which days, so I would like to therefore see the data laid out like this:
The Crosstab query looks almost like it would do what I wanted, however it seems to insist on adding something up, rather than just showing me the value true or false.
I have a query with various entries, pertaining to various invoices. Each line of the query corresponds to a piece of work done, and there may be several lines in the query pertaining to one invoice. I've written the code to input data to a report.
If there are multiple lines in the query to be added to the one invoice, I don't know how to write code that will add those multiple lines in the detail section. Same type of data on each line, just basically pertains to several different lines of work.
i want to open a report but only showing the result of one record in a sub form,
i have a field that is on all rows of the subform,[click to run] and what i want the user to be able to do is double click on this field and it will open the report with only the record information for that row displayed.
Im trying to add a barcode to a report which I can scan with a barcode scanner. I have downloaded A code39 TrueType font and created a textbox and have put the following in the Data, Control source
Code: ="*" & [Barcode] & "*"
but when I print out the report its only converting the field barcode to a code 39 barcode and leaving "*" at either side of it. I know its not the font as if I open note pad, select the font and enter *1234* all is converted to a scanable barcode.
When I send a customer a work order, I want the final page to be a list of conditions of the current sale. In Word, it is nearly a full page of 7pt font with bold and italic. What is the best way to add this to the end of my report in Access?
I am trying to add text to a report. I am using Access 2007.My report is tied to a query. The query contains 2 fields-Hostname and MAC Address
I want run a report against the query, but need to add several commas. So the output of the report would look like this: hostname,MAC Address.
I then want to export the report to a plain CSV file.I thought I could just add a textbox with a comma in the report, but that didn't work well. When I added the text box, Access also created a column header that I did not need.I've also noticed that when exporting a report to CSV format, there are several characters (pipes and such), that work with the formatting of the report. Is there any way to remove this formatting?
I have small database in ms access which i am using for invoice creation. When invoice is created i save it as PDF. I would like merge another single Page PDF along with the report as 2nd page so end report is 2 page PDF.
Second how can i get 1 PDF from 2 ms access reports.
I have a popup form that prompts for a value and has a button defined with an OnClick,OpenReport with a WHERE clause. The value the user enters is placed in the WHERE clause.
The report is generated using a Query and the WHERE clause. I was very surprised -- it works!
Now I'd like to add a chart to the report that represents the information on the report. How can I do this without calling the query again? Can I somehow reference the information that's in the report?
I'm currently creating a student database where the user where be prompted to enter a students name and then a report is generated with the information retrieved. Everything works as it should but i would like to add a message box that comes up if the data entered by the user is not found in the database. Something like 'No student found, please retry'
I am relatively new to Access. I am having difficulty summing up totals and bringing them into the main report. To be more specific I have two sup reports called WOExpenseTotalSubreport and WOServiceTotalsubreport. These two subreports are based off of queries that gather the description, price and qty of either services or expenses and then produces a "total" for me on the query.
When I bring these two queries into a report as sub reports I am able to Sum the "total" field in the subreport footer which works fine. What I would like to do is add those two totals together for a grand total on the main report. The two summed fields are called ExpensesSum and ServicesSum. It seems most things I have tried do not produce an expression error but the result is either #error or #name? Here are a few different scenarios I have tried both on the main report details section as well as the footer section.
I am using Access 2010 (self taught and continuing to learn each time I get asked for a new report). I have created a query based on the data being selected from two combo boxes on a form, ie start date and end date. The report works as it should but I want to be able to automatically use the dates in the report heading. For instance, Summary Report from xxxxx to xxxxx, where xxxxx is the start and end dates that the user entered into the two combo boxes.
The date field on my query reads Between [forms]![F - CboReportDates]![Start Date] And [forms]![F - CboReportDates]![EndDate]
I'm trying to add the information from a form and subforms to a report. This would be a medication mar sheet and needs to be in the format of the attached word document. I'm happy to do it in a report and change the formatting if that will work better. The personal info needs to go at the top and the medication needs to be listed on each sheet.
The form is called FrmMarSheet. It basically needs the info from that like the "sample mar sheet.doc". I can only get one medication per page to work at the moment.
I added a "print preview" button to a report that does just that, shows the print preview. The issue I'm having is that I can't do anything in Access after I click that button. Everything in Access seems to stop working, I can't click on anything with my mouse. the only thing that does anything is that i can move the report up and down with the up/down/left/right keys. If I click on a different application that isn't Access (i.e. excel, spotify, email, etc.) and then go back to it, everything works fine.
I have two collums, currentowed and currentpaid. i want to add another field to my report showing the percent of currentpaid to currentowed but I can't seem to be able to make it work. I tried:
=sum([currentpaid]/[currentowed]) and it doesn't work.
I have a query which works perfectly fine, it's the report that I'm having issues with displaying correctly.
My report is a daily personnel accountability report that shows where everyone is for the day. Instead of having a cumbersome query like I did before, I have opted to just use the results of the selected drop-down option to move the X to the appropriate box of where so-and-so is for the day.
Using
Code: If [marked_as] = 1 Then Me.Morning.Value = "X" ElseIf [marked_as] = 2 Then Me.Afternoon.Value = "X" ElseIf [marked_as] = 3 Then Me.Evenings.Value = "X" End If
I was unable to get it to work accurately outside of showing the three dummy names under the same column, even though the three dummy names were each placed in one of the three test categories.
I have this set as a private function called when the report loads, which is based on a query that filters down to the exact department or office (depending on the user's selection). Like I said, that part works fine, it's getting the code to accurately display in the correct column.
I am working with Access 2010, on vista. What I have is a query made up of two tables, one product the other inventory. (see below) query.jpg
In the product table i have a field called "minimum reorder level". In the inventory table i have two fields one called "number in stock" and "number on order". What i want to happen is "number on order" to be filtered by the result, if the "number in stock", is less than "minimum reorder level", if it is, have the result placed in the "number on order" field. EG. if the "number in stock" = 2 and the "minimum reorder level" = 5 then 3 would be placed in the field "number on order" and only the second record from the query would be visible (see below) Query result.jpg The result of this would mean that the field "number on order" would be populated with the result and the and query would also use this to filter the record.
I have a report...with one number at the end of a line, beneath is a sum() of all the numbers above.
To test this report, I have ensured there is just one line to 'sum' ....this particular number happens to be $15.82, yet the field showing the sum of this is displaying $15.83 ...I'm going potty here trying to work out where the extra 1 is being added...it's not a rounding error as there are no further decimals involved, both fields are set to 'fixed' 2 decimal places.
I am trying to add hours entered in a short time format. For example 08:15 or 02:55. I also would like it to give a total number of hours beyond 23:00. Here is a table with a Name Column and Hours Column
A) write a query to add up the hours. I believe Heather would total 25:31 Hours.
B) Show this same total in a report? In my report I had a Name Footer which showed "=Sum([hours])". Will this work once the query is right or will I use the "=Sum([totaltime])"?
Also, is it possible for you to respond in a SQL statement so that I can copy? Thanks.