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
DateSerial in Query by Kazlou
I have used DateSerial in the control source in field in my table to calculate the renewal date, adding 36 months to the original date, all works great. When...
February 14th, 2007 07:39 AM
by Van T. Dinh Go to last post
1 169
Select statement assistance by Danielle
Data Information: table1: tblPayGradeStructure Fields to be used: CurrGrade and CurrBreakpoint table2: tblPredSalary field to be used: PredSalary (note...
(Multi-page thread 1 2)
February 14th, 2007 07:05 AM
by Marshall Barton Go to last post
11 287
Export qry results to another database by Pilgrim
In my office I run 2 databases (same design but different data). I would like to be able to export a recordset to the other database or to a format that the...
February 14th, 2007 06:52 AM
by Len Go to last post
1 149
Export qry results to another database by Pilgrim
I wanted to email the datapacket for them to work with. Keeping in mind they have limited or no knowledge of databases. "Len" wrote: Is the client...
February 14th, 2007 06:26 AM
by Pilgrim Go to last post
0 173
dividing a month into 5 production weeks by Shah1398
i am facing problems in dividing a month into 5 weeks and then showing production of different sections of a factory in each week and also in each week there...
(Multi-page thread 1 2)
February 14th, 2007 05:57 AM
by Shah1398 via AccessMonster.com Go to last post
10 276
Make Multiple Tables via Query by Michael_V
I've tweaked some vb code which streamlines repetitive tasks. Essentially it takes Table1 and parses it into individual tables based upon a list in Table2...
(Multi-page thread 1 2)
February 14th, 2007 03:05 AM
by Michael_V Go to last post
15 268
Queries won't open in Design View by Bob
Hello, I am using Access 2007 Trial Version. I am trying to open queries in design view but get an error. The same queries open fine in design view in...
February 14th, 2007 12:19 AM
by Bob Go to last post
0 123
February 13th, 2007 11:55 PM
by John W. Vinson Go to last post
1 115
Special Character '#' by Samantha
Is it possible to query a field for a special character '#'? I'm trying to query a desc field that has '(B#)' in it. So far, I'm using: Like "*(B#)*", but...
February 13th, 2007 11:11 PM
by John Nurick Go to last post
6 138
Clock In / Clock Out (Military Time) equals negative time?? by Tracey
Time is entered in 15 minute increments of military time. I am using this: Expr1: DateDiff("n",,)/60 Works GREAT when your start time is "earlier" than your...
February 13th, 2007 10:49 PM
by Ron Go to last post
6 171
Matching Queries by [email protected]
I have numerous Excel lists that I need to merge into a master database. Some lists have partial, identical information, some have similar info with different...
February 13th, 2007 09:43 PM
by [email protected] Go to last post
0 138
End If without block If by ZIMMJE
I CONTINUE TO GET COMPILE ERROR: END IF WITHOUT BLOCK IF!!!! CAN ANYONE TELL ME WHAT IS WRONG? Sorry so long I wanted to provide the detail -- In a query I...
February 13th, 2007 09:29 PM
by raskew via AccessMonster.com Go to last post
5 194
Query for retrieving week end date. by iholder
I need to design a week end report. The weekly report includes days from Monday to Friday. Week ending on Friday.
February 13th, 2007 09:09 PM
by babyatx13 via AccessMonster.com Go to last post
3 132
Using Current System Time to Select Groups of Records by Sighman
Hi All I have a set of data that includes a text field with phone number in it. I would like to be able to select various numbers based on what time of day...
February 13th, 2007 09:03 PM
by Sighman Go to last post
3 142
How can I measure comparative progress across a range of dates? by efandango
I want to build a query that will give a user some kind of indicator on how he is doing over a number of weeks (maybe 52?) What would be the best approach if...
February 13th, 2007 08:45 PM
by efandango Go to last post
4 139
Series of action queries by ashg657
Hi, I have a procedure which runs when a particular summary form is opened. The procedure runs a series of action queries which update data in many tables so...
February 13th, 2007 08:37 PM
by George Nicholson Go to last post
8 134
Append Query truncates data posted to a table memo field by Lewis M
I use a query is to create a new record in a table with values taken from unbound controls on a form. Using an append query truncates data that is to be...
February 13th, 2007 08:35 PM
by Lewis M Go to last post
2 164
querry - choosing selection by Viktor via AccessMonster.com
I have the following query: SELECT Students.stdFirst, Students.stdLast, Courses.crsName FROM Students INNER JOIN (Courses INNER JOIN CoursesTaken ON...
February 13th, 2007 07:21 PM
by John Spencer Go to last post
1 172
Deleting duplicates entries in Database using MS Access by [email protected]
Hii, I have a problem in deleting duplicates from the tables in MS Access.I have a table that contains about 40,000 rows and about 15 columns or fields.Out of...
(Multi-page thread 1 2)
February 13th, 2007 07:06 PM
by John Spencer Go to last post
14 259
Setting a criteria to lookup from a table. by Surrealdogma
I want my query to show me only those records in a table with a certin name. The field on the table project info table is set to look up from the Clients...
(Multi-page thread 1 2)
February 13th, 2007 06:39 PM
by Jason Lepack Go to last post
10 333
Post New Thread


Display Options
Showing threads 20161 to 20180 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 05:57 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.