Urgent Help Needed With Table Create Query.

Aug 6, 2007

Hi all, i need some help constructing a query that will create a table for me that does not include the Type value of 'promotion' if the same ID value exists elsewhere within the query.

For instance, in the example below, i would want to delete the first entry containing 'Promotion' because ID2001 exists in two other places. However, if only one instance of ID2001 'Promotion' existed in my query, i would want to keep that entry. I would prefer to write all my data to a new table called "Test", This query has to sort out about 1000 entries when executed, otherwise i'd do it manually.

I'm pulling my hair out with this one, so could someone help me?

ID Company Name Type
ID2001 Disc plc John Promotion
ID2001 Disc plc Paul Agent
ID2001 Disc plc George Agent

View Replies

Query Needed Please Help Urgent

Feb 25, 2008

Original Table
ozip dzip shipdate wgt Transport cost

A B 12/1/07 20 450
C D 4/1/08 15 890
E F 9/1/08 78 750
A B 12/1/07 42 789
X Y 1/1/08 17 900
C D 4/1/08 34 90

Needed Output

ozip dzip shipdate wgt Transport cost

A B 12/1/07 20 450
A B 12/1/07 42 789
E F 9/1/08 78 750

I need to create a query which extracts rows with wgt >60 and also WHEN the fields ozip, dzip and shipdate are same, the query should add the wgts and then sum of wgts should be >60- for example the first and fifth rows should be extracted since sum is 62.

I have attached the output that is required for the above example. please help

View 1 Replies View Related

Urgent Help Needed

Jun 19, 2006

A record in a table linked to various others has recently been corrupted in my database. When i try to delete the record an error message appears telling me that the 'Search key was not found in any record' and the record will not be deleted. This corrupted record is causing me serious problems and i need rid of it by the end of the day.

Any suggestions would be greatly appreciated.

View 3 Replies View Related

Urgent Help Needed!!!

Jul 5, 2006

HI,

I am having a problem with all of my comment fields showing up as Japanese and I need to get some reports printed...
Does anyone know how or why this would or could happen?

I have checked the tables but they are normal. When you query the tables is when the comments start to mess up.

Thank you.

Your help is really appreciated!

View 7 Replies View Related

Urgent Help Needed

Nov 7, 2006

Hi,

I'm importing data of a query to excel from access; however, all fields that have combobox for input display numbers instead of text.

Any help will be very much appreciated.
B

View 4 Replies View Related

Urgent Help Needed!!!

Nov 14, 2007

Hello, I'm new to the board and I need an urgent problem fixed. Ok, I have a query that contains the type of TRAINING REQUIRED FOR EACH POSITION/PERSON IN A COMPANY . It has:-

1. Clock no. (uniqe for each employee)
2. Job Title
3. Position effective date
4. Training code
5. Description of training code
6. Retrain requirements ( number of days that are needed after initial training to reach retraining date, this varies from 0 to 365 days depending on the code)
7. Status of employee (whether active or inactive, the criteria for this is active)
8. Due date for completed training

I have another query which shows the TRAINING RECEIVED FOR EACH EMPLOYEE. IT has:-

1. Clock no.
2. Job title
3.Last names (employee)
4. First name
5. Status of employee
6. Training code
7. Date of training received

QUESTION IS HOW DO I CREATE I GUESS ANOTHER QUERY THAT WILL TELL ME WHAT REQUIRED TRAINING CODES THAT EACH EMPLOYEE HAS NOT RECEIVED? I BASICALLY NEED TO KNOW IF EVERY EMPLOYEE HAS BEEN TRAINED CORRECTLY ACCORDING TO THEIR POSITION OR NOT.

View 14 Replies View Related

Urgent Help Needed

Dec 25, 2007

I need to make a database for a association and collect the Business information and Personal information the following information is needed
For business
Business name
Corporation Name
Address
city
state
Zip Code
County
Phone
fax
then
Type
alcahol yes/no
tobacco yes/no
EIn number
STI Number
Sale tax Number

Personal

Name
Address
city
state
zip
phone
cell
email

*some things one owner might have more than one store.
i can make the form and everything just need help with relationships and that quiries that sort of stuff.

I am attaching a access 2007 file which i use.

View 6 Replies View Related

Urgent Help Needed

Apr 12, 2007

hi i am making a database for a company, in which i have the feild "joining date" and the feild "paymant method" which can either be yearly or half yearly

im looking for a quiery that will work out who need to pay when and also i need it to bring them up two weeks before due payment..... im then going to mailmerge them.. which i am not 100% sure how to do. :eek:

any help is highly appreciated :rolleyes:

View 5 Replies View Related

Urgent Help Needed

Mar 23, 2006

Hi,

I was wondering if anyone might be able to help me here. how do i stop the combobox to print multiple duplicate records?

for example,

in the combobox dropdown, there are records as follows
01
02
03
04
05
05
05
06
07

How do i ensure that it only displays the unique records only without printing 05 three times?

Your help is greatly appreciated.

Thank you very much

View 5 Replies View Related

Urgent Help Needed!!!

Apr 28, 2006

Hi. I am creating a website for my employees. I have created a table, query and a form in microsoft access containing a lot of different fields, including employee ID and password. I have also created a form in Dreamweaver. How do i link the database to the form and how do i create a code that will log in the employee if his password and username are correct, into a new page and if the info is wrong, to another page. PLEASE HELP. This is very very urgent!

View 4 Replies View Related

URGENT HELP NEEDED. VB Corrupt

Sep 25, 2006

Hi all,

Big problems on access 2003.

When opening my live db, the message

"The Visual Basic for applications project in the database is corrupt."

I've had a quick search but can't find a solution.
This db has always been access 2003 (Not converted from prior file version).
I can't even import into a blank db as the same error occurs.

HELP!

View 2 Replies View Related

Urgent Help Needed For New System

Jan 9, 2008

Hello all being my first post i will try and make this as clear as possible...

its a new system my company.

my manager would like if possible the system to work in this way..

firstly a form whcih will book rides so when opened will ask current members to etner their card no which is a 16 digit number always beggining with 5555 1946 and the customer no. added on which is 0000 0001.

If a customer has not registered another link so they can register and enter details and once done this press enter and message generating a new 16 digit card number 1 mroe than the highest number in the system. new members are allocated 2000 points on their card and points are taken off when booking new rides plus a 10 point booking fee.

then a button will be clicked to take back to reserve rides which allows the customer to book a ride using the ride id and ride number on a specific Session of which there are 3 times in the day 11:00, 14:00 and 17:00 and with a maximum of 5 places on each ride during each session being able to book.

once session ID and time,date selected the next box should show the available rides

if member does not have enough points to book an error message is displayed.

I know this all sounds confusing and ive attached my progress so far its very basic being a basic user i hope users out there can help as this has to be done before friday

the attachment is below thankyou for all the help

View 2 Replies View Related

Urgent Help Needed � I�m A Novice

Oct 11, 2005

Hi everyone,

Basicly I am doing an Access Project for my school coursework, but I am really confused and my teacher isn't that great.

My coursework is based on a video rental company.
The database (in breif) has to be able to bring up a customers details, and add a loan to/under that customers details. (as you would expect from a video shop).

Now, to be honest, I dont know if I have the correct items in each table, but was wondering if someone would be so kind to have a quick look to tell me what to change and where to put the relationships for the database to work correctly.

I have taken a screen shot of my current database:
http://img259.imageshack.us/img259/8216/accessproblem4de.th.jpg (http://img259.imageshack.us/my.php?image=accessproblem4de.jpg)

If you would like any other information, please let me know.
I am really grateful for this!

PS65

View 14 Replies View Related

Sum Not Working! (URGENT HELP NEEDED)

Oct 31, 2006

Hi,

I have used sum() function in a query where I have got other attributes. However, the sum() doesn't work for some reason.

I could not attach my database as its size is too big. i have uploaded it to this server where you can download it.
aimreda.co.uk/db (http://aimreda.co.uk/db)

Any help will be very much appreciated.

Regards,
B

View 9 Replies View Related

URGENT HELP Needed For VB Code

Feb 10, 2005

Hello all
I am having a problem with my vb code. I am realatively new to vb and what I am trying to do is search through a table according to what is selected on my form and delete the values that equal the value selected int the table. What I have so far is this

Private Sub cmdDel_Click()
Dim rsSource As DAO.Recordset
Dim rsDestination As DAO.Recordset
Dim theBug As String
Dim SelItm As Control
Set SelItm = Me.Users
If Me.Schedule.ItemsSelected.Count = 0 Then
Beep
Exit Sub
End If
Set rsDestination = _
CurrentDb.OpenRecordset("User_Course_Room", _
dbOpenDynaset)

For Each Itm In Me.Schedule.ItemsSelected
rsDestination.FindFirst "User_ID = " & Me.Users & "" And "Course_Room_ID = " & Me.Schedule.ItemData(Itm) & "" ### THIS LINE GIVES ME A ERROR
'rsDestination!Course_Room_ID = Me.Schedule.ItemData(Itm)
'rsDestination.FindFirst "Course_Room_ID = " & Me.Schedule.ItemData(Itm) & ""
rsDestination.Edit
rsDestination.Delete

Next Itm

Me.Sessions.Requery
Me.Schedule.Requery

End Sub

In the line with the bold writing next to it I get an error. What I am trying to do is search for the record with the user id selected and the course room id seleceted and delete that record but I get an error. Any help would be highly appreciated.

View 2 Replies View Related

Urgent Help Needed In Formatting A Date??

Nov 16, 2005

I have a column called date, right now it is in m/dd/yyyy format and i want to convert this to dd-mmm-yyyy format how do i do this? thx for any help

View 1 Replies View Related

Urgent Required Field Advice Needed

Jul 1, 2005

I'm looking for advice on the best method to accomplish the following from the esteemed members of this Forum (You all have provided excellent advice in the past to this Access Dummy, with my thanks), (I've also searched the forums without result):

I would like to make several fields "required" fields on my form, easy enough, in that I set the Required property on the table to "Yes".

What I would like to happen on the form is that when a user tabs out of a required field, a message box pops up that says "This is a required field" and/or when they click any of the following command buttons I've created, "Save Record", "New Record" or "Close Form", that a message box pop up and list the required fields that they missed.

Any ideas, with code, macros, or other solutions would be greatly appreciated, keeping in mind that I'm just not that swift to start with.

Many Thanks,
Photoguy

View 9 Replies View Related

What's Wrong With This Create Statement? (Urgent)

Jan 10, 2006

CREATE TABLE Jobs
(jobname LONGTEXT(1000) NOT NULL, [desc] LONGTEXT(1000) NOT NULL,
[req] LONGTEXT(1000) NOT NULL, [specialreq] LONGTEXT(1000) NOT NULL)

Thanks!

View 1 Replies View Related

General :: 2 Fields From Separate Tables Needed To Create Calculated Field?

Aug 19, 2013

The interface being used is a main form with various tabs and a subform on each of these tabs.

There is one field ('max power density') in my database that is calculated using 'Max Rated Power' and 'Cylinder Capacity' however these are in different tables and subforms. The 'max power density' and 'max rated power' are in table and subform 1 but 'cylinder capacity' is in table and subform 2. Is it possible to keep them in separate tables/subforms and still calculate the field?

View 7 Replies View Related

Table Name And Links ---URgent

Feb 28, 2008

i have 2 mdb and both mdb have table link

in one of the mdb , they had a link to dbf (paradox) and they have lot of queries and reports created.

Now the functionality has changed so we have created a access table and need to replace the dbf with the table.

The problem is we need to retain all the queries and reports as such but the table will be access table instead of dbf.

Example

First.mdb has test table
Second.mdb has a table called old.dbf. and associated quries

but now test table is been linked to second.mdb and we got to rename or delete old.dbf and associated all queries and reports pointing to test table

is there a way to do it automatically or should it be done manually?

Please let me know as it is urgent

View 1 Replies View Related

Variable Table Name? Need Some Urgent Help!

Apr 1, 2007

hey is it possible to have a variable table name;

this is my scenario:
i have four category of products, which i am selecting using a pull down menu. depending upon which the user chooses, a particular table of database shud be searched.

this is what i have been tryn:

tablename=CStr(Request.Form("category"))
strq="Select * from '&tablename&' where (model='" & CStr(Request.Form("model")) & "') ;"

but im getn the error: incomplete query.

been tryn double and single quotes. just not getn it.
please help! have to submit my project morrow!!!!!

View 1 Replies View Related

Create Table Query

May 31, 2005

Hi

Is there a quick way to split up a table into many other tables? I want to split the table by Client Number, so all the Clients with 1234, for example, are in a table called Client1234

I know the very long winded way, creating a �Create New Table� query, inputting the Client Code criteria each time.

Is there a better more efficient way?

Thanks

coley

View 8 Replies View Related

Create Table Query

Mar 9, 2007

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 & ".EMP_ID, DEDPARMS" & payp & ".FORMAT_NM, " & _
"Sum(IIf(Right([DEDPARMS" & payp & ".Dedtype_CD],1)='R',[overded_am],0)) AS [Employer Amt], Sum(IIf(Right([DEDETAIL" & payp & ".Dedtype_CD],1)='R',[DEDETAIL" & payp & ".ded_am],0)) AS [Employer Actl], " & _
"Sum(IIf(Right([DEDPARMS" & payp & ".Dedtype_CD],1)='A',[overded_am],0)) AS [Admin Amt], Sum(IIf(Right([DEDETAIL" & payp & ".Dedtype_CD],1)='A',[DEDETAIL" & payp & ".ded_am],0)) AS [Admin Actl], " & _
"Sum(IIf(Right([DEDPARMS" & payp & ".Dedtype_CD],1)='E',[overded_am],0)) AS [Employee Amt], Sum(IIf(Right([DEDETAIL" & payp & ".Dedtype_CD],1)='E',[DEDETAIL" & payp & ".ded_am],0)) AS [Employee Actl], " & _
"First(DEDPARMS" & payp & ".STATUS) AS FirstOfSTATUS, First(DEDPARMS" & payp & ".AGENCY) AS FirstOfAGENCY, " & _
"First(DEDPARMS" & payp & ".TITLE) AS FirstOfTITLE, First(Right(DEDPARMS" & payp & ".title,2)) AS RepUnit, Left([DEDPARMS" & payp & ".DEDTYPE_CD],2) AS Type, " & _
"Left([DEDPARMS" & payp & ".DEDTYPE_CD],2) AS LeftType, Sum(DEDPARMS" & payp & ".NBR) AS SumOfNBR, First(DEDPARMS" & payp & ".DEDTYPE_CD) AS FirstOfDEDTYPE_CD1, " & _
"First(Right([DEDPARMS" & payp & ".DEDPlan_CD],2)) AS Tier, First(Left([DEDPARMS" & payp & ".DEDPlan_CD],2)) AS Carrier, DEDPARMS" & payp & ".DEDPLAN_CD Into Biweekly_Temp_Table " & _
"FROM DEDPARMS" & payp & " LEFT JOIN DEDETAIL" & payp & " ON (DEDPARMS" & payp & ".EMP_ID = DEDETAIL" & payp & ".EMP_ID) AND (DEDPARMS" & payp & ".DEDTYPE_CD = DEDETAIL" & payp & ".DEDTYPE_CD) " & _
"GROUP BY DEDPARMS" & payp & ".EMP_ID, DEDPARMS" & payp & ".FORMAT_NM, Left([DEDPARMS" & payp & ".DEDTYPE_CD],2), Left([DEDPARMS" & payp & ".DEDTYPE_CD],2), DEDPARMS" & payp & ".DEDPLAN_CD " & _
"HAVING (((First(DEDPARMS" & payp & ".STATUS)) Not In ('P'))) " & _
"ORDER BY DEDPARMS" & payp & ".EMP_ID, First(DEDPARMS" & payp & ".STATUS);"
DoCmd.RunSQL qryBtt

NOW THE ISSUE IS, AN ALERT MESSAGE ALWAYS POP UP SAYING SOMETHING LIKE, "You are about to paste 34590 row(s) into a new table." What would I have to do to get rid of this pop up? Eventually my users are going to use this and I don't want them to be alarmed when the message pop up.
Thank.

Joe

View 4 Replies View Related

Create Table Query

Feb 13, 2007

can I use create table query and change a fields data type?

I have a field with numbers, but when I get the table, it is set as a text field. I want it to be a number field, but I can't change the orignal table. That's why I was going to use a create table query, but I can't figure out how to change the data type from text to number.

Thanks

View 1 Replies View Related

Maximum Records In A Table !!!urgent!!!

Jan 21, 2005

Can anyone please tell me the maximum number of records a table can accomodate? Also what happens if the number of records exceeds this maximim value? Awaiting reply

View 2 Replies View Related

How Do I Create A Query Like A Pivot Table?

Nov 15, 2005

View 3 Replies View Related