Search results

My company's fiscal year begins on April 1st. I need to design a query that pulls data from the most recent 3 full fiscal years. For example, today the query would need to pull data from April 1, 2012 through March 31, 2015. A year from today, the query would need to pull data from April 1, 2013...

I need to develop a query to retrieve, for example the previous 1 year of performance data. The query is based on an oracle database table (which I don't have the permissions to change). The date field in the table is in date/time format. So in my query: "Date()" for some reason works ok...

I've developed a form that runs via a macro for a long running query that pops up a message: "Please Wait". The query involves parameters that the user must input. What I'd like to accomplish is to not have the pop-up message appear until after the user inputs the parameters. I think this...

OK, I have a query that pulls data from 2 tables. The first table (let’s call it Table A) has employee information (employee name, job title, ID#, etc.). The second table (Table B) has information on training courses that employees have taken. So my query pulls the latest employee information...

I'm trying to create a report for my organization that sums the amount of material used by date. For example, I have five separate locations in my organization that all consume the same material. It gets reported separately by location. I need to know the total material consumed each day. Then I...

I have a report with a list of employee names (and other information). A handful of them need to be a different color (other than default). There will always be more than 3, so I can't use the conditional formatting tool. I've seen elsewhere on this forum where someone developed a subform but...

Hello all. I need to design an unmatched query on 2 tables to identify employees names that exist in 1 table but not the other (or names are misspelled, etc.). The tables exist in on a server and I do not have the ability to change either. Table 1 has the following structure: EMPLOYEE NAME...

OK, I'm designing a form that will allow me to select one or more fields from a table, and then print a report depending on the value of the selected field(s) sorted by date. For example, say I have a table with the fields: Name | Cat | Dog | Age Cat and Dog are yes/no fields. So on my form...

Hello. I am developing a Make Table Query from 2 tables, one of which has an "Employee Name" field (lastname,firstname) and the other table has separate fields for LastName and FirstName. I've been able to accomplish almost what I need by: WHERE ((([Table 1].[EMPLOYEE NAME]) Like [Table...

OK, I have a rather large excel spreadsheet that I need to import into Access (2007). The spreadsheet has numerous “Yes/No” fields (users enter a “1” for Yes, and leave it blank for No). The majority of the fields (several hundred) are left blank (indicating No). The Yes/No fields will appear as...

I have a report that will contain roughly 30 SubReports. Each SubReport is made up of a piechart and a text control. I need to keep these together in each SubReport so I have placed each SubReport in a separate section (Header or Footer) using Sorting and Grouping. However there appears to be a...

Hello: I have a form with 4 pages that I created using Tab Control. Somewhere along the way I noticed that when I open the form in form view the page tabs are not visible. I have to scroll up slightly in order to be able to see them. I've literally been at this for days but have not been able to...

Here’s what I’m trying to accomplish: I have a customer survey. Let’s say for example (simplified, of course) that 3 customers respond to a survey as follows: Customer 1 Response: Good Customer 2 Response: Bad Customer 3 Response: Ugly These responses are entered onto a form which populates a...

I have an Access report with several pages that I have setup up using the Tab Control. When I try to Preview the report, all I can see is the first page, irregardless of which tabbed page that I have selected in Design View. I Googled the problem and found that this behavior is by desing in...

Hello: I need to create a pie chart on a report. The piechart has it's row source as a query that I have attached. The problem I'm having is that the query has the data in a column and the datasheet for the graph apparently needs to have the data in a row. I've tried a crosstab query but it puts...

Hello: Using Access 2003 I need to combine all the records from one field in a table to appear in one control on a report. For example if I have a table with 3 records, and a "Comments" field has the following data: good, bad, ugly on the report I need: Comments: good, bad, ugly In one text box...

Hello. I'm trying to use a Query to count customer responses to a survey. For example, Customers can answer: Yes, No, or Unsure to the survey. I would like the Query to count total # of responses, total # of "Yes" responses, total # of "No" responses, and total # or "Unsure". First of all, I...

I have several combo boxes on a form that have various tables as their row source. What I would like to be able to accomplish is that when a user selects a value from the combo box, it is no longer available for selection on the next record. For example, if my combo box list contains: Hats...

Hello: I have a table in an access database that was developed by another person several years ago. In this table there is a field named TRAVTIME. It is for staff to enter time they spent travelling to and form worksites. Unfortunately the original programmer set it as a text field. And also...

Not sure if this is the correct forum or not, but can some one help me out with vba code to import a table from another database? On a form, I would like to have a command button, that when clicked on, imports a table from another database. Just need some help with the code. thanks