I am trying to get this working i have a pivot that is showing at the moment three month columns.
I want to count the number of rows within the pivot that have data which is a number
=COUNTIF(Q10:Q150000, "<>")-1 (i am using the 1- top removed the pivot totals)
=COUNTIF(R10:R150000, "<>")-1...
how do i copy this formula to all rows
=COUNTIF(A:A,A112911)
if i drag it it changed the row number
=COUNTIF(A:A,A112912)
=COUNTIF(A:A,A112913)
=COUNTIF(A:A,A112914)
=COUNTIF(A:A,A112915)
and so on..
So i need to break up a report that is provided in a continued string of data..
A1215455545444444842121212121212121TTTRTR2TR2TY2212121212212122121
The data will need to be broken out as following..
Record type
String
1
Always "A"
Supplier ID
Numeric
5
XXX01 where XXX is the 3-digit...
So i now need to have some code to get the latest date from three possible fields
Field names are
Phone Email Text, this is what i am looking for as the outcome
Phone
Email
Text
Latest Contact
12/05/2023
21/10/2023
21/10/2023
01/11/2023
31/10/2023
01/11/2023
So i am trying to bring back in a query the results of all call made after another date field or is null, but its only bring back null records, even though we do have calls with dates i am using
"Contact_Date"
>=[Start_Date] Or is null
So i need to add leading zero to a set of numbers within a table that i imported into databricks from a CSV in doing so i lost the leading zeros, the format of the number should be like this
0999
0010
0009
i have
999
10
9
i tried this
UPDATE Test table name
SET IID = '0' + IID...
I am trying to get this to work in a sub form, to highlight the customers number in red and yellow background but its not working, the field in a text field
DCount("*","Customer_main","[Service_Number]=" & Chr(34) & [Service_Number] & Chr(34))>1
So some of the data that comes from another data source has duplicated records for the same customer i need to have these combained into one query record. I have tried to use the "Unique values" but its still puling the same two records for the same customer?
Looking to convert a dates
04/01/2023 to "January 23"
01/02/2023 to "February 23"
and so on possible to have both i can get the month only using this
Month: Month([Order_Date]) shows as month number not text
So i need to run a query to correct the telephone numbers within two fields
Mobile
Landland
due to the many data sources sometime we have a landline within the mobile field and the mobile within landline. i need to have access do a final clean-up and move the number to the correct file. so...
So i dont think its going to be possible, i need to create a new data table that has a Y or N next to each postcode...
Short Postcode Delivery Availability
BN1 Y
BN3 Y
BN45...
Hi,
So i need to bring back the results to show the oldest order and the newest order date with a count on total orders for a customer fields i wish to include are:
Customer_ID
Order Date
Need to show:
Customer_ID ¦ Count Of Orders ¦ First Order Date ¦ Last Order Date
123...
So i have this to shorted the postcode, which is working as long as a postcode is provided within the field, how can i get around so i dont get the #ERROR would like it just to be left blank? please?
ShortPostcode: Left([PostCode],1) & IIf(Asc(Mid([PostCode],2,1))>=65,Mid([PostCode],2,1),"")