Showing The Number Of Records That Is Says In A Field
Apr 30, 2008
I am doing some ICT coursework and I a bit stuck.
I am creating a database that will allow users to log in and submit bids on houses. There are only a certain amount of house plots available, but I cannot seem to make the database find the top bidders within the plots available, for example the top 5 bidders or top 7 bidders, depending on how many plots available.
I have 4 fields, from two different tables. I have a bidder ID field, House Type ID field (which I use "[please enter house type ID"]), a bid amount field and Number of plots field.
I want the query to select the top "x" amount of bids that it says in the number of plots field, e.g. 5.
How can I do this for all the different house types?
I have an Access 2010 report that is pulled from a dedicated query. When i run the report, one of the fields pull the information in both the numerical ID number and the Field information. For example, the field in question is a field for "business type"......the report comes back in some lines as Manufacturer, Supplier, distributor, or contract. In other lines it comes back as either 1, 2, 3, 4...which is the ID number form the table. I have gone through all the properties and data source and can not figure out my the information is being returned so differently.
I am pretty new to MS access and have a question that I have not been able to figure out. I am making a database with a form to input the data in to the database. The only thing is I want to be able to search/lookup/record data by the products ID code and not by its record number. For example, product 1234 instead of entry number 1. How would I go about this? Thanks for your time!
I use an append query to insert this new record into the table EVENTS_MAIN.
I wish to set the start time and end time for all event days in hours and minutes. I will use these entries for displaying start time and end time for each event days, to calculate daily total hours and event total hours later on.
Therefore, I wish to create a query that will display event date 1, event date 2 and event date 3, based on the number of the EVENT_total_days field, so I can set the start time and end time for each day separately.
Is it possible to "convert" or "switch" the number of the days into number of records? Can a query convert a field value into number of records?
Is there a way for my inventory form to show what page that item is on a report? I tried directly adding a text box with control source directing to the report's "Page" [Page] of [Pages], but i guess that's not the way it works?
I am building a relatively small database, but it is made up of a number of different tables which are fed by other tables.
My three main tables are:
EmployeeDetails Occupational Risk Profile Health Surveillance Requirements
The employee details table has fields fed by small tables such as Department, Location, Business Unit, Occupational Group etc. These are all made up of an autonumber primary key column and a variable column as described above.
I have been going round in circles with a lot of this as I am still learning.
My problem is that on my forms these fields are showing as numbers and not the text values. For example, I have one form made up for each of the main tables above but I can't get them to display the relevant text.
I did a search on here and somebody said to create query to link the tables and bind this query to a form.
How do I set up the query just to return the text part and not the number? How do I bind this query to the form if I already have the record source on a my form as a table? (can you have more than one source in the record source?) Do I create one large query with all of these fields and use this as the basis for the form?
I have a table with a field that shows the number of pieces that a parcel contains. It looks like this: ParcelID, Pieces, Description
Data example: 1001, 5, Jackets 1002, 10, shoes etc
I need to print labels for each piece that shows to which parcel it belongs. The report will look like: 1001, Total pieces = 5, 1 of 5 pieces, Jackets 1001, Total pieces = 5, 2 of 5 pieces, Jackets 1001, Total pieces = 5, 3 of 5 pieces, Jackets 1001, Total pieces = 5, 4 of 5 pieces, Jackets 1001, Total pieces = 5, 5 of 5 pieces, Jackets
and 1002, Total pieces = 10, 1 of 10 pieces, shoes 1002, Total pieces = 10, 2 of 10 pieces, shoes 1002, Total pieces = 10, 3 of 10 pieces, shoes 1002, Total pieces = 10, 4 of 10 pieces, shoes 1002, Total pieces = 10, 5 of 10 pieces, shoes
If I could populate a table where the number of records equal the value of the pieces column then it's a pretty simple report but I can't figure this out.
I have a code that works great from the parent form but I decided to change the format and call it from a lostfocus event in the subform instead. Now I keep getting error 3314:"You must enter a value in the tbGuests.LastName field".
The code should copy the parent form fields and create x number of duplicate records according to a field on sub-form. It then runs an append query to add the information from the subform.
Code:
Private Sub GuestsInParty_LostFocus() Dim partymsg As Integer Dim dbs As dao.Database, rst As dao.Recordset Dim F As Form Dim intHowMany As Integer Dim intCounter As Integer
I have a form (frmHourEnter) with a combo box (cmbJob) and if the number entered into the combobox is not in the list then another form (frmJob) is opened and a new number is entered. On closing this form I run:
Code: Me.Form!frmHourEnter!cmbJob.Requery
The combo box (cmbJob) does not show the new number unless I close the form (frmHourEnter) and re-opened it. If I add the following code to the one above:
Code: DoCmd.Requery "Form!frmHourEnter!cmbJob"
Then click out of, and then back into cmbJob the number is in the list! What can I do so that the number is in the list when the second form is closed?
I have a people table; Ethnicity Table; Program Type Table; Attendance Table.
I enter the people into the people table then enter people into the attendance table with lookup for name from the people table and a lookup for program type from program type table and enter date attended. I then run a query on the attendance table to remove duplicates. I created a form from the attendance query there are 3 headers Program, Ethnicity, Name. but the program type comes up as the ID number and not the text name.
The Ethnicity did the same thing but when I added the Ethnicity from the people table to the ethnicity header it show up as the name and I hide the box with the number but when I add the program type from the program type table to the program header is changes the source of the report to the program type table and then nothing shows up. It did not do that when I added the ethnicity type from the ethnicity table to the ethnicity header.
I have a form that I built and is based on a relationship between four different tables. I can enter info into the form, save it, and verify that it saved to each of these tables. The problem is that once I close the form and re-open it, none of the previously entered info shows up. Bottom of the page shows 1 record, but I can still see all of the info when I open the tables. Please help.
Thanks for all your help on my previous problem but I now have another one that just seemed to start out of the blue. When I open my form the record selectors don't allow me to browse through all the previously entered records. This is a huge problem because if changes need to be made I can't call up the record to do so. I plan on adding a search funtion to the database soon but for now I need to be able to search through the records on my main form. Is there something I should look for or do you have any suggestions?
I have created forms to add data. What i do is click the add new record command button and add the details. But when i open the form again, it does not show the record which i have just added. However the record is present in the tables.
Hello. This is a very basic question. I have a query that has relationships set within. Now.. When I pull up the query with a criteria such as "date" ... the query pulls up all the information for only the items that have all the related fields filled in. How would i make this query show ALL the items from that "date" even if their related fields are blank or there are no relationships in another table?
Just setting up the query filters in MS Access 2007, by simply going into the design view for that particular query, setting the criteria, so really can't see how it isn't working? I put Like "*TOF*" in the criteria field and no records are returned for that, even though there's many records including that word in that field?
I've created a report and report has the same number of pages as the number of records that it's displaying.
If there are two records, the report has 4 pages...the first 2 are the actual report and then the other 2 are a copy. If there are 3 records, the report would have 3 copies (...6 pages).
Any idea how to change this so that I have only one copy of the report?
I have a table called welding, I want to create a user friendly form for input. The database ultimately wants to go on share point so I am building it in the web database option.
One of the fields is called location, if the location is 'Field' I want 10 more fields to appear for data entry such as weld reason, rail temperature etc . If the location is 'Depot' I want these fields to be hidden as they aren't relevant.how would I do this?
I am trying to run graph on a report from query but what's happening is query shows name but report on graph shows ID'S of the field .
Below is my query
SELECT tblMainTWTTPSheet.txtRootCause, Count(tblMainTWTTPSheet.txtRootCause) AS CountOftxtRootCause FROM tblMainTWTTPSheet GROUP BY tblMainTWTTPSheet.txtRootCause, tblMainTWTTPSheet.Date HAVING (((tblMainTWTTPSheet.txtRootCause) Is Not Null) AND ((Count(tblMainTWTTPSheet.txtRootCause)) Is Not Null) AND ((tblMainTWTTPSheet.Date) Between [Forms]![frmStratificationOfRootCauses]![startDate] And [Forms]![frmStratificationOfRootCauses]![endDate]));
My bound column on main menu form and back end table is 1
Ok this null value thing is killing me. I have a parameter query that works great. I know if I use Is Null in the criteria field it will show me this. The problem is I made a search form which the users type the value in and it opens a form based on the parameter query, the parameter on the query is [Forms]![Search_frm]![txtClosed]. If they type a date in here it opens the form and shows the user all the closed records. The problem is they want to see all the records that have no value or Null. I've tried eveything to make this work. I'm ready to jump!! Just kidding. Is there a way to do this with out creating another query. Thanks a bunch!!!
Hi, I hope someone can help me. I have a database as thus:
Several tables ->appended together using 'union select' into a query called 'sheet1'-> information that is coded converted via linked tables in a query called 'sheet2'
'Sheet 2' looks completely fine - it works dandy but when I try and run a pivot table not all of the values in one column that should show don't even come up as an option.
The values that are missing on the pivot report do actually exist in the query that it is running from.
There are no filters on and Pivot tables work okay on the origional tables.
Hi All I have a feeling that this is an absolute newbie question. I have three queries, qryVisitsDue, qryVisitsOverDue, qrySiteView. The query qrySiteView uses SiteID to produce a listing of all sites which includes a count of visits for those sites. If there is no visit data the site does not display. To display the counts I'm using the other two queries. In the first two I'm querying a table, tblVisits, to find what visits are due or overdue based on the current date. They work fine where there is visit data. My problems start when there is no data for a site. I need to be able to show the sites where there is no visit data. I'm not very experienced so basic explanations are probably the best. Any help much appreciated. ChrisD
