Search results

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 sort of understand you answer. but I think it is a little beyond my skill set right now. I need to get this done quickly and was hoping to use a basic statement in the Query. But I will use this to teach myself what you are showing for my future projects.

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 cannot believe I missed ON. I could not see the tree for the forest. :-) sorry to post such a dumb question, but thanks that was all it was. If I knew how to insert the head hitting icon I would

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...

never mind figured out what you were saying. so yes that worked. Kind of weird having to do 2 queries, but I got the correct count.

not sure I understand the first query returns admin 572 I need it to return admin 26 doing a query on the first query, there is no way I will get 26. Or I am missing something.

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...

thanks doing searches on Full Outer Join in Access. I understand the concept. I will play with that.

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...

good point about a new query as the subquery. In fact after thinking about it yesterday that is the solution I came up with. Yes the need to do this is not reasonable. But I am taking over a prior effort and will not have time to redesign it for a couple months. because there are duplicate...

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...

As noted above, MS Access natively connects with MS SQL server go into your MS Access application external data ODBC database click on "Link the data source by creating a linked table" In the select data source dialogue box find your database click OK in the dialogue box find the SQL table you...

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...

additional answers is your form record locks property set to no locks? Yes. have you changed the default in options>client settings? Yes. Default open mode is Shared.

sorry good questions I should have noted some answers in my post right now the FE is on the server in the same folder as the BE. For now we only have 5 users and they all go to the same folder to access the same FE. Yes as of now all users are doing read only. The data is loaded each night by...

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...