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
How can i create a query on text input to return closest match? by Vanita
I would like to create a text based parameter which will return the closest match? e.g Drink is the search citeria, the search will look for the word drink in...
March 17th, 2008 01:16 PM
by John Spencer Go to last post
1 108
No dates in 1st 5 records of excel spreadsheet by ragtopcaddy via AccessMonster.com
I understand that when linking to an Excel spreadsheet, Access determines from the 1st few records, what datatype to make the field. I have a date field whose...
March 17th, 2008 01:14 PM
by ragtopcaddy via AccessMonster.com Go to last post
4 145
Crosstab/Transform with an join by Richard[_19_]
I got an crosstab query that shows all stores based with how many items a store bought based on a where artikel id = 'ddds' If an store didnt bought any of...
March 17th, 2008 08:34 AM
by Richard[_19_] Go to last post
4 134
bigest date in the date field by Faisal
How to find Bigest date in a date field for a query. As i use max() function in date field it give any error message:Cannot have aggregate function in WHERE...
March 17th, 2008 06:52 AM
by John W. Vinson Go to last post
1 101
Linked Tables - adding field and getting overflow error by IrishRed
Hello All, Any suggestions would be greatly appreciated. This problem has been bothering me for a week now. I have a make table query which takes data from...
March 17th, 2008 04:13 AM
by Allen Browne Go to last post
1 146
Multiple Yes/No fields + IIF by Opal[_2_]
I am working in Access 2003 and trying to figure out a query from my table that contains multiple Yes/No fields. The user can select Yes or No for up to five...
March 17th, 2008 02:49 AM
by Opal[_2_] Go to last post
2 169
Access shutting down when accessing saved query by LisaDW
Hi! This is my first time here and everyone appears helpful, so I'm hoping someone will know the answer to my question. I have a series of 12 Select queries...
March 17th, 2008 02:20 AM
by Allen Browne Go to last post
1 129
Simple update Query by [email protected]
Hi, I'm sure I've done this in the past but can't figure how. I have 2 tables "A" and "B" both with the following fields Town; Council I want to update Table...
March 17th, 2008 01:48 AM
by John Spencer Go to last post
1 95
searching records that use a range for Values by blueman
I am trying to figure out the best way to set up tables that have value ranges. This is to be used for entering Plant Information. Heights,etc are typically...
March 17th, 2008 01:43 AM
by Allen Browne Go to last post
3 203
HELP! Adding multiple combo boxes from different tables by iain9996
Hi, please help me! i am making a database for my own restaurant. To make it easier for my staff, i am creating a database which allows the users to input...
March 16th, 2008 10:28 PM
by John W. Vinson Go to last post
3 102
If statement help by DM[_4_]
Hello, What is everyone's favorite source for learning how to build if statements and/or source of if statements. I am old to the term but new practical use...
March 16th, 2008 07:08 PM
by DM[_4_] Go to last post
0 69
Missing 512 records in a query by Marty Wolf
I was setting up a query that had been troublesome so I was pulling each element of the query separately to locate which of 5 related tables was causing the...
March 16th, 2008 03:33 PM
by Rick Brandt Go to last post
1 81
Column aliases use literal not alias in Group By by NickB
This query creates two columns with aliases and a literal as the value. It works fine in Access but falls over when using a table linked to SQL Server...
March 16th, 2008 11:12 AM
by NickB Go to last post
2 95
Graphing Periodic Data by kb3fed
I have a database that is used to track total cost for projects. So, my highest (hierarchial) table is the list of projects, the next table contains the...
March 16th, 2008 10:26 AM
by Gary Walter Go to last post
2 68
pivot table data v detail by DianneZ
I would love to know the difference between the data area and the detail area in a pivot table in Access 2003. Excel doesn't have both of these fields and I...
March 16th, 2008 05:04 AM
by DianneZ Go to last post
0 131
Running diferent query with one command by Charles via AccessMonster.com
I would like to run queries with just one botton and a date dispalyed in a form. If Sunday March 09, 2008, is dispalyed I would like to click on a button...
March 16th, 2008 04:30 AM
by quinto via AccessMonster.com Go to last post
8 158
Change value of checkbox at runtime (using VBA) by febad
Hello, I will like to change the value of a check box at runtime. I have a database with a field "multiple_print_select", which stores a value of "1" when it...
March 15th, 2008 10:25 PM
by Rick Brandt Go to last post
1 126
including door numbers in an address matching query criteria? by efandango
I have a query for an address list from two seperate query/tables which have this kind of setup: Table: Field: Data: Main St, W1 11 Main St, W1
March 15th, 2008 09:52 PM
by efandango Go to last post
0 99
Unmatched Query by Richardb
I have a query that I am trying to find out who did not submit a report during a particular time period. The unmatched works for all if I do not have the...
(Multi-page thread 1 2 3)
March 15th, 2008 04:20 PM
by Richardb Go to last post
22 296
running total by DD
i need to have a running total in a query. example date item qty needed onhand available 03/18/08 1 500 ...
March 15th, 2008 02:44 PM
by Allen Browne Go to last post
1 84
Post New Thread


Display Options
Showing threads 12101 to 12120 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 08:02 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.