Search results

I need to compare two tables. That is not the problem the problem is in Table A only the first 6 letters for the same information is listed. So, Table A has AGGREV, which I need to match with Aggrivated Assult in Table B.

I use a zip code file that lists the zip code and then in my data entry software fills in the city and state. Is there a way to use this file for an Access form?

Here we have three shifts for which I make a productivity report. By taking the hours put in by the person, we can see how much time they spent doing data entry, or other "work". The problem is with third shift. The hours we get from our time clock are military time, therefor switches to a...

The problem is I have 48 different species of bettas that each need to have their own set of numbers. After a fish is bred, that species will not have 100 offspring that need numbering in that particular species. For one species it should start at 1 and go to, say, 54; another species should...

It shows on the form, but not on the table. The main form has an autonumber for Client ID and then there is the Company Name. On the next subform, I would like these two items to auto populate into the form, and they do, but when I go to the table, they are not there? Help.

I have a sub form of a sub form that won't let me add. The Main form links to the subform via a client ID, the subform links to the subsub form via jobid and the subsubform needs to have both the clientid and jobid update as a new job is added. But I can't add anything. My master/child is set...

That is the error message I get when I try to add a new record to a sub form. My parent child seem to be set correct and I do have a autopopulated field, but I don't know why it keeps saying "You can't assign a value to this object."

I have a sub-sub form which contains multiple information which can be input on one item from the subform. When I try to add information, it does not let me add additional information, but lists all the sub-sub form information for every subform info. I hope this makes sense. Basically, it is...

I have a report that produces the average of percentages, but they are not weighted depending on how much of the total job a person did. i.e. A does 20% of a job, but produces at 59% rate (rate determined by key speed, price of a project, and rate paid to the keyer). B does 50% of a job and C...

I am using a query to add two amount together and it seems to be leaving one amout out. Using the date and store number as the link, and in the join properties I use number 2. When is use the statement Other:[sumofotheramt]+[sumofrentalamt], it only returns the rental amount. Help, Kristin

Here is my slq, and I am getting blank fields when the [hoursnotworks] is blank, but I though the IIF statement would work... SELECT IIf([hoursnotworked]=0,[sumofclock hours],[Sumofclock hours]-[hoursnotworked]) AS [Clock hours], [BCBS Query].Initials, [BCBS Query].Firstname, [BCBS...

I am creating a delete query that should delete those items which match the first and last name of another table. It looks like this: Field: Last Name, Table: Chi-town, Delete: Where, Criteria: [Delete].[last name]. Same for first name. When I go to run the query it says to specify the table...

I am creating a delete query that should delete those items which match the first and last name of another table. It looks like this: Field: Last Name, Table: Chi-town, Delete: Where, Criteria: [Delete].[last name]. Same for first name. When I go to run the query it says to specify the...

I have a table with date, employee name and hours. Then I have a query that separates last name and first name. It is now, date, lastname, firstname and hours. For some reason it is giving me an Invalid Procedure Call when I try to alphabatize the people by last name LastName...

I have a database for entering customer, jobs and tasks for each job. All are connected by a customer ID (Customer to Jobs) and Job Id (Jobs to Tasks). I created a form to enter the customer and subform for the jobs and a subform for the tasks. In the Customer form the Customber ID is a...

I have a database for our customers, which contains multiple Jobs for each customer and multiple tasks for each job. While trying to put together a job sheet report, I included the basic information of the job, but needed to also include the multiple information of the tasks for that job. How...

I would like to combine the data that is in multiple fields into one field. How would I go about this. Kristin

I have all the information for the report with a box, but I want to make the boxes have rounded corners. Is this possible? Kristin

I am working on a catalog of items and they are listed in boxes, two columns. What I need to do is put in a "next record" command so that the first column will go the next listing. Also, I need to make a box with rounded corners, any ideas? Kristin

When using a query to merge three fields and to come up with a sum i.e. IIF([A]=0,0,[A]+[B]+[C]), it return nothing. When I add B and C, I get the correct product, but add in that A, which usually is empty, I get an empty cell.