Search results

Hi Everyone, I am fairly new to the whole Database thing, so hopefully you can help. So i created three tables; MONEYOWE.tbl, INVOICE.tbl, and PAYMENT.tbl. Basically, moneyowe.tbl is how much a client owes me. Invoice.tbl is the invoice i'll send the clients, letting them know that they...

Hi All, I am fairly new to Crystal, so still trying to learn. i am creating a report where i am able to get some good results, but now i am getting duplicates. Please see sample results: 0000018573 15 01 12/31/9999 1415 01FNR GARY JAMES 0000018573 15 01 12/31/9999 1415 01FNA GARY JAMES...

Hi, I created an Access form with a list box. The "row source type" is from Table/Query. My source table is sorting correctly(ie, 2008,2007,2006, etc.). HOWEVER, when I open my form, the sort order is incorrect; they are not in the 2008,2007, 2006, etc. order. Please advise how I can fix...

Hi, I imported an Excel spreadsheet into Access. As you know, Access will automatically create 255 characters size for each 'text' datatype. Now the issue is, when I create a query and I specify Right([Field Name],3) I get no/empty results. I know my query syntax is correct, but the issue...

Hello Everyone, I know the 'basic' stuff(like creating tables, simple forms, reports, etc.) but I am not too good with the advance stuff. Here is my table structure and data setups, and then I will list my issue. I have a table with two columns, "GradeCodes" and "SalaryAmount."...

Hi, My question 'sounds' easy, but i can't think of a way to do this. Please help! Ok, i have an 'employee' history table with 200K records. Each employee could have multiple records with different 'effective' dates(please see below for an example of two employees' records). What I want to...

Hi, I know how to create a parameter query where users could enter ONE criteria each time for a particular field of a table. Please see codes below. Now is there a way I can allow users to enter more than one criteria SEPARATED with commas for a particular field of a table? Thank you. Joe...

Hi, I have a query which I run in the query design view. Then I have the same exact query which I run on the 'background' of a form. The issue is, both queries turn out to have different record counts(eventhough I am using the same query and same tables). What is going on? Please help...

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

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

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

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

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

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

Hi, I have a list-box(Category) and a 'ok' button on the form. My OK button has the following [Event Procedure]: Private Sub OK_Click() Me.Visible = False DoCmd.RunSQL "Select [Barg Unit],[Medical Option],[Medical Coverage Tier] FROM RetireeCensus Group By [" & Category & "];" End...

Hi, I have a form with 1 List Box. This list box contains the names(SSN, Department, Status) of the columns in TableA. The question is, can I create just ONE query statement, and base the GROUP BY on whichever field the user selects? For example, if a user choose Department, then the...

Hi, I am trying to compare two columns' values within the same QUERY table, but I kept on getting the "Data type mismatch in criteria expression" error. What am I doing wrong? Here is my Select Query Statement: SELECT qryDedparmDedetail.EMP_ID, qryDedparmDedetail.[Employer Amt]...

Hi I have 2 tables(tblA and tblB) and I want a query result(tblC) where ‘group by’ only one record per individual, with the total added together and the type starts with ‘01’. Below(tblA and tblB) are examples of the two table. TblC is the query result that I want. tblA...