Recent content by MazeWorX

I have several queries as a source for the final query. There are 2 types of record data in one table with an identifier('A' or 'P') for ea. which I combine into one record (2 queries on the same table with a where criteria on the identifier). In each query I rename to identify and transform for...

These are Access tables both fields are Number data types in datsheet view they align right and yes an Nz function was used in the query to deal with null values not all fields have data and further calculations were required. just a note i have resolved the issue with a *1 as originally...

Cool thanks PHV ... never even thought of using Val. Just goes to show you when your so fixed on the why(tunnel vision) the most obvious is not so obvious :) HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

grrr :) thanks Skip ... never had any issues in all of the db's ive every created before HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

Just curious anyone else run into this problem with Access 2010. I have a query that has several calculated fields and 2010 insists on concatenating the fields instead of adding them. funny thing is not all of the calculated fields only some of them and concatenates them with the + . Ive...

try "C:\Msaccess.exe" "S:\DATA\AcsData.mdb" /x MasterAccessToImport also check your Access location typically access is stored in another directory not just in the root something like C:\Program Files\Microsoft Office\Office11 or a variation of should work fine with the adjustments i update...

how about strtime = Now() strSQL = "INSERT INTO tblTime ( ClientID, ClientName, RptProcStart ) " _ & "SELECT " & strUCI & ", " & strCompany & ", " & strtime & ";" HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

Sorry posted the wrong first query SELECT tblProduct.Group, Min(tblProduct.Product) AS Test, Max(tblProduct.Product) AS Test2 FROM tblProduct GROUP BY tblProduct.Group HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

There may be an easier way but 2 queries SELECT tblProduct.Group, Min(IIf([Product]="HMO",IIf([Product]="PMO","Both",[Product]),[Product])) AS Test, Max(IIf([Product]="HMO",IIf([Product]="PMO","Both",[Product]),[Product])) AS Test2 FROM tblProduct GROUP BY tblProduct.Group; and the second...

how about using the FileDateTime() function that is built into access? HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

Do you mean this URL? https://www.wvuc.org/wvweb/PNewClaim/NewClaim.aspx HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

ohh btw add this code to the excel sheet and make sure in the vbe editor you have referenced the Microsoft Outlook library HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

Here is a starting point this code will create a distribution list from an excel sheet. It assumes you have First and last names on the sheet in columns A and B. they must match your contacts or an error will occur and the individual isn't added. The code is a little clunky because it has to...

built into accees is the ability to document the db ..... so the question is why? HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

The short answer is yes but we require additional information how is this data stored? is it in a database or an excel sheet. how do you want your list organized? by manger , group? HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>