Search results

I have the following data (sample) in a query. The PID and CID columns are ID numbers used to connect the info to other queries/tables. PName--PID-----CName---CID Joe------567 ------Jane-----241 Jim------888------Jill--------765 LLC------234------Jeff-------231 LLC------234------Bob------467...

I figured out the code I need to export several queries from Access to an Excel workbook with multiple worksheets, one per query. I can create the workbook if I open the code and click 'run'. I want to create a form with a button that when clicked, runs a macro that runs the module to create...

I have created a report in Access that returns the same information as a pivot table I designed in Excel. In Excel, when you click on a count of an item, it opens a new worksheet that lists all the records that were counted. What is the best way to replicate that in Access, so if they click on...

I have a query that generates a list of tasks that have a due and completed date. Name Task Due Date Completed Date Joe Task1 10/1/16 10/30/16 Joe Task1 10/1/17 1/1/18 Joe Task1 10/1/18 2/1/19 Joe Task2 10/1/16 1/1/18 The date range for the data is three fiscal years. I want to end up with a...

I have added this to a query Category: iIF([Number of total miles for this week]<=15,"turtle", iIF(Eval([Number of total miles for this week] Between 15 And 36),"fox", iIF([Number of total miles for this week]>=36,"lion", " "))) It functions as expected in Access. However, when I try to...

I have two combo boxes on a form. I was trying to follow http://www.fontstuff.com/access/acctut10.htm Example 2 for single source table. My source table is qryAdminCoFarms with columns [Admin County] and [Farm Number]. However, instead of the second combo list populating, I get a parameter...

Is there a way to print the date/time information from a linked to file on a report? Example: The linked file was updated yesterday, and has a Windows Explorer date/time of 03/17/19 12:01 PM. I'd like that info to print on my report so they now how current the data is on the report, rather...

I have created and recreated a report because it breaks after I close the database. "...can't open the form..." "It contains data that MS Access doesn't recognize. Re-create the form or, if you maintain backup copies of your database, retrieve a copy of the form." I am displaying data...

I have two tables that have 4 columns in common. One of the columns can be blank for some entries. My query will not return these as matches. Example Table 1 and Table two have columns that include the following matching information for a given Item Location Name Type Purpose For some...

I am teaching myself Access, with the help of some colleagues who have been doing the same for longer! We are trying to create tools for our non-tech saavy colleagues to use to analyze data for workload management. We are dealing with a lot of data sources that are related in the real world but...