A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Excluding duplicate records in query by Roman B.
I have a table with about 300,000 records. Many are duplicates. I'm trying to create a make-table query to get only 1 copy of each record while ignoring the...
November 27th, 2006 09:13 PM
by John Spencer Go to last post
2 98
中山市東升鎮粵華酒店-黃賭毒 by 共產黨
November 27th, 2006 08:47 PM
by 共產黨 Go to last post
0 141
date expression to bring up a weeks worth of records by chris
i have my new data base built but for the love of god can i get the expression right this. in my query i need, when prompted it asks for a date, and when i...
November 27th, 2006 08:34 PM
by fredg Go to last post
4 139
Calculating Dates by Melinda
I have several queries wrote where I have set the criteria to input the and and I want to capture all the data in between. I also have a lookup field that...
November 27th, 2006 08:30 PM
by Melinda Go to last post
3 98
CrossTab Challenge by MJatAflac
I have an interesting challenge with a couple of CrossTab Queries. I have a crosstab that gives Project Resource and then Forecasted Hours by week. I have a...
November 27th, 2006 07:53 PM
by Jeff C Go to last post
5 129
Left Join by mustish1 via AccessMonster.com
Hi: There are three tables in my database. Table Main I use to give stars and table Star Redemption is used to give prize. There is another table name Prize...
November 27th, 2006 07:51 PM
by mustish1 via AccessMonster.com Go to last post
0 83
Removing extra spacing in imported text by Kat
I have (2) tables that were imported into access from excel. However, the data has a combination of letters, numbers, and dashes in it. That will make the...
November 27th, 2006 07:06 PM
by Kat Go to last post
6 134
Query with Form as a parameter by Amy
Hi! I have created a small form with a combo box which I am using in a query. However, when I call the form from the query criteria, it is not bringing up...
November 27th, 2006 06:46 PM
by MJatAflac Go to last post
7 114
Top Ten Records Displayed by a value by K
Good day, I am trying to create a report that is based on a query. How do I Only display the top ten items by highest volume? Any help would be apprceiated.
November 27th, 2006 05:41 PM
by MJatAflac Go to last post
3 92
False results using by Sweetetc
I am comparing two large tables (3600 records) using . I have two issues. 1. One of the sets of column I can see visually match. ALL records in each...
November 27th, 2006 05:29 PM
by Sweetetc Go to last post
2 84
Listing dates greater than 6 months from today by Danielle
I have written criteria as follows........ when run I enter a date 6 months from today and it shows the records I need. I would like this to be...
November 27th, 2006 05:16 PM
by Danielle Go to last post
3 102
Appending column with different data type by JoeA2006
I need to append rows from a query to a table and then export this data to Excel. I would like to be able to sum the columns with a macro in Excel. The...
November 27th, 2006 04:32 PM
by kingston via AccessMonster.com Go to last post
1 93
Appending to same table by SquirrelToothAnnie
Hi, I have a table called "session reports" where the data is entered into it via a form. At present I can do one member/one session report but I'd like to...
November 27th, 2006 04:17 PM
by Duane Hookom Go to last post
3 97
Problem is sum hours, because when cross 24h start in zero by Marco
Hello. How can I sum a total of hours. I'm having this problem. When the total of hours cross 24h it restart, like it was passing to another day. Exemple:...
(Multi-page thread 1 2)
November 27th, 2006 03:33 PM
by Rick Brandt Go to last post
16 145
Navision & Access by Jez
Hi, Please help... I am new to Microsoft Navision, and have a Access database with tables that I use. I am trying to understand how I can connect to MS...
November 27th, 2006 03:26 PM
by stumac Go to last post
1 90
comparing adjacent records - looking for dup/missing customer orders by Jesse
I'd like to test/compare adjacent records to look for duplicate orders and missing orders from my shopping cart data. I am an Access 2000 newbie. I had...
November 27th, 2006 02:23 PM
by John Spencer Go to last post
2 94
???Takes very long to do make table query by Jaylin
Would very much appreciate expert advice on why it takes a minute to run a select query, but takes forever to do Make table query on the same set -- Thanks a...
November 27th, 2006 01:57 PM
by Rick Brandt Go to last post
3 116
Birthday Querie (For multiple Birthdates in each record by naigy via AccessMonster.com
Hi I am in the process of setting up a contacts database where for some contacts i am wanting to store Spouse name and birthdate and where applicable the same...
November 27th, 2006 11:39 AM
by naigy via AccessMonster.com Go to last post
5 90
Insert one of two fields into a new table by Arts
I have a table A with data and want to fill another table B with data based on certain conditions in the first table. If Field A.Author has a value put...
November 27th, 2006 11:34 AM
by Arts Go to last post
2 78
Problem accessing the LIST property of a listbox by John T Ingato
I had encountered tis problem a while back and do not remember if I ever solved it. I have created a form with checkboxes. Once a checkbox is clicked, a...
November 27th, 2006 10:50 AM
by Brendan Reynolds Go to last post
1 64
Post New Thread

Display Options
Showing threads 22001 to 22020 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 08:28 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.