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
Access SQL Query by [email protected]
Primary Keys are in " " Database Tables: department ("deptNum", deptName, deptCity) employee ("empNum", empName, empCity) project ("projectNum", projectName,...
November 29th, 2006 11:07 PM
by Douglas J. Steele Go to last post
1 112
Query: Sum column with Duplicate Values by KARL DEWEY
Change the table structure to this one-to-many -- AutoID - primary key Month Name Month Number Cost Center Manager AutoID - foreign key Team Leader Hours
November 29th, 2006 11:01 PM
by KARL DEWEY Go to last post
0 72
Question about syntax by Nanette
Hi Lori, I tried a similar query on my DB and it worked. Try copying the syntax style to yours: SELECT tblCabinets.CabPN, tblCabinets.CabDesc FROM...
November 29th, 2006 10:59 PM
by Nanette Go to last post
0 74
Changing Time From Minutes to hh:mm:ss by KARL DEWEY
what am I missing or doing wrong? 7125 seconds equals 1:58:45 See my response to your other post. "TheNovice" wrote: Good morning...
November 29th, 2006 10:57 PM
by KARL DEWEY Go to last post
0 72
Converting a number into Hours and Minutes by Karrie
If I have a task that takes a total of 78 minutes, how do I create a query to convert total minutes into hours and minutes? My answer will be 1 hour and 18...
November 29th, 2006 10:53 PM
by KARL DEWEY Go to last post
5 80
Question about syntax by Lori
SELECT NAMES.,NAMES. FROM NAMES WHERE (((NAMES.)="1010")); Here is my syntax, what is wrong with it? I keep getting an error message.
November 29th, 2006 10:30 PM
by Lori Go to last post
0 69
advanced top 100 list query by wb
I am trying to create a list of top 100 customers by spending for each store. I can successfully create the list of top 100 customers for all stores, but when...
November 29th, 2006 10:21 PM
by wb Go to last post
5 92
Pivot by Date Range by WAstarita
I have a payroll database that daily I have to check if everyone's time sheet has been submitted. I would like to automate the query by being about to supply...
November 29th, 2006 09:47 PM
by Gary Walter Go to last post
5 183
Part Numbers Change after Importing by Jerry Whittle
Create a new table that has all the fields needed to import the Excel spreadsheet. Make sure that the problem fields are text datatype. Import into this new...
November 29th, 2006 09:41 PM
by Jerry Whittle Go to last post
0 82
Very Tricky Query by Grd
Hi, I have a Bonuses Table with three Bonuses Amounts and the dates that the bonuses came into effect 1 100 1/1/2000 2 200 1/1/2001 3 300 1/1/2002 I have...
November 29th, 2006 09:38 PM
by Grd Go to last post
0 75
question on joins by Nini
Why doesn't Microsoft Access support full outerjoins?
November 29th, 2006 09:37 PM
by Nini Go to last post
0 63
Query by Jerry Whittle
SELECT EL.* FROM EL WHERE EL.PrimaryKeyField NOT IN (SELECT O.ForeignKeyField FROM O WHERE DateField = WhatEverYouAreUsingForMonth) ; One problem with...
November 29th, 2006 09:31 PM
by Jerry Whittle Go to last post
0 86
Deleting values in a field in a table with several fields by Jerry Whittle
On the On Click event of the button on your form put the following code: DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE FrontDesk SET...
November 29th, 2006 09:21 PM
by Jerry Whittle Go to last post
0 81
Update query by ladybug via AccessMonster.com
I have two tables. The first table has program names (Program) as it's first field. It stores other program info in it as well. In the second table it has...
November 29th, 2006 08:50 PM
by ladybug via AccessMonster.com Go to last post
7 91
Calcuate date difference when two dates are same by Satyam
Hi, I want to calculate (date) difference of column B based on grouping in column A. Problem is similar to one of the threads on the discussion board except...
November 29th, 2006 08:44 PM
by Satyam Go to last post
2 124
Trim and Distinct by Nanette
I answered my own question. I went into Excel to trim the data first. In a separate column I input "=TRIM(A2)" then copied that for all the necessary rows....
November 29th, 2006 08:41 PM
by Nanette Go to last post
0 76
Deleting values in a field in a table with several fields by ChuckW
Hi, I have a form for input data into a table called FrontDesk with about 25 records and four fields. One of those fields is called RetailSales. Each week...
November 29th, 2006 08:17 PM
by ChuckW Go to last post
0 74
Tough proper case challange, help convert entire sentance. by TedMi
In general, what you want to do is next to impossible to automate, but requres USB (using someone's brain). -- Ted
November 29th, 2006 08:15 PM
by TedMi Go to last post
0 73
Query by ChrisM
Query MESS... Please Rescue Query - Perfect Attendance Tables - Employee List; Perfect Attendance;Occurances Perfect Attendance is based on no occurances...
November 29th, 2006 08:07 PM
by ChrisM Go to last post
0 78
how can I select partial data from a field? by Krista
Dale, thanks for the response. I have a name field that contains a 30 character name. This name is then broken down and deciphered by the hyphens in the...
November 29th, 2006 08:01 PM
by Krista Go to last post
0 73
Post New Thread


Display Options
Showing threads 21881 to 21900 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 12:59 AM.


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