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
Update Query by Access Rookie[_3_]
How do I create an update query to automatically assign the create date of 9/24/2009 as the end date for for the record with the create date of 9/15/09. ID ...
March 22nd, 2010 01:24 PM
by John Spencer Go to last post
1 223
Querying Dates by Martin
Hello, I am looking for some advice on how to tackle querying some data. I have two tables, table one with around 10,000 records per month and columns...
March 21st, 2010 09:02 PM
by John Spencer Go to last post
5 262
query to update familyID by last name by Kathy R.
I have a set of about 500 names that I need to break down into family groups. The data was imported from an old database and this set of names does not have...
March 21st, 2010 08:14 PM
by Kathy R.[_3_] Go to last post
4 260
SubQueries by Bruce
I am running Access 2007 SP2 on Windows XP Professional SP 3. I have a query that I need to run a subquery to obtain a value in the previous record....
(Multi-page thread 1 2)
March 21st, 2010 05:43 PM
by Bruce Go to last post
14 571
Adding lines together to create one line by clalc
This is probably very simple but somehow I can't remember how to concatenate lines, so I have one line. Here is example: Table: Notes OrderNo LineNo ...
March 21st, 2010 05:41 PM
by KARL DEWEY Go to last post
4 282
Query with 2 parameters asks for 3 by Avid Fan
I want to search on first and last name at the same time, so I have made a combined field called BigName. When I run this query I get a request for three...
March 21st, 2010 02:37 PM
by Avid Fan Go to last post
2 254
Running a query against a password protected spreadsheet by sphelps
I used to be able to run an access query against a linked excel spreadsheet and update information in the spreadsheet. The spreadsheet is now password...
March 21st, 2010 01:13 PM
by sphelps via AccessMonster.com Go to last post
2 215
DSum in Query by Peter
DSum in Query Hi. I think this is probably an error in my syntax and I’d really appreciate some help please. I have a financial database that has many...
March 21st, 2010 05:12 AM
by Duane Hookom Go to last post
3 272
syntax for Week number by Revned
Hi, Can anyone help me how figure out a correct syntax for week no. I have tblRev with fieldname:Date I want access automatically display the week no....
March 21st, 2010 04:54 AM
by Revned Go to last post
3 187
Days in part of the month by Leo
If I have a date ('VisitDate')then if I need to know how many days in that particular month from that given date, the following VBA code...
March 21st, 2010 01:13 AM
by fredg Go to last post
1 193
Fields in a query by sjcowden
I am trying to create a query but when I run it I get the message - query too complex. Am I limited to the number of fields I can incorporate into a query or...
March 20th, 2010 08:38 PM
by Duane Hookom Go to last post
4 216
Help with a partial match query by Whirled.Peas
I asked this question here many, many years ago and have since forgotten the answer. I have a table with address data in it, spread over several fields. One...
March 20th, 2010 08:32 PM
by John Spencer Go to last post
6 199
ODBC errors? by Zoomiest
I have a webserver hosted in my basement running a MySQL database. I am using ODBC to connect to it, and run queries with MS Access. I have done this for...
March 20th, 2010 03:09 PM
by Zoomiest Go to last post
4 192
SQL Select Query Prompting for NonExistent Parameter by David[_62_]
I'm using Access 97. I've entered the following SQL Query into the Query Tab. =================== SELECT * FROM tblVehicles WHERE fldVehicleTag =...
March 20th, 2010 02:30 PM
by David[_62_] Go to last post
8 361
E_lookup by Santosh
E-Lookup
March 20th, 2010 05:44 AM
by John W. Vinson Go to last post
1 224
IIF and formatting by Huber57
I hope someone can help! I am running MS Access 2003. I have two Expressions built in a query that look like this: Expr5: IIf(0,,"TBD") Expr2:...
March 19th, 2010 11:42 PM
by John W. Vinson Go to last post
9 316
Converting a Date by FC
I have a column with dates in the format mm/dd/yyyy. I would like to have an additional column the will give me only the month and another only the year, all...
March 19th, 2010 11:34 PM
by Jeff Boyce Go to last post
2 177
Best 5 bids by JulieFlynt
I have a dB that has two main tables not associated with a relationship. Table One is baseline info from previous year with information about each line item...
March 19th, 2010 11:30 PM
by Jeff Boyce Go to last post
3 135
Query to unnormalize some data by Joseph Greenberg
I have a the table with fields , , . It is normalized. I want to select out = 1 or 2 (easy enough), and create two new variables and , so each record has...
March 19th, 2010 09:10 PM
by Joseph Greenberg Go to last post
4 195
Excluding a day of the week (for only a short period of time) by gillah11
I have the following critera built for a field in one of my Access queries. 1DaySurvivalCX: Sum(IIf( ( In...
March 19th, 2010 07:21 PM
by gillah11 Go to last post
3 178
Post New Thread


Display Options
Showing threads 801 to 820 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:49 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.