How To Make A Query Not Show Repeats

May 24, 2007

Hello, I have a system where a person may have several posts.

Ive made a query which shows everyone who has a post.

The problem is that if a person has three posts, the record shows three times, how do i make tell a query to do this:

Get all records, look at the name field, show only 1 record per name.

How do i do it? Whats this called? Where do i find out more?

Ant...

View Replies


ADVERTISEMENT

Modules & VBA :: How To Make A Text Box To Show Results Of A Query To Display On Screen

Dec 4, 2014

We have a button running a SQL query via VBA, how can I make it so the results doesn't show up in a table/preview?Also, I know it's for the SQL forum but how can I make a text box to show the results of a query to display it on screen?

View 8 Replies View Related

Why So Many Repeats Of The Same Answer

Aug 30, 2004

Why so many repeats of the same answer
Thank you MWalt for your reply about finding the stock in hand. It works, sort of. It gives the answer but I end up with each item being repeated about 141 times. So instead of ending up with a list of about 140 items, I have a list of 20000+ because each item is repeated. I'll include the code of the first query that you suggested called qryNotItem...where do I go from here.

This part works, but when I do the second part I run into an error.

SELECT [Equipment Inventory].EquipmentID, [Equipment Inventory].[OT Equipment type], [Loan details].LoanOccID, [Loan details].[Return date]
FROM [Equipment Inventory] INNER JOIN [Loan details] ON [Equipment Inventory].EquipmentID = [Loan details].EquipmentID
WHERE ((([Loan details].[Return date]) Is Null));

Thanks

View 1 Replies View Related

Reports :: Sebreport Detail Repeats Records?

Apr 21, 2015

I have a report that contains a subreport (form) that pulls records from a query. When I go to run the report, the records are there correctly, but the subreport continues to duplicate many times.

How do I fix this?

View 10 Replies View Related

Text In Textbox Repeats Itself In Multiple Fields?

Jun 20, 2012

I am building a database through access 2003 and have included a text box labeled "comments" in my design view. Now when i go to input information in the "comments" column in the datasheet view, the same text will appear for every entry. If I try to change the text in the next row, it will automatically switch all of the previous "comment" text to whatever I have entered. How do I fix this?

View 13 Replies View Related

Reports :: Sub-report Group Heading Repeats After Every Record

Apr 2, 2015

I have a subreport and would like to have a header that repeats on each new page if it extends to multiple pages.I tried the suggestion I have seen to create a dummy group header based on an expression of =1 and set the group header "Repeat Section" property to "Yes".header now repeats before every record, instead of just once at the top of each new page.

View 1 Replies View Related

Make A Form To Show Only 5 Months Old Records

Jun 27, 2005

Hi,

Just wondering how can I make a form that shows only 5 months old records. I know it has to be through a query but don't know how to proceed.

Thanks

Rajput

View 2 Replies View Related

Show If False But Wont Let Me Make It True

Sep 16, 2005

I have a form that shows the records found in a query if the completed tick box is false. this is fine, but i have also put the tick box on the form, and wish the user to tick it when they are done how ever they, get a beeping error and wont let you change it to true. Can anyone suggest the resolutoin for this.

View 2 Replies View Related

How To Make Associated Label Not Automatically Show With The Field

Aug 21, 2013

I'd sure like to drag fields from the field list onto a report without a label automatically showing with it. I have so many fields to deal with the time just to click it gone adds up.

View 2 Replies View Related

Forms :: How To Make A Form Show NOT Full Screen

Jan 7, 2014

See my 2 attachments. I put the Pop-Up property on the form. that worked but still not what I want.

On the HATT attachment do you see how it opens in the middle of the screen? And the other opens at the top right, (and has that tab at the top right that says frmMain)?

how do i made the airwatch open in the middle? like the other screenshot?

View 3 Replies View Related

Modules & VBA :: How To Make A Label Show When 10 Days Before Date Is Due

Jul 16, 2014

I'm trying to make a label show if the date in my next service field is 10 days till its due

This is what I have on a on current form event this works great but would like the message to appear 10 days before the date is passed

Code:
If Me.NextService < Date Then
Me.overdue.Visible = True
Else
Me.overdue.Visible = False
End If

Also tried this with no joy

Code:
If Me.NextService < Date <= 10 Then
Me.overdue.Visible = True
Else
Me.overdue.Visible = False
End If

View 5 Replies View Related

Make Column Show True False In Table

Jun 19, 2014

Can make a column show true or false in a table when two other columns in the table match each other? I think the statement would be like this:

If([Column1] = [Column2], True, False)

The only problem I am having is that I don't know if it can work in a table or does it just have to be in a query?

View 8 Replies View Related

Reports :: Make Custom Report And Show In It Images From Folder

Jun 22, 2014

i have a database. the database have a table called CardDetails in this table there is like 1000 rows.The table have a field named MedicalId. and i have a folder . it's destination (D:CardPic) . this folder contains 1000 pic has the same names as the medical ids....i need to make a report and show on it these pic's the database doesn't have a afield that contains the path.i need to auto display the images on the report depending on the medical id.

View 10 Replies View Related

General :: How To Make Combo Boxes Only Show Selected Options

Jul 6, 2013

What I am trying to do is create a master table which references the every other table.But the primary key references another primary key.I can get the combo box to display all the options, buy shows options already selected for other records.in other words...

I have 4 reference IDs from table A.
(ID1, ID2, ID3, ID4)

Master_Table has a combobox to select between the IDs.
if record 1 has ID_1
Record 2's combobox will show all 4 IDs
If I only have 1 ID that can be put into record 4, it's combobox still
displays all 4 IDs.

What I want is: If ID3 is selected for record 1, it wont be displayed in the comboboxes for the other records.

View 2 Replies View Related

User Defined Show/No Show Query Results

Jul 5, 2005

I have a parameter query built and am curious if anyone knows of a good way to allow the user to define which fields are displayed in the query results.

i tried looking for other threads discussing this without any luck.. not sure if it was my search terms or what. thanks so much for any help..

View 10 Replies View Related

Query To Show Show Different Results From Same Group

Jun 11, 2006

I wondered if someone could help.

I have 3 columns of data within a table and from a select query am trying to seperate certain groups.

Table 1

yr period valuehome

2006 0 100
2006 0 10
2006 1 1000
2006 1 800
2006 2 60
2006 2 50
2006 3 40
2006 3 10
2006 3 5
2006 3 70
2006 4 50
2006 4 5

I wish to show both results for period 0 and an accumulative total for periods 1-4

so results would be

year period Total sum

2006 0 110
2006 1-4 2090

Can anyone help?

thanks

Paul

View 5 Replies View Related

How To Make Values In One Table Automatically Show In Another Table?

May 22, 2007

Hi, I have a problem, I have a table were I list networkservices and their logical ports and I have another table were I list IPaddresses used by different machines. I'm using a multivalued lookupfield to pick which services I'm using for each Ipaddress, and thats working fine, but now I want to make the ports which is listed in another column, to automatically show in it's own column in the IPaddresses table depending on which services I'm choosing for the different IPaddresses. Is this possible?, and if it is how can I make this happen?

View 1 Replies View Related

Queries :: Combine Two Query Sql Code To Make Only One Query

Apr 5, 2013

First query = Sum Products:

Code:
SELECT Sum(Tab1.Inputs) AS SumOfInputs, Sum(Tab1.ValInp) AS SumOfValInp, Sum(Tab1.Outputs) AS SumOfOutputs, Sum(Tab1.ValOut) AS SumOfValOut, Products.Product, Products.VAT, Products.UM
FROM Tab1 INNER JOIN Produse ON Tab1.ProductID = Products.ProductID
GROUP BY Products.Product, Products.VAT, Product.UM, Tab1.ProductID;

Second query :

Code:
SELECT Nz([SumOfInputs],0)-Nz([SumOfOutputs],0) AS Stoc, Nz([SumOfValInp],0)-Nz([SumOfValOut],0) AS ValStoc, IIf([Stoc]=0,0,([ValStoc]/[Stoc])) AS CMP, [Sum Products].Product, [Sum Products].SumOfInputs, [Sum Products].SumOfOutputs, [Sum Products].SumOfValInp, [Sum Products].SumOfValOut, [Sum Products].VAT, [Sum Products].UM
FROM [Sum Products]
GROUP BY [Sum Products].Product, [Sum Products].SumOfInputs, [Sum Products].SumOfOutputs, [Sum Products].SumOfValInp, [Sum Products].SumOfValOut, [Sum Products].VAT, [Sum Products].UM
HAVING (((Nz([SumOfInputs],0)-Nz([SumOfOutputs],0))>0.09 Or (Nz([SumOfInputs],0)-Nz([SumOfOutputs],0))<-0.09));

I need to combine those two query sql code to make only one query.

View 3 Replies View Related

Is It Possible To Do Make Table Query From Union Query ?

Nov 14, 2007

can't seem to be able to do so..

View 2 Replies View Related

How To Make This Query?

May 15, 2006

I have a little problem with making a query and would need your help.

I have the following temporary table that gets filled automatically with 2 records every day:

DATE | TIME | NAME | CODE

The first record will have the DATE, TIME, NAME ( always the same ) and the CODE that can be START or STOP.

What i need, is to put the 2 records from the same day in a single row to get something like that:
NAME | DATE_START | TIME_START | DATE_STOP | TIME_STOP | NAME

Until now i was able to make 2 different queries. One can give me the START info's, the other one the STOP info's.
My question is if there is a possibility to combine those 2 queries or to make one query to get the result i need.

View 2 Replies View Related

How To Make That Query

Oct 31, 2007

I have 2 tables: first table has 4 columns:
/job code/project1/project2/project3/
job code is some digits, and in next columns are the job description (different for each project).

The second table has
/project name/job code/description/working hours/date/

I made the query what shows how many working hours was consumed for each project monthly
and my working codes, but I would like to have job descriptions after job code, If its project1
then the description should be taken from first table from the column "project1". Is it possible to do it with
query?

View 1 Replies View Related

How To Make This Query?

Dec 15, 2007

Hello,
How would I make this query:

I have with me a gene database. I have primary key as ID and another field, called Field2. It looks like this:

ID | Field2
1 BRCA1 (br1)
2 BRCA2 (br2)
3 APRE (apx)

I have several more ids like this in this database. I am fine with the first gene abbreviation, but the second one in the parentheses is redundant. I want them eliminated however it will take too long to go through and manually delete these redundant names.

Is there a way to make a query to erase the text in parentheses and the parentheses themselves?? I think it will go as an Expression in the query or perhaps I can use an Update query, but I am not sure beyond this point.

Please help. It is urgent. Thanks.

View 5 Replies View Related

How To Make This Query?

Dec 17, 2007

hello,

I am having some trouble here.

I have a gene database with several tables. One table is called GenesMain. The other is called temp (temporary table). The GenesMain has a little more information (more fields and pulling info from other tables in the db) than the temp table (which is the basic template with basic info)

When I find new genes from places like NCBI or other genetic databases, I make a temp table and put them in there. My hope is to update the GenesMain table with this info using an append query or update query.

The first time I run the database over a new batch of genes, I am fine making a temp table and producing a GenesMain table.

The 2nd time I run the database over a newly found set of genes (like a few days later or few months later), I can easily make a temp table.

I am having trouble now updating my GenesMain table to reflect this newly found information.

Does anyone know how to update my GenesMain table with the newly made info from the temp table? Thanks

View 4 Replies View Related

Show All Records From One Query And The Sum Of A Field In A Related Query Record

Mar 8, 2005

I'm building a report for annual software license renewals. The report data source is a query that combines the customer information, their computer information, and the licenses purchased for that computer. I am having no trouble with the form displaying the customer info page, then a page with the computer info at the top and a list of licenses purchased for that computer underneath.

That would be great, if that's what my boss wanted. However, she wants the whole list of available licenses displayed on each page, in the event someone want to purchase additional licenses with this year's renewal.

I'm trying to figure out how I can set up a query/report grouping to do that. I've tried making a new query, relating the qryLicense!licenseID to the qryPurchase!purchLicense and setting the relationship option to show all records from qryLicense and only those related from qryPurchase. I added the qryPurchase!purchCPU field to my query, hidden it, and set the criteria to “=1” (the computer ID of one of my dummy computer records). I also have a Sum of the qryPurchase!purchQty field included in the new query that I want to display the total number of that particular license purchased (and 0 if there are no corresponding records). All fields except for the quantity field are set to Group By.

What I’m getting from this is simply a list of the licenses purchased for that computer, not the complete list of licenses available showing the quantity purchased where applicable.

Can someone see where I’m going wrong?

Slaughter
slaughter at mizzou dot edu

View 9 Replies View Related

How To Make A Query Run Faster

May 8, 2007

Hi,

I am opening a query in Access which has two linked sql tables but it takes to long to open. Can I choose a method (ADO) opening that query? If not, is there a way to speed up the process?

thanks

View 1 Replies View Related

How To Make A Row With Totals In A Query

Sep 12, 2005

I have to make a query using information out of an existing table. In the table there are two columns which I have to use in the query. I need to have the totals of these two columns. The table looks like this:
country amount1 amount2
A 2 3
B 4 6
C 5 2
D 5 3

What I want the query to look like is:
country amount1 amount2
A 2 3
B 4 6
C 5 2
D 5 3
16 14

As I am dutch, my english will not be perfect
Thank you in advance

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved