I did a search... But couldn't really find what I was looking for. If this question (it seems like a simple one) is answered in some comprehensive FAQ please let me know so I don't waste thread space next time ;)
After creating the Pivot Table for my data, I want to count, in each row, (each column representing Item X) how many cells have a unique row data.
Column - Historical data on Item X w/ each column representing an Item X report
Row - Sum of repair time for Item X
I currently have a total at the end of the row for item X. However, all this tells me is the total time for ALL repair reports for Item X. Were those 10 hours of repair time for just one report of Item X? Or was it for 10 reports of Item X, each taking 1 hour's time?
I figured out that i pivottable in a form would fit my users need. But, though my users aren´t so brave computerusers I would like to give them a special pivot layout to start with. At this point, when I open the form, I have to design it from scratch everytime. I use Access 2002.
I have a table (Quarter) which acts as a source for another table. When I create a query based on the latter in the Datasheet view the entries of the second column of table Quarter are shown. The PivotTable field however displays the primary key.Where do I need to make the change to only have the second column entries (Q1, Q2, ...) shown in the PivotTable view as well?
I have a report due the first of each week in which I need the cases open and cases closed for the previous week, the week two weeks prior and the 2007 and 2006 year to date on two different types of cases. I have a case management table with a field for Type of Case, date assigned and date closed that I uses in my queries. Presently I have two query, one that generates only Type 1 cases from the Case Management Table and another for Type 2. I then use the Type 1 Query in another query that limits the results for Type 1 cases to those opened last week, one for those open two weeks ago, one for 2006 YTD and one for 2007 YTD. In these 4 queries I have one field [Type of Cases] and I have the query count. I then do this for Type 2 cases and then go through the whole process to do Closed Cases. All my queries have criteria to automatically filter the dates to the time periods mentioned above. I then have one report query that I put all the number in for my report. This query has 16 fields with the numbers for each period, last week open and closed, 2 weeks open and closed, etc. I then generated a report that takes these numbers from my report query and puts it in a report format automatically. As you can imagine this takes some time to go through each query to generate these numbers, so I was wondering how I may do this differently. Also, I have experienced a problem when a field produces no records I get a blank sceen with nothing under the Count of column and get the same thing for my report. How can I fix this.
I want to have code that disables fields based on the value of the contents of one of the fields. I wrote this code which goes on and on but it doesn't work. Can someone help?
Private Sub Form_Open(Cancel As Integer)
Dim Item_Number As String
If Me.Item_Number = "300123C" Then Me.Batch_Lot_Number.Enabled = False Me.Issue_Date.Enabled = False Me.Production_to_BPT.Enabled = True
I don't normally work in access so I am sure I am asking a really easy question.
I have a table that is connected to a form where users enter survey data. Currently they have a drop down form to mark the responses to the survey as "Fully Completed", "Partly Completed", etc.
On the table I want to add the text "Awaiting Completion" to all those without any entry so that we can find out how many are left to do.
I can filter the table to give me the correct records, and assumed I could paste the text directly into the column (as with Excel).
Can anyone please let me know how to update the column easily.
I have 2 Access databases setup, each containing 1 table. Let's call them A and B. These two tables contain some of the same fields.
Table A is used for collecting new client registration info through our website and gets updated by SQL.
Table B is on a different server and is used for company newsletter mailings.
Table A is the one which is automatically being updated so I don't need to do anything with that table. Also, some fields in Table A are auto-incrementing numbers so we can differentiate a clients interest and provide a more informative newsletter for them specifically on their selected interest.
Whenever an entry in certain fields of Table A is made, I would like the same fields of Table B to be updated with that same information automatically. For example...
Client subscribes to our newsletter on our site and selects their interests, the email field now contains the subscribers email address and the various 'interest' fields contain a '1' telling us they are interested in that particular area of our business. As this takes place on Table A, it needs to be also replicated to Table B.
The Salesledger has fields TransactionID and ProductID
The Salesledger is linked to the Products table by the ProductID field
The SalesLedger is linked to the Voucher Table by the TransactionID field
How do I produce a query to list all the items in the Salesledger but if there is a Product in the Products Table matching the ProductID the Product details, and if there is a TransactronID in the Voucher Table list the VoucherRef.
At the moment, it only shows transactions if there is a corrosponding TransactionID in the Vouchers Table
Probably not explaned this at all well. I will try to elborate if required.
I have a list in Xcel of approximately 1100 client #'s that I have to match to our master list of 10000's.
I can create a query to pull these Clients, but I'd like it to only pull the 1100 requested. Is there a way to import an excel file to bump up against a query so that it only pulls the requested clients?
IE do I have to create a table and bring that data in then use them both in the query?
Sorry if this is a simple question, I'm just being thrown into the fire and have very little access background.
To start: Running Office 20003. I have created a survey with Frontpages wizard. Basically It has a topic and the end user rates that topic on a scale of one to five like so:
1. Work Environment a. I enjoy my work place. 12345 b. I think my office has a good reputation. 12345
1-5 are radial buttons. It takes the users input and stores it in an access database as im sure you all are aware. Looks kinda like this:
1a 1b 2a etc. 3 5 1
What i would like to do is this: When the users are done submitting i would like to go back and take results. I.e. we had this many users select option 3 for question 1a and we had _ number of users select option 2 for 1a, etc. The thing is i was wondering if there was a way to create a query for it. I know i could just put =1 or =2 but that would require running 5 queries on each question.... not fun. Anyway, any help would be appreciated.
The Salesledger has fields TransactionID and ProductID
The Salesledger is linked to the Products table by the ProductID field
The SalesLedger is linked to the Voucher Table by the TransactionID field
How do I produce a query to list all the items in the Salesledger but if there is a Product in the Products Table matching the ProductID the Product details, and if there is a TransactronID in the Voucher Table list the VoucherRef.
At the moment, it only shows transactions if there is a corrosponding TransactionID in the Vouchers Table
Probably not explaned this at all well. I will try to elborate if required. Edit/Delete Message
Hi all. I need to know if there is a way to show the last entry for a record. In my database there is a set of numbers i.e. 3000, 3001, 3002 etc which have multiple valuation figures with them i.e. 3000 could have valuation 1 £1000, valutaion 2 £1245. So as mention what i need is my query to show the last valuation entry for the selected reference number i.e. 3000 and valuation2 only.
I dont know if my brain is not working today....but I have a query that is prompting for user input....if the user clicks cancel it shows "Action Failed" "Halt". How can I get this to just close when cancel is clicked?
I working with different business groups who have vendors assigned to them. I have table of vendor names for each business group. I'm getting data from different sources with vendor names that are unlike table. example: ABC company, ABC. Even through these are different they are they same vendor. Is there a formula, criteria, etc. to pick these up? I will be updating the vendor table occastionally.
I do not know what I have done but I am banging my head against the wall, I have three tables in this recruitment db im making and I have a problem that I know is so simple but is killing me off.
In one of the forms (add new vacancy) it has a drop down box that selects the name of the company from table called (company main) within the company main I have two columns (company) & (company no).
now back in the add new vacancy form I have a box that should collect the informtion of the company no whenever I select the company from the drop down list, but you guessed it, its not finding the information please help before i go mad.
I think I have an easy one. When entering records in my table I would like the date to be automaticaly entered. If I use the Date() function the date changes with the system date, I would like it to remain as the orgingal date. How do I do that?
I need to generate a query that pulls all the employees that ordered paper trays for their workstation. The quantity of paper trays they ordered is the data for the field "paper trays". Some people did not order any. How do I tell the query to pull all the employees that ordered and not to list the employees who have no data in the field?
Hey, I need to print a report on 11x17 paper. I cant seem to find in the page setup where I could change it to this. Is there a manual way to change it to 11x17. I've checked all the network printers around here under the page setup and none give me the option for 11x17, but I know you can print this size on our printers. Thanks.
I have completely forgotten how to create a form that will olny allow the user to add a new record into a table...and will not let them view or change any of the existing records.
Kind of like a sign up form. Where they enter their info, hit enter and it stores in an existing table as a new record.
I'm sure this is elementary, but I'm a dummy :confused:
I am creating this bloody db and I have created a form and when I open it, it shows, record no one, what I want it to do is open blank ready for a new bit of info to be put in. I know this is an easy one but im sick of the sight of access this week
I have two tables and one has Job Associated Name and the date we began the job, the other table has the job associated name, however it is repeated. I want to have the date show up on the other table so that I can have it appear on a report. The two tables are linked by job associated name.
