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
Date Str into Date (Urgent) by Trever B
Hi, Have imported a file as text and have a field call From_Date and has come in as text as 38833 what function do I use in access to change it to an access...
February 21st, 2007 07:41 AM
by fredg Go to last post
2 306
DB read only - Access 2007 by ACCESS2007
Why is my new database read only after closing it for the first time? I cannot find any settings which show default of read only? Thank you.
February 21st, 2007 07:24 AM
by John W. Vinson Go to last post
1 292
Lookup values from another table by nubee
Hi! I want to create a query that will lookup the value from another table. my first table contains the amount(field) and the other table contains...
February 21st, 2007 06:16 AM
by Marshall Barton Go to last post
2 248
只**新年..全新 PSP $998,PS3, Wii.公價7折 by Dorris
全部有保養,電62893103 特價Game,$50起
February 21st, 2007 05:09 AM
by Dorris Go to last post
0 309
Problem nesting one SQL in another by cinnie
hello to all This is a general question about nesting one SQL in another. The example is just made up to help me understand. Start with 2 queries called...
February 21st, 2007 03:33 AM
by cinnie Go to last post
2 241
Query output limiting field length - Access 2007 by ACCESS2007
Below is Access SQL for review... SELECT PublishingDetailsHistory.AgreementID, PublishingDetailsHistory.SubjectMatter FROM PublishingDetailsHistory WHERE...
February 21st, 2007 03:05 AM
by ACCESS2007 Go to last post
3 251
Comparing two tables for missing columns by Princy
Hello, I am more accustomed to Oracle.... am still thinking in terms of Oracle... Please help me with this issue. I am trying to compare two tables A and...
February 21st, 2007 02:34 AM
by Jerry Whittle Go to last post
1 263
Using ODBC Connection Query Error: Non-Updatable Query by rmcompute
A query was running using a linked table to an Access database. The query linked an access table from the current database and uptated that table with data...
February 21st, 2007 12:02 AM
by rmcompute Go to last post
4 312
Subtract Now() - 6 months by Tony Ramirez
Help please. Would like to take Expr2: Now() - Value Value would be 6 for six months. Like the result written in regular Date Time. Thanks, Tony
February 20th, 2007 11:17 PM
by John W. Vinson Go to last post
2 264
data query by Spring
I have one form I am using for users to update info for their records. since the record is large, so the users want that Form can prompt an indicator where to...
February 20th, 2007 10:46 PM
by Carl Rapson Go to last post
1 233
linking by waynr89
ok. I have 3 tables in a MS Access database. They were imported from a text file. Anyway. Table A has field 1 in common with field 1 in Table B. So they need...
February 20th, 2007 10:23 PM
by waynr89 Go to last post
0 229
Ranking performance is slow by [email protected]
I have successfully created a ranking subQuery, but the performance is atrocious. Even after completing the query, scrolling through the results causes it to...
February 20th, 2007 08:09 PM
by [email protected] Go to last post
8 331
Query...Expression by [email protected]
Hello, I run a few reports based on queries that have expressions, that enable me to enter the data that should be displayed in that field. I usually only...
February 20th, 2007 07:31 PM
by [email protected] Go to last post
2 215
Error msg when convertint a select query in to an update query by Steve S
I am trying to update a field in a table with the first corresponding value in a small (3-4 records) subset of records. Before the...
February 20th, 2007 06:28 PM
by Steve S Go to last post
2 234
Merging related records when there are multiple one-to-one relationships between two tables by Marc Eckhert
I am having trouble finding the right query to merge related records into a single query when there are multiple one-to-one relationships between two...
February 20th, 2007 06:08 PM
by Jeff Boyce Go to last post
3 257
Pivot Table 'Metadata' by S.Clark [Access MVP]
When a pivot table is setup (add column & row headers, set data), the values appear to get saved 'behind the scenes' such that when the query is again opened...
February 20th, 2007 03:52 PM
by S.Clark [Access MVP] Go to last post
0 354
Tables with Lookup queries by JoHickey
I have a library table. When entering the data for the County, I want it to lookup from the County table and have a list to choose from. That works just...
February 20th, 2007 03:47 PM
by JoHickey Go to last post
3 206
Right Joins by Welthey
I have the following query which I have used before with the same joins, but it is not populating the validation question like I need it to do. Can someone...
February 20th, 2007 02:48 PM
by Welthey Go to last post
4 226
searching for similar records by Maax
Hello all, my database lists parts that have the following fields (amongst others), BOM TIME PRICE CABLES CUSTOMER PARTNUMBER
(Multi-page thread 1 2)
February 20th, 2007 01:38 PM
by Maax Go to last post
11 359
Add a running sum column in a query by [email protected]
I am having trouble adding a column in a query which is a running total of my records. Example: Table 1 Column 1 has a data in each row as 1, 2, 3, 4,...
February 20th, 2007 01:33 PM
by John Spencer Go to last post
1 143
Post New Thread

Display Options
Showing threads 20001 to 20020 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 04:21 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.