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
Updateable Query Problem by Cathy
I have a table with an autonum primary key. I'm unable to create a key using several fields because two of the fields which should be part of the key can be...
April 27th, 2010 05:37 PM
by John W. Vinson Go to last post
9 379
sum weekly data into monthly by drunkle
I want to sum weekly data into monthly data by SKU. I have two tables. the first looks like...
April 27th, 2010 05:09 PM
by Jeff Boyce Go to last post
1 219
Query ask for parameter value? by SF[_5_]
Hi, I biult a query from another one. When I run the query, Access keep ask the value of M and F. When I click OK I get the result that I want. Is there a...
April 27th, 2010 06:32 AM
by John W. Vinson Go to last post
2 290
Calender to switch to the month by Leo
Hi, I posted the following more than 24 hrs ago. I know all the Microsoft MVPs are volunteers. I am willing to wait for few more days. But in the event that...
April 27th, 2010 05:17 AM
by PieterLinden via AccessMonster.com Go to last post
1 234
#num! by joemeshuggah
is there a way to get around this?? i have an access database that is set up with a link to a text file that is created via teradata sql assistant. this...
April 27th, 2010 03:33 AM
by John W. Vinson Go to last post
5 205
Update query question by Silvio
Hello, I would like to update a record by looking at the value from a form combo box column(1). I have tried Forms!!.column(1) but it does not work. The bond...
April 27th, 2010 02:33 AM
by Silvio Go to last post
3 189
Help with expression for Qtr by AccessKay
I’m not very good yet with writing expressions. How would I convert this expression to get the quarter? Month_1: Sum(IIf( Between (!!) And...
April 27th, 2010 02:23 AM
by John W. Vinson Go to last post
4 235
Remove zero totals in query by AccessKay
I’m trying to find out how I can fix my query so that it doesn’t have records with zero values. Karl Dewey helped me with a clever way to create a query...
April 26th, 2010 09:19 PM
by AccessKay Go to last post
4 231
populating a query by Victoria
hi I think this is a beginner's question, but I'm missing something. Lets say I have a table: empID(pk) Max_ACount 123 5 136 ...
April 26th, 2010 08:50 PM
by Victoria Go to last post
2 198
Parameter Query with DSum by e133
I have a query which calculates a groups % of the total. I am using a Dsum to calculate the % but when I introduce a date parameter i get the error message...
April 26th, 2010 08:36 PM
by e133 Go to last post
2 346
sumif function in Access query, possible? by Cam
Hello, I have a query I am trying to calculate the sum of qty if OprStatus equal 1, but there is no sumif function in Access. What can I do to work around...
April 26th, 2010 08:07 PM
by Daryl S[_2_] Go to last post
3 243
Filtering a Crosstab Query from Combo Boxes on Unbound Form by slprescott via AccessMonster.com
Hello Everyone, I have a crosstab query in my database that I would like to filter based upon user selections from combo boxes on an unbound form. I would...
April 26th, 2010 07:56 PM
by slprescott via AccessMonster.com Go to last post
9 327
Ranking in Access Query by Dates by TinaP
I have db that holds tables that record employee production numbers. It has all the associates, what jobprocesses they did and what date they did them, along...
April 26th, 2010 06:23 PM
by vanderghast Go to last post
1 163
How do I prevent values from been multiplied by two or three? by legacy
Hi, I created a query to add values from two different tables. However, some of the results are been multiplied by two and some of them by three. Is there...
April 26th, 2010 06:21 PM
by Bob Barrows Go to last post
4 167
IIF update query by H0MELY
Greetings, thank you for looking at my question. Here is my situation. Everyday a user receives a feed (table) of devices that have had a change in the...
April 26th, 2010 05:59 PM
by KenSheridan via AccessMonster.com Go to last post
1 164
How to make a query sort randomly each time it is run? by Rascaltoo
I have a webpage that runs a query. Presently I have the top 15 entries always at the top, and any others beneath them. I need to rotate the 15 on top as...
April 26th, 2010 05:41 PM
by John W. Vinson Go to last post
3 179
Search for current date in a text field by mrlewis52
I have a SQL database that I have an external data link to an access database. I need to search records based on the current date. The problem is that the...
April 26th, 2010 05:38 PM
by mrlewis52 Go to last post
9 323
Append queries - Column Headers by Jessica
I have a database that someone else built, and I am building reports for. They want a graph put on a report and the table is set up with multiple columns...
April 26th, 2010 05:20 PM
by Jessica Go to last post
2 187
crosstab for day of week by klp via AccessMonster.com
I have a crosstab query that puts the day of week but I would like it to put each day, Monday thru Friday even if there is no data. How do I...
April 26th, 2010 05:19 PM
by klp via AccessMonster.com Go to last post
2 261
Query to see what percentage of people scored a specific number by John
I am fairly new to access and have created a great database. However the queries are now becomming more complicated than I expected. I have two fields (Goal...
April 26th, 2010 05:10 PM
by KenSheridan via AccessMonster.com Go to last post
2 182
Post New Thread


Display Options
Showing threads 381 to 400 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 09:37 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.