Recent content by Randy

worked like a charm, thanks again

thanks so much will try these right now. it to answer above I needed trailing spaces. thanks again

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

thanks I had figured that out, but I have been working on a small problem, tblbanks as 2,721 records the query produces 2,729 records I am researching the 8 record differnce

ok that worked like a charm. one question, I have 2,436 rows in tblbank, but after I ran the sql statement I only got 1,476 rows. So I have some missing vendors in TblVendor. can I use a different JOIN and get all 2,436 rows, and the 960 rows would just show no vendor?

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

yes an excel file. for now the union query worked just fine.

I have no answer for your first question, the information is provided to me by a third party source. Eventually I will get around to discussing the layout with them, but I have this immediate need. second I did not think about 18 queries, and a union. I guess it is brute force but it would...

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

ok, the make table option still brings the 8 decimals into the "new" table. so back to same issue, when I export the table it includes 8 decimals. nice suggestion, thanks

thanks I tried the wizard and there is nothing to solve this issue. I did not think about a make table option. I will play with that, thanks

forgot the query statement for this field GL Account Balance (Local Currency): Sum(IIf(["account currency"]="USD",IIf(Mid([account],5,1) Between "2" And "3",["GL Reporting Balance (USD)"]*-1,["GL Reporting Balance (USD)"]),IIf(Mid([account],5,1) Between "2" And "3",["GL Account Balance (Local...

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

corrected, still does not work, but thanks that was a good catch SELECT TBLProvisionData.application, TBLProvisionData.role, TBLProvisionData.inheritanceInformation, TBLProvisionData.NETWORK_ID, [First_Name] & " " & [LAST_NAME] AS UserName, [Supvsr_First_Name] & " " & [SUPVSR_LAST_NAME] AS...

yes sorry I missed that, you are of course correct the last statement should be [TBLEmployeeMasterListing]![Network_ID]