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
Database Feedback by lettyg
Good Morning. I just completed a database, I dont know how I pulled it off but it looks like I did with a reference book I read. Is anyone willing to take...
December 18th, 2009 05:29 PM
by lettyg Go to last post
6 241
Combo Box for Column Heading by Devon
Hello I am attempting to automate the process of importing data from a spreadsheet, then cleaning up the data on the spreadsheet. The spreadsheet I am...
December 18th, 2009 04:36 PM
by Devon Go to last post
2 192
Export To Excel by Pam
Hi, I have the following for a command button on a form that opens when a report is selected. I have a user who can't get this to work. There is no error...
December 18th, 2009 03:31 PM
by Pam Go to last post
4 238
How to append query w/lookup fields.... by Krystal Peters
I have a table that I need to append w/new records on a weekly basis. format of original info: UserName TimeStamp RequestType #OfRequests...
December 18th, 2009 03:24 PM
by John Spencer Go to last post
2 195
Open Query Design View or Saving Extremely SLOW by dbarmer
Access 2007. Often I create a query based on several tables, and have to split up the work of the queries into subsequent queries so that the evaluation is...
December 18th, 2009 02:40 PM
by Jerry Whittle Go to last post
2 285
moving averages by cliff
I have the following data and I would like to calculate moving average for 3 years to know overall impact on food price year price ...
December 18th, 2009 06:31 AM
by KARL DEWEY Go to last post
1 211
how do I create supervisor hierarchy with the access table by Helen Shah
I am trying to create a supervisor roll up table with the employee data information. My table currently has employee id, employee name, supervisor id and...
December 18th, 2009 12:33 AM
by Gina Whipp Go to last post
2 281
Parameter Criteria from a forms Text box - 2003 - not working by Billp
Hi, I take a start date and an end date from a forms two text boxes. If the query is run without the criteria all is well. Between !! And !! Adding the...
December 17th, 2009 11:31 PM
by Billp Go to last post
5 256
Query formatting problem by Dhulker
I have a MS access database that keeps track of road segments for my work. The road segments are stored in a table (along with another table that stores...
December 17th, 2009 09:11 PM
by Jerry Whittle Go to last post
4 162
Soft Carriage Return by Scott
I have a Word document that gets address data from a query in a database. If the query has a hard return , the address does not line up properly in the Word...
December 17th, 2009 07:29 PM
by Marshall Barton Go to last post
6 188
Table Link by Ranjith Kurian[_2_]
When i link the excel file in Tables objects using Link Table wizard, in one of the step the wizard ask 'Choose the delimiter that separates your fields'...
December 17th, 2009 04:50 PM
by Jerry Whittle Go to last post
2 177
duplicate records by Jean-Paul
Hi, I have a table containing about 3500 records All have a field named "volgnummer" Records with the same "volgnummer" should be deleted except for one of...
December 17th, 2009 01:59 PM
by John Spencer Go to last post
1 173
problem with query in ASP using date() by sravanthi
Hi. Hi, I am novice to ASP,I am using vb script and MSacceess for database.When ever I use the following code it gives the error.I am sure the problem is with...
December 17th, 2009 01:53 PM
by John Spencer Go to last post
1 157
And Or in a Parameter Query by NEWER USER
How do you make use of AND or OR in a Parameter Query? Entering one value works fine, but using and/or retrieves an empty string. Any ideas?
December 17th, 2009 01:42 PM
by John Spencer Go to last post
4 174
Tranform Pivot Query? by tsluu
I hv 2 tables with structure as below: ID Name 1 Mr A 2 Mr B 3 Mr C 4 Mr D 5 Mr E
December 17th, 2009 01:22 PM
by John Spencer Go to last post
3 173
Combine the Table and Insert a value by Ranjith Kurian[_2_]
I tried the below query using 23 tables, i got a error "Duplicate output alias File_Date, could you please advise me. SELECT Mon., Mon.Amount, "weekMon" AS...
December 17th, 2009 12:28 PM
by RonaldoOneNil Go to last post
1 165
Need to update records in a table based upon records in another ta by Iram
Hello, I am using access 2003. I have a table called tbl_Master which contains fields such as DeviceSN, Name, SlateForRetirement?, Flag1, Address and City....
December 17th, 2009 01:25 AM
by Iram Go to last post
2 155
My query doesn't pick up records added to the table after a parti. by Fran the Confused
My query does not pick up any records added to the table after 10/9/07 but there is no reason for this in the query itself. Also it does not pick up records...
December 17th, 2009 01:10 AM
by KARL DEWEY Go to last post
2 227
How do I add numbers across columns of a single record? by jennyls
I have a column that lists items. I then have three columns next that list the number of items in each storage location. I would like to create a query that...
December 17th, 2009 12:43 AM
by Clifford Bass[_2_] Go to last post
2 168
How to use IsError()? by Phil Smith
I have a spreadsheet that I will be importing on a regular basis. This is formatted for human consumption, with multiple header rows, etc. Fortunately, I...
December 16th, 2009 09:33 PM
by John Spencer Go to last post
1 217
Post New Thread


Display Options
Showing threads 1901 to 1920 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:21 PM.


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