Search results

Hi, I have a script that looks like this: For Each qdf In dbs.querydefs If qdf.NAME = "qryBiweeklyReports" Then dbs.querydefs.Delete qdf.NAME dbs.querydefs.Refresh End If Next qdf Select Case Category Case "Health Detail" SQL =...

Thanks for the sugestion, Ghostjung. I have tried query within a query before, but it causes some strange results once you start 'grouping' things. To your second question; I tried using group by, last, max, etc. but that didn't work. I'll try different things and see if there is any...

Hi, I think i might have not understood your question, or you might have misunderstood my question. Let me explain the nature of the "original" table. There are 3 records per individual because each record is associated with a 'type' of deduction(employee's deduction, employer's deduction...

Below is my query. Keep in mind that inside this "Biweekly_Temp_Table" there are 3 records per individual. I just want to have one count per employee. Thanks! SELECT First(Biweekly_Temp_Table.DEDPLAN_CD) AS FirstOfDEDPLAN_CD, First(Biweekly_Temp_Table.DEDTYPE_CD) AS FirstOfDEDTYPE_CD...

Hi, I have an Employee Table with 3000 records. There are 3 records person employee. Now I was able to 'Group' the 3 records per employee into one by running a query. In this query, I used a "Count" function and Access gave me a result of 3000. HOWEVER, I do NOT want a count of 3000, b/c...

Strangly, I figured out! Thanks again, Bob!

Ok, i have linked all applicable fileds, but the results still coming up with 2 records per each individual per each Type.

I think I kinda get what you are saying. I should "LINK" the shared field and not just "GROUP" them! Currently I am just linking the SSN and Type field. I'll try to link the rest of them now. There are about 15 'applicable' fields(SSN, Name, JobTitle, Department, Status, etc.) from each...

Thank you, Bob! What i don't understand is, if I have already created a single NEW table with the combine of DEDPARM1 and DEDETAIL1, why am I still having the Cartesian Product issue? Is Access NOT using the BIWEEKLY_TEMP_TABLE table's data? I am confuse. Thanks. Joe

Hi All, This post is a bit long, but it is actually really simple. I have two tables(DEDPARM1 and DEDETAIL1). I ran a “CREATE TABLE” query using these two tables, to create a NEW table called “Biweekly_Temp_Table.” DEDPARM1 sample data SSN |Name |Type |Amount...

That was easy enough! Thank you! Joe

Hi, I wrote a script which creates a new table and append records into it. Here are my codes: For Each rst In dbs.tabledefs If rst.NAME = "Biweekly_Temp_Table" Then dbs.tabledefs.Delete rst.NAME dbs.tabledefs.Refresh End If Next rst qryBtt = "SELECT DEDPARMS" & payp &...

Of course i am NOT putting ALL the tables into one database! This is the main reason i am LINKING to tables in other database just so I can keep my 'main' database(A) to a minimal. After I have linked to other tables(from other databases), I have NO problem running queries against them...

Hi, I have a 'main' database named(A), and I have 2 tables that I have linked from two other databases(B and C). NOTE: I kept all this 3 databases(A,B,C) in one folder named 'Joe' on my workstation. Here is the issue, every so often when I open my 'main' database, and I need to query the...

Thank you. This sounds easy, but how? I don't see the table of the other database(dbsB) when I am in Query design view of dbsA.

Hi Everyone, I have two completely different databases(dbsA and dbsB). In a form of one of the database(dbsA), I want to be able to click on a button to 'query' information from dbsB. Is this possible? Is there anything that I need to set up on the 'front-end' or can i do this with scripts...

Hi, Thanks! I have already created my database as a single component; not separated into front end and back end. Is it too late to do so now? How do I split one database into front end and back-end?

Hi, I am a newbie; i know how to write simple codes but not the more advance ones. Please help! The module below create a query(qryBiweeklyReports) and then run it. It works fine if one person run it. HOWEVER, if I have two people run it simultaneously, I get something like...

Anyone knows if I can predefine decimal places in a query statement? For example, when I run the select query below, I want the MedicalPremAmt to have two digits after the "." It should look something like this: 12.38 Thank you. SQL = "Select [Barg Unit], First([Medical Option]) As...

I figured it out! Thank you! Here is the code in case someone need this in the future. What i did was to create a 'querydef' and then execute it. Now I just need to figure out how to put the query results in a report. Any suggestion? Private Sub OK_Click() Me.Visible = False Dim dbs As...