field

Hi, I'm looking for some help in building a dynamic list from a range with multiple constraints without using the Excel standard filters (I'm trying to improve my hockey pool performance by drafting faster and more efficiently!). So basically, I have a list of 800+ players with different...

Hello Everybody! I have a table of data that includes a calculated column (Referrals) that uses an Index/Match array formula to pull in data from another table. I've made a pivot table from the first table and I want it to sum all referrals for all people in the selected Site. So the pivot...

Hi, Just want to have your opinion on how to resolve the issue, i have Text field to upload in my Table "Short Text", and i need to update the field SI_ICXX to remove spaces, however, i think it automatically converted to Numbers. Sample SI field(Short Text):12333 02 01 i need to update as...

I'm using this to set the focus to a field which is empty; For Each ctl In Me.Controls If TypeName(ctl) Like "Text*" Or TypeName(ctl) Like "Combo*" Then If ctl.Value = "" Then Call MsgBox("You have fields with mandatory data missing", vbCritical, "Missing data") ctl.SetFocus Exit Sub End If End...

I have a pivot table that draws it's information from an external cube. One of the fields in the pivot table contains an agency name and number. The agency number can be anything from 1 to 4 digits. It looks like this: INSURANCE AGENCY (1234) Is there a way to extract the number from the field...

I want to add a field on my form that will act as a "Title". Actually I have 6 fields. In the first one, if todays date is in the month of September I want it to say "September" in the field. I would even be OK with the Month and Year (But not the day). In the next box if today is 9/17/2019...

Hi, I'm using VBA to call an API (Untappd) and extract a number of datapoints. This is working fine for me for all the fields I want, other than one called "count". When I write what I need to get the data: Producer.response.brewery.rating.count VBA automatically renames it to...

I have a Query "qry_OnTimeDelivery_MetricData" in the query I have a column named Month01_Active. That field has either a 1, 0 or nothing in it for each record. Can I create a Form and have a field on it that sums that column (Month01_Active)? Thanks

Good afternoon, I am attempting to streamline a tracking sheet being utilized by several of our employees. There are about 100 worksheets in the workbook currently, each named after a unique unit number. This makes it a nightmare to navigate efficiently and I am attempting to use an Input...

Form called Input Allotments that shows the current funds of one state. Subform that shows all that states transactions: master_data_auto_fiscal_year_subform based on a Query. Query: Master_Data_auto_fiscal_year it has all the fields from the MasterData table The query takes the date entered and...

Hello, I have a very limited knowledge of Access and am struggling through and enjoying creating my first database. When in query design view, I created a field by entering the following formula into the field region: Lab$: [LabHours]*([CrewRate]+[OHRate]) So when I switch to datasheet view...

Hello, I am working in a mail merge document, and I need the output to look something like this: Vacation: Life Insurance: Disability: etc. However, the issue is that sometimes the fields are blank, and if they're blank it messes up the spacing. I want the document to ignore any blanks...

Hi, I'm usually an Excel person and not so much an Access person so please forgive my stupid question: I plan to build a database which in various forms rolling up into various tables I want to control selection choices a user can make. Some of these list might be 3 options long, some might be...

Hi Is there a formula where you can convert a text date field to a date field (mmm-yyy) I have the following formula but it is still a text field and when i do an IF statement its not treating the output as a text. =TEXT([@[Due Date]], "mmm") & "-" & TEXT([@[Due Date]], "yyyy")

Hi, Asked for help regarding below in a different thread but since it evolved to be very disconnected from the subject/title I am reposting it as a separate thread: Please see picture, https://imgur.com/28MVScU I want the formula to do the following: Divide the costs in col B with the number...

I am trying to use =trim(D2), but it is acting like I am not using a formula. It is just displaying =trim(D2) in the cell. The field I am looking at is an address field so they start with numbers, if that makes a difference. Thanks for any help.

Whenever I click outside of the pivot table the field list keeps disappearing. Is there a way to fix it there? You'd think this would be a simple google but I'm not finding it. Can anyone advise?

Looking for any kind of help that can help me solve this problem. I receive a pivot table once a month. One of the filters has the options of: yr17mth08,yr17mth09,yr17mth10,yr17mth11,yrmth12...

I have a WookBook with 2 sheets. It's being used for keeping track of some temp badges for our work place. Column A has the Temp Badge # and highlighted red or green if there is a name in column c. Column C is a Name field Column E is Date and auto genrated when a name is placed in Column C...

Hi, I have done a lot of searching everywhere and came up with a few different ways of doing this, but the final formula that started working for me needs help. Here is what I need: I can only export the data i need from a price field ie: 0.00 due to the limitations of the program I use. A...