Search results

I table field GLAccountDesc. it can have 1 - 75 characters. I need a fixed length output of 20 characters. so far I have this IIF(LEN([GLAccountDesc]>=20,MID(GLAccountDesc,1,20),[GLAccountDesc]) obviously the FALSE statement is not correct because it will have 1-19 charactes NOT 2. I need...

I have a file from a bank which I load into tblBank. fields are date amt desc I have a table tblVendor that has fields Vendor Category I need to link the tblbank.desc to the tblvendor.vendor to bring in the vendor and category but of course the desc in the tblbank is something like this...

so I have a table userid,group1,group2,group3....group18 anyone user would have a group1 value or a group1 and group2 etc. so ether,admin,security,query smith,admin,query,tax,entry I need to output this into this format ether,admin ether,security ether,query smith,admin smith,query smith,tax...

so I have a simple query. I output the query data set to a tab delimited TXT file. I need the Amt field to be general (i.e no ",") and 2 decimals. the input file has 8 decimals. when I view the query results the Amt field appears as I would want. however when I do the extract the Amt field...

I thought I had this correct, but it will not work FROM TBLProvisionData LEFT JOIN TBLEmployeeMasterListing WHERE TBLProvisionData.Left([UserDirectory],Instr([UserDirectory],"@")-1) = TBLEmployeeMasterListing.NETWORK_ID so in TBLProvisionData my name is randyetheridge@unisource in...

I have two tables TblData TblG4Lookup TBLData 14 columns, but really only two column matters PSID TBTP TblG4Lookup paycode (key field) G4 (all records have a value) BalanceSheet (only about 10% of the records have values) The values in TblData fields PSID&TBTP are the same values as in...

I hope this makes sense I have a payroll feed that sends 9 items in one field. Field name is worktags. I need to parse out the data. I have this so far EarningDeductionCode: Trim(Mid([worktags],InStr(1,[worktags],"Deduction (Workday Owned):")+27, 25) So the 25 at the end of the code is...

I have two tables tblcurrency > group1 > 3 characters long i.e. 123 and tbltdataseg > account > 12 characters long i.e. 123456789012 I need to left join tbltdataseg to tblcurrency I tried this SELECT tbltdataseg.ENTITY, tbltdataseg.ENTITYX, tbltdataseg.ACCOUNT...

I have a table. userid, role, inheritance. so for example userid Admin has 572 rows, but only 26 roles. Each role has 22 inheritances. I want a total by userid with a count of unique roles. so in this example 26 not 572 I tried this and received my count of 572 SELECT DISTINCTROW...

I have the following query. All I am doing is comparing the count of an individuals system access on 10/4 vrs 11/16. So XYZ had 4 "inheritances" assigned on 10/4 and 4 on 11/16. I was expecting something like this XYZ 4 4 ABC 5 5 DEF 3 0 GHI 0 5 DEF left the company and...

field name is externallevel1 there are 54,068 of rows This is example of values in the field 020- AC - Accounts receivable net" 050- AC - Inventories" 210- AN - Property and equipment net" 410- LC - Accounts payable" etc etc. There are about 26 different descriptions repeated over the 54,068...

I am connecting to a table where some records might have the same value (long story as to why) Anyway seems simple enough to use the MIN function in my left join. but it is not working this is the statment SELECT B.Company AS Company,IIF(ISNULL(B.CostCell),"HR",B.Department) AS...

This works IIf([accountnum] Between "60000000" And "60499999","Material","Overhead") AS Assignment This does not IIf([accountnum] Between "60000000" And "60499999" OR Between "60510001" and "60809999","Material","Overhead") AS Assignment Second formula gives me a Missing Operator Syntax...

I have a field I am trying to bring into a SQL statement ,ISNULL(Convert(nvarchar(50),OPP1.OriginatingLeadId),'') AS 'OriginatingLeadId' I get this error message Conversion failed when converting from a character string to uniqueidentifier. the field specs' originatingleadid is attached I...

I have my application split, BE and FE. This is a form with a subform. For both I have the properties set to Data Entry NO Allow additions NO Allow Deletions NO Allow Edits NO anyone person can open the form, but when a second person tries to open the same form we get the standard, locked by...

I have a union query. I am pulling in data from two (almost identical) SQL views in two different databases. My MS_Access application is linked to the two views The issue is A.GroupId. In view finance_WILPMonthEndReview the field is set to NVARCHAR255 in view iq4bisfinance_3DMonthEndReview...

I have a crosstab query. users need to run the query for any week of a year. It is always a YTD query. I have used this process on many select queries. Will a crosstab query not support this simple method? See attached screen shots.

I have a query, and when I execute it, the correct data set is returned. However one field shows "DELETE" as the value for all records. when I ran it on the SQL server management studio as a test it ran fine. End user does not have access to the tables, so I created a small MS Access...

I have a very simple table. It has 12 fields, but I am only interested in GroupId, and dimension. dimension has what I believe to be some null values. when I run a simple query, both fields as output, and field dimension sorted ascending, I get my correct results. But when I run it with IS...

I am terrible with date coding in MS Access. something I need to work on. In excel I can usually work it out. I have this excel sheet and I want to convert all the formulas to an equivalent MS Access query formula. Attached is the completed excel workbook. Any help creating this date driven...