[ms_access] Query
Good afternoon, I'm needing to perform the following query. I have the birthday registered in the field in the table DAT_NAS PEOPLE. This consultation will bring the birthdays on the last 15 days before and 15 days later. For example: Today is 04/08/2010. The consultation will bring me the birthdays of 21/07/2010 to 19/08/2010, ie all the birthdays of between 21/07/2010 and 19/08/2010. Can anyone help me since I am not able to create this query. Thank you. Sérgio Gurgel http://www.sergiogurgel.eti.br | twitter @sergiogurgel | skype sergio_gurgel | gtalk sergio.gur...@gmail.com | msn ser...@sergiogurgel.eti.br [Non-text portions of this message have been removed]
Re: [ms_access] Query criteria by upper of lower case
Lonnie, The way I do this in code is to use 'Ucase' to force the string into uppercase when checking against the same string in upper case: If Ucase(Mystring) = ACTUALS then [do something] Alternativeley you could convert all user input into upper case when first entered. In Access the data tables and forms can be set to force input into Upper case. Neil Ives On 11 July 2010 23:51, Lonnie Johnson prode...@yahoo.com wrote: Just curious, Is there a way to search or match a string that is just upper case or mixed case? I have a filed that has these two values and the customer actually wants to be able search for just one of the two. The two values are... 2010 ACTUALS 2010 Actuals [Non-text portions of this message have been removed] Yahoo! Groups Links -- Neil Ives
Re: [ms_access] Query criteria by upper of lower case
Thanks for responding Neil. That is generally how I would handle it too. But this customer actually wants the two versions and wants to separate them in the query. For some reason the one with the caps and the one with the lower case is actually a different value to them. So they need to know how many of each they have. From: Neil Ives neil.i...@gmail.com To: ms_access@yahoogroups.com Sent: Mon, July 12, 2010 4:45:30 AM Subject: Re: [ms_access] Query criteria by upper of lower case Lonnie, The way I do this in code is to use 'Ucase' to force the string into uppercase when checking against the same string in upper case: If Ucase(Mystring) = ACTUALS then [do something] Alternativeley you could convert all user input into upper case when first entered. In Access the data tables and forms can be set to force input into Upper case. Neil Ives On 11 July 2010 23:51, Lonnie Johnson prode...@yahoo.com wrote: Just curious, Is there a way to search or match a string that is just upper case or mixed case? I have a filed that has these two values and the customer actually wants to be able search for just one of the two. The two values are... 2010 ACTUALS 2010 Actuals [Non-text portions of this message have been removed] Yahoo! Groups Links -- Neil Ives [Non-text portions of this message have been removed]
[ms_access] Query criteria by upper of lower case
Just curious, Is there a way to search or match a string that is just upper case or mixed case? I have a filed that has these two values and the customer actually wants to be able search for just one of the two. The two values are... 2010 ACTUALS 2010 Actuals [Non-text portions of this message have been removed]
RE: [ms_access] Query won't show all results
Brad This may sound silly or I have missed a posting ..But, is it possible that you have spaces in the empty fields??? This will appear to your sql as a field that is NOT empty. you may have to try and run a trim function on the field this will remove any empty spaces cheers John Y At 09:21 AM 29/09/2009, you wrote: run the query with a *x* around the criteria.. see if you get all the records No. I am trying to create a query to eliminate blank fields in a column. There are close to 14,000 entries, 6070 are blank (when using a filter). When I set IS NOT NULL as the criteria, it only hides 4514, leaving 1556 blank fields still visible. Likewise, if I use IS NULL it only shows 4514 of the blank fields. I've checked some of the fields and they really are empty, even the ones that don't work. It's really more of an annoyance as I can always just use the filter whenever I need to eliminate the blanks. This is in Access 2007, I don't know if it was the same in older versions. Brad [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [ms_access] Query won't show all results
But, is it possible that you have spaces in the empty fields??? This will appear to your sql as a field that is NOT empty. Wouldn't that also be the case when filtering for an empty field? I checked several of the fields and they are empty, plus I can't imagine how it would happen over 1500 times. Some of the data may have been cut and pasted from an Excel file, but that applies to the ones that are working as well. When I run a filter in the IS NOT NULL query on the blank fields for Does NOT equal blank, it hides all the rest of the blank fields. I'll have to double check for spaces and such tomorrow, it's getting late here. Brad [Non-text portions of this message have been removed]
Re: [ms_access] Query won't show all results
My data is sound (I've spot-checked) , it's just that the query stops at a certain point. Why? How do I fix? I have the same problem. Brad [Non-text portions of this message have been removed]
[ms_access] Query won't show all results
Using Access 2007, I have a large table with about 15k entries. I have a simple query to pull out a certain membership type based on a text field, but the query only displays up to about 700 entries when I know there should be almost 1200. My data is sound (I've spot-checked), it's just that the query stops at a certain point. Why? How do I fix?
[ms_access] Query duplicating request for input
I use Access 2007 to manage a transportation program at a Senior Center. I'm not a big user of SQL, but have used Access enough that I usually can figure out how to do fairly straight-forward things. The main table in my database is a table that has all of the rides in it. One of the things I frequently need to do is query this table for all of the requested rides for a given date. I have the query request the date for input, which starts out working like I want it to. After some random period of time, the query suddenly starts asking for the date twice! It's not a big deal, but it's annoying. The only way I've been able to get it back to normal is to re-construct the query. Then it's fine for a while, but eventually starts asking for the date twice again. In case it might be helpful, here's the SQL for the query: SELECT Tbl_Rides.Pickupdate, Tbl_Rides.Rider, Tbl_Rides.Pickupadd, Tbl_Rides.Pickuptime, Tbl_Rides.Appttime, Tbl_Rides.Destination, Tbl_Rides.Destphone, Tbl_Rides.Status, Tbl_Rides.Notified, Tbl_Rides.Driver, Tbl_Rides.Notes, Tbl_Rides.Notestome FROM Tbl_Rides WHERE ((Tbl_Rides.Pickupdate)=[What date?]) ORDER BY Tbl_Rides.Pickuptime; Any ideas? Or is this just a Microsoft feature that I'll have to live with? Barbara Mann Transportation coordinator Yellow Springs Senior Center Yellow Springs, OH
Re: [ms_access] query help
Look at MS Access help at the cross tab query. This may be what you are looking for. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Developmentnbsp;of MS Access Databases Visit me at ==gt; http://www.prodev.us nbsp; --- On Sat, 6/14/08, Muhamed Faisal lt;[EMAIL PROTECTED]gt; wrote: From: Muhamed Faisal lt;[EMAIL PROTECTED]gt; Subject: [ms_access] query help To: ms_access@yahoogroups.com Date: Saturday, June 14, 2008, 9:09 PM DEARS I have a query having filed namenbsp; factories in text data type and resultnbsp;of query like follows Plant A Plant B Plant C Plant D Now form above query i want to make a new query which result is Plant A amp; Plant B amp; Plant C amp; Plant D How it is possible Hoping Any tips regards Faisal Riyadh [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[ms_access] query help
DEARS I have a query having filed name factories in text data type and result of query like follows Plant A Plant B Plant C Plant D Now form above query i want to make a new query which result is Plant A Plant B Plant C Plant D How it is possible Hoping Any tips regards Faisal Riyadh [Non-text portions of this message have been removed]
[ms_access] Query limits records I can see--now what?
I have two tables: One contains all the fields I need to create a report, except that I'm using an ID number for employees that are listed under 5 fields (A1, A2, A3, A4, A5). The other table is my list of employees and their ID numbers. When I want to create a report, I want the name of the employee to show up in place of the ID number, so I created a query for each of the A fields. For instance qryA1 includes both of the above tables, but the ID number from the employee table is linked to the A1 field in the main table. When I look at the query as a table, it shows me the ID number and the person's name for all of the records that have an entry in the A1 field. The same thing happens with A2, etc. Then I created another query that contains the main table and all of the A queries. That is when I discoverd that it will only show me records where everything is equal. In other words, I must have (for instance) 4 employees in each of the A fields for at least two records in order to see anything. I know there must be a way to do this so I can see all of the records, including the ones where there is only an employee listed in A1, while the next record lists an employee in A1, A2, etc. I'm not sure this is very clear, but I'm trying! Thank you, Anne
[ms_access] Query to only display the most current entry
Hello all, My name is Jesse and I am new to the list. I'm putting together an access database to help a friend of mine with his growing lawn maintenance business. The requirement I'm stuck on is that I need to have it figure out who needs to be mowed based on the terms of their service (how long between mowings) and the current date. I've got that much but it displays every record that exceeds the threshold set in their terms of service. So if I have 2 entries for a customer and the newest means they are over the limit it still displays output for the older entry as well. I'm not sure where I need to work this into my query. As you can probably tell I'm fairly new to access as well. Ask me whatever other questions you need and I'll do my best to get you the info you need to help me. Thank you so much for your time and assistance. Jesse
[ms_access] Query Request - DISTINCT equalivant
With SQL Server I can use the query below to get a list of unique ranges. SELECT DISTINCT LEFT(IPAddress, LEN(IPAddress) - CHARINDEX('.',REVERSE(IPAddress))) Exp001 FROM Addresses In Access the closest I have been able to come to to strip the hosts octet off. Whilst DISTINCT shows in the online help, I get a syntax error every time I try to use it. Access version so far, needs the DISTINCT portion to be complete SELECT left(ipaddress,len(ipaddress)-instrrec(ipaddress,.) Exp001 FROM Drips;
Re: [ms_access] query design
You are suppose to have two records if there are two or more unique records. But, if the fields from the child table (income) that you put onto your grid have the exact same data then you can set the Unique Values property to Yes for the query and you will only see one child record with the expense record. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Muhamed Faisal [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Monday, December 31, 2007 11:45:47 PM Subject: Re: [ms_access] query design dear sir i have tried on that way already if we join on that way it is not working because if we have 2 datas in expense query and only one data in income query then the final query dublicating one value for income query this is my problem pls help to solve this regrds faisal riyadh - Original Message From: Lonnie Johnson [EMAIL PROTECTED] com To: [EMAIL PROTECTED] ps.com Sent: Monday, December 31, 2007 10:35:59 PM Subject: Re: [ms_access] query design I looked at your database and the query you had. You need to join the two tables by the field custmer. In the design view of the query click down on the field name in the table object in the expense table and drag it over to the same field name in the income table and let go. There should be a line between the two tables. For more information look up joins in the help section. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev. us - Original Message From: Muhamed Faisal muhamed_faisal2000 @ yahoo.com To: [EMAIL PROTECTED] ps.com; [EMAIL PROTECTED] com Sent: Monday, December 31, 2007 6:29:17 AM Subject: Re: [ms_access] query design dear sir pls see my sample database which have two table names expense and income now i want to get a new query in which i expect datas from two tables like customer name,expense value,expense details,invoice number from expense and income value,income details,date from income but i have only one data in income and two data in expense but my query showing 4 anwers so please tell me the way of connecting two queries two get corect result+ hope you understand the problem of mine regards faisal riyadh - Original Message From: Lonnie Johnson [EMAIL PROTECTED] com To: [EMAIL PROTECTED] ps.com Sent: Monday, December 31, 2007 12:24:13 AM Subject: Re: [ms_access] query design When you say they are not identical, do you mean different data types? Can you actually give us a sample of the real data you are talking about? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev. us - Original Message From: Muhamed Faisal muhamed_faisal2000 @ yahoo.com To: [EMAIL PROTECTED] ps.com Sent: Sunday, December 30, 2007 12:12:26 AM Subject: Re: [ms_access] query design dear sir thank for your reply but in union query all of our connected qiery field should be in identical but in my cases both queries datas are not identical hope you understand my problem any tips pls regrds faisal riyadh - Original Message From: Lonnie Johnson [EMAIL PROTECTED] com To: [EMAIL PROTECTED] ps.com Sent: Saturday, December 29, 2007 3:26:06 PM Subject: Re: [ms_access] query design Look into Union Queries. The basics are such... Query1 results are... Column1 Column2 Dogs German Shepard Fruits Apples Query2 results are... Column1 Column2 Cars Chevy Homes Duplex The Union Query syntax and results would be... SELECT Column1, Column2 From Query1 UNION SELECT Column1, Column2 From Query2 Dogs German Shepard Fruits Apples Cars Chevy Homes Duplex May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev. us - Original Message From: Muhamed Faisal muhamed_faisal2000 @ yahoo.com To: [EMAIL PROTECTED] ps.com Sent: Saturday, December 29, 2007 5:41:56 AM Subject: [ms_access] query design dears, i want to design a qeury from another two query one query having 3 field another having 2 different type of filed now i want to disign a new query from this two queries.the two queries dont having any connection at all in datas for example in my firest query having two datas and my second query having two datas and if i make third query as my expectation it give 4 datas so how to connect my queries to have two datas only any help pls regards faisal riyadh - - --- Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php
Re: [ms_access] query design
dear sir pls see my sample database which have two table names expense and income now i want to get a new query in which i expect datas from two tables like customer name,expense value,expense details,invoice number from expense and income value,income details,date from income but i have only one data in income and two data in expense but my query showing 4 anwers so please tell me the way of connecting two queries two get corect result+ hope you understand the problem of mine regards faisal riyadh - Original Message From: Lonnie Johnson [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Monday, December 31, 2007 12:24:13 AM Subject: Re: [ms_access] query design When you say they are not identical, do you mean different data types? Can you actually give us a sample of the real data you are talking about? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev. us - Original Message From: Muhamed Faisal muhamed_faisal2000@ yahoo.com To: [EMAIL PROTECTED] ps.com Sent: Sunday, December 30, 2007 12:12:26 AM Subject: Re: [ms_access] query design dear sir thank for your reply but in union query all of our connected qiery field should be in identical but in my cases both queries datas are not identical hope you understand my problem any tips pls regrds faisal riyadh - Original Message From: Lonnie Johnson [EMAIL PROTECTED] com To: [EMAIL PROTECTED] ps.com Sent: Saturday, December 29, 2007 3:26:06 PM Subject: Re: [ms_access] query design Look into Union Queries. The basics are such... Query1 results are... Column1 Column2 Dogs German Shepard Fruits Apples Query2 results are... Column1 Column2 Cars Chevy Homes Duplex The Union Query syntax and results would be... SELECT Column1, Column2 From Query1 UNION SELECT Column1, Column2 From Query2 Dogs German Shepard Fruits Apples Cars Chevy Homes Duplex May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev. us - Original Message From: Muhamed Faisal muhamed_faisal2000 @ yahoo.com To: [EMAIL PROTECTED] ps.com Sent: Saturday, December 29, 2007 5:41:56 AM Subject: [ms_access] query design dears, i want to design a qeury from another two query one query having 3 field another having 2 different type of filed now i want to disign a new query from this two queries.the two queries dont having any connection at all in datas for example in my firest query having two datas and my second query having two datas and if i make third query as my expectation it give 4 datas so how to connect my queries to have two datas only any help pls regards faisal riyadh - - --- Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs [Non-text portions of this message have been removed]
Re: [ms_access] query design
I looked at your database and the query you had. You need to join the two tables by the field custmer. In the design view of the query click down on the field name in the table object in the expense table and drag it over to the same field name in the income table and let go. There should be a line between the two tables. For more information look up joins in the help section. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Muhamed Faisal [EMAIL PROTECTED] To: ms_access@yahoogroups.com; [EMAIL PROTECTED] Sent: Monday, December 31, 2007 6:29:17 AM Subject: Re: [ms_access] query design dear sir pls see my sample database which have two table names expense and income now i want to get a new query in which i expect datas from two tables like customer name,expense value,expense details,invoice number from expense and income value,income details,date from income but i have only one data in income and two data in expense but my query showing 4 anwers so please tell me the way of connecting two queries two get corect result+ hope you understand the problem of mine regards faisal riyadh - Original Message From: Lonnie Johnson [EMAIL PROTECTED] com To: [EMAIL PROTECTED] ps.com Sent: Monday, December 31, 2007 12:24:13 AM Subject: Re: [ms_access] query design When you say they are not identical, do you mean different data types? Can you actually give us a sample of the real data you are talking about? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev. us - Original Message From: Muhamed Faisal muhamed_faisal2000 @ yahoo.com To: [EMAIL PROTECTED] ps.com Sent: Sunday, December 30, 2007 12:12:26 AM Subject: Re: [ms_access] query design dear sir thank for your reply but in union query all of our connected qiery field should be in identical but in my cases both queries datas are not identical hope you understand my problem any tips pls regrds faisal riyadh - Original Message From: Lonnie Johnson [EMAIL PROTECTED] com To: [EMAIL PROTECTED] ps.com Sent: Saturday, December 29, 2007 3:26:06 PM Subject: Re: [ms_access] query design Look into Union Queries. The basics are such... Query1 results are... Column1 Column2 Dogs German Shepard Fruits Apples Query2 results are... Column1 Column2 Cars Chevy Homes Duplex The Union Query syntax and results would be... SELECT Column1, Column2 From Query1 UNION SELECT Column1, Column2 From Query2 Dogs German Shepard Fruits Apples Cars Chevy Homes Duplex May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev. us - Original Message From: Muhamed Faisal muhamed_faisal2000 @ yahoo.com To: [EMAIL PROTECTED] ps.com Sent: Saturday, December 29, 2007 5:41:56 AM Subject: [ms_access] query design dears, i want to design a qeury from another two query one query having 3 field another having 2 different type of filed now i want to disign a new query from this two queries.the two queries dont having any connection at all in datas for example in my firest query having two datas and my second query having two datas and if i make third query as my expectation it give 4 datas so how to connect my queries to have two datas only any help pls regards faisal riyadh - - --- Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] _ _ _ _ _ _ Never miss a thing. Make Yahoo your home page. http://www.yahoo. com/r/hs [Non-text portions of this message have been removed] Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed]
Re: [ms_access] query design
dear sir i have tried on that way already if we join on that way it is not working because if we have 2 datas in expense query and only one data in income query then the final query dublicating one value for income query this is my problem pls help to solve this regrds faisal riyadh - Original Message From: Lonnie Johnson [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Monday, December 31, 2007 10:35:59 PM Subject: Re: [ms_access] query design I looked at your database and the query you had. You need to join the two tables by the field custmer. In the design view of the query click down on the field name in the table object in the expense table and drag it over to the same field name in the income table and let go. There should be a line between the two tables. For more information look up joins in the help section. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev. us - Original Message From: Muhamed Faisal muhamed_faisal2000@ yahoo.com To: [EMAIL PROTECTED] ps.com; [EMAIL PROTECTED] com Sent: Monday, December 31, 2007 6:29:17 AM Subject: Re: [ms_access] query design dear sir pls see my sample database which have two table names expense and income now i want to get a new query in which i expect datas from two tables like customer name,expense value,expense details,invoice number from expense and income value,income details,date from income but i have only one data in income and two data in expense but my query showing 4 anwers so please tell me the way of connecting two queries two get corect result+ hope you understand the problem of mine regards faisal riyadh - Original Message From: Lonnie Johnson [EMAIL PROTECTED] com To: [EMAIL PROTECTED] ps.com Sent: Monday, December 31, 2007 12:24:13 AM Subject: Re: [ms_access] query design When you say they are not identical, do you mean different data types? Can you actually give us a sample of the real data you are talking about? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev. us - Original Message From: Muhamed Faisal muhamed_faisal2000 @ yahoo.com To: [EMAIL PROTECTED] ps.com Sent: Sunday, December 30, 2007 12:12:26 AM Subject: Re: [ms_access] query design dear sir thank for your reply but in union query all of our connected qiery field should be in identical but in my cases both queries datas are not identical hope you understand my problem any tips pls regrds faisal riyadh - Original Message From: Lonnie Johnson [EMAIL PROTECTED] com To: [EMAIL PROTECTED] ps.com Sent: Saturday, December 29, 2007 3:26:06 PM Subject: Re: [ms_access] query design Look into Union Queries. The basics are such... Query1 results are... Column1 Column2 Dogs German Shepard Fruits Apples Query2 results are... Column1 Column2 Cars Chevy Homes Duplex The Union Query syntax and results would be... SELECT Column1, Column2 From Query1 UNION SELECT Column1, Column2 From Query2 Dogs German Shepard Fruits Apples Cars Chevy Homes Duplex May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev. us - Original Message From: Muhamed Faisal muhamed_faisal2000 @ yahoo.com To: [EMAIL PROTECTED] ps.com Sent: Saturday, December 29, 2007 5:41:56 AM Subject: [ms_access] query design dears, i want to design a qeury from another two query one query having 3 field another having 2 different type of filed now i want to disign a new query from this two queries.the two queries dont having any connection at all in datas for example in my firest query having two datas and my second query having two datas and if i make third query as my expectation it give 4 datas so how to connect my queries to have two datas only any help pls regards faisal riyadh - - --- Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed
Re: [ms_access] query design
When you say they are not identical, do you mean different data types? Can you actually give us a sample of the real data you are talking about? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Muhamed Faisal [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Sunday, December 30, 2007 12:12:26 AM Subject: Re: [ms_access] query design dear sir thank for your reply but in union query all of our connected qiery field should be in identical but in my cases both queries datas are not identical hope you understand my problem any tips pls regrds faisal riyadh - Original Message From: Lonnie Johnson [EMAIL PROTECTED] com To: [EMAIL PROTECTED] ps.com Sent: Saturday, December 29, 2007 3:26:06 PM Subject: Re: [ms_access] query design Look into Union Queries. The basics are such... Query1 results are... Column1 Column2 Dogs German Shepard Fruits Apples Query2 results are... Column1 Column2 Cars Chevy Homes Duplex The Union Query syntax and results would be... SELECT Column1, Column2 From Query1 UNION SELECT Column1, Column2 From Query2 Dogs German Shepard Fruits Apples Cars Chevy Homes Duplex May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev. us - Original Message From: Muhamed Faisal muhamed_faisal2000 @ yahoo.com To: [EMAIL PROTECTED] ps.com Sent: Saturday, December 29, 2007 5:41:56 AM Subject: [ms_access] query design dears, i want to design a qeury from another two query one query having 3 field another having 2 different type of filed now i want to disign a new query from this two queries.the two queries dont having any connection at all in datas for example in my firest query having two datas and my second query having two datas and if i make third query as my expectation it give 4 datas so how to connect my queries to have two datas only any help pls regards faisal riyadh - - --- Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping [Non-text portions of this message have been removed]
[ms_access] query design
dears, i want to design a qeury from another two query one query having 3 field another having 2 different type of filed now i want to disign a new query from this two queries.the two queries dont having any connection at all in datas for example in my firest query having two datas and my second query having two datas and if i make third query as my expectation it give 4 datas so how to connect my queries to have two datas only any help pls regards faisal riyadh - Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed]
Re: [ms_access] query design
Look into Union Queries. The basics are such... Query1 results are... Column1 Column2 Dogs German Shepard Fruits Apples Query2 results are... Column1 Column2 CarsChevy Homes Duplex The Union Query syntax and results would be... SELECT Column1, Column2 From Query1 UNION SELECT Column1, Column2 From Query2 Dogs German Shepard Fruits Apples CarsChevy Homes Duplex May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Muhamed Faisal [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Saturday, December 29, 2007 5:41:56 AM Subject: [ms_access] query design dears, i want to design a qeury from another two query one query having 3 field another having 2 different type of filed now i want to disign a new query from this two queries.the two queries dont having any connection at all in datas for example in my firest query having two datas and my second query having two datas and if i make third query as my expectation it give 4 datas so how to connect my queries to have two datas only any help pls regards faisal riyadh - - --- Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed] Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping [Non-text portions of this message have been removed]
Re: [ms_access] query design
dear sir thank for your reply but in union query all of our connected qiery field should be in identical but in my cases both queries datas are not identical hope you understand my problem any tips pls regrds faisal riyadh - Original Message From: Lonnie Johnson [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Saturday, December 29, 2007 3:26:06 PM Subject: Re: [ms_access] query design Look into Union Queries. The basics are such... Query1 results are... Column1 Column2 Dogs German Shepard Fruits Apples Query2 results are... Column1 Column2 Cars Chevy Homes Duplex The Union Query syntax and results would be... SELECT Column1, Column2 From Query1 UNION SELECT Column1, Column2 From Query2 Dogs German Shepard Fruits Apples Cars Chevy Homes Duplex May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev. us - Original Message From: Muhamed Faisal muhamed_faisal2000@ yahoo.com To: [EMAIL PROTECTED] ps.com Sent: Saturday, December 29, 2007 5:41:56 AM Subject: [ms_access] query design dears, i want to design a qeury from another two query one query having 3 field another having 2 different type of filed now i want to disign a new query from this two queries.the two queries dont having any connection at all in datas for example in my firest query having two datas and my second query having two datas and if i make third query as my expectation it give 4 datas so how to connect my queries to have two datas only any help pls regards faisal riyadh - - --- Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping [Non-text portions of this message have been removed]
Re: [ms_access] Query on a substring
Lookup wildcard in the help section. The jest of it is... SELECT MYFIELD FROM MYTABLE WHERE MYFIELD LIKE '*ABC*' This will return such as ABC 1ABC LAABCLA ABCSS May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Clauss Gilbert [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Friday, December 28, 2007 4:21:55 AM Subject: [ms_access] Query on a substring Is there a way, without VBA, to make a query on a text field of a table, with such an option : the field contains the substring abc, anywhere in the field ? Can the substring be used in this case ? (it seems to be easy with the usual find option in a table or from a form, but i can't find the way to do se the same in a query with SQL or with the graphic interface). Thank you Gilbert Clauss [Non-text portions of this message have been removed] Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed]
RE: [ms_access] Query on a substring
Thank you, it works perfectly (and makes the database much simpler). GC De : ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Lonnie Johnson Envoyé : vendredi 28 décembre 2007 15:19 À : ms_access@yahoogroups.com Objet : Re: [ms_access] Query on a substring Lookup wildcard in the help section. The jest of it is... SELECT MYFIELD FROM MYTABLE WHERE MYFIELD LIKE '*ABC*' This will return such as ABC 1ABC LAABCLA ABCSS May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us http://www.prodev.us - Original Message From: Clauss Gilbert [EMAIL PROTECTED] mailto:gilbert.clauss%40insee.fr To: ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com Sent: Friday, December 28, 2007 4:21:55 AM Subject: [ms_access] Query on a substring Is there a way, without VBA, to make a query on a text field of a table, with such an option : the field contains the substring abc, anywhere in the field ? Can the substring be used in this case ? (it seems to be easy with the usual find option in a table or from a form, but i can't find the way to do se the same in a query with SQL or with the graphic interface). Thank you Gilbert Clauss [Non-text portions of this message have been removed] __ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [ms_access] Query Doesn't Return all records
Need more info. What's the SQL of one of the queries, what result are you getting, and what result to you expect? To find the SQL, open the query in Design view and choose SQL View from the View menu. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of tuck1025 Sent: Monday, August 20, 2007 2:40 PM To: ms_access@yahoogroups.com Subject: [ms_access] Query Doesn't Return all records I am running some basic queries on an access database and after manually scrolling through the table I realized that some of my queries are only returning half of records it should be giving me. Any suggestions on why this might be happening? Thanks so much for any help. Yahoo! Groups Links
[ms_access] Query help needed to determine line number
I have a query that can have anywhere from 1 to 6 rows of output. I need a way to be able to know what line the each row is. Below is a rough example of the way the query output is now. At the beginning of each output line I need to have a line (row) number. How do I do this in a query? The methods I have been trying have not worked. My guess is a subquery of some kind but that is not any where near one of my strong suits. Thanks all for help. 2205,57377,ABC,23,2205,55645,95774,406,A520,38.60,CWT,29.47,CWT,1137.54 2205,57377,ABC,23,2205,55645,95774,406,G660,38.60,CWT,6.43,CWT,-248.19
[ms_access] Query For Comparison
Hi there, I have create a query for lab analysis result. The 1st column name is the Value Chloramphenicol. This column were use to key in the result get from the analysis done. The next column name Result that will showing the result of the analysis. The standard to use is when the value chloramphenicol entered = 0.300 the column Result will change to POSITIVE and when the user enterd value 0.300 (0.999) the column Result will change to NEGATIVE. I have use the expression like below: Result: IIf([Value Chloramphenicol]=0.3,POSITIVE,NEGATIVE) However some of the analysis could't detect any value and the Result column should be appear as NOT DETECT when user key in ND or 0.000 in the column Value Chloramphenicol. Another case when the certain did't do analysis sample user will entered NA and the Result column should appear NOT ANALYSE. Anyone can help me to get the expression for the above case that i can use for the query. Thanks. Iswandy Abdul Rahman [EMAIL PROTECTED]
[ms_access] Query (i think) help needed from a novice-ish user.
I need a form that will filter by category (and also be able to by Keyword, but that may be for a later post). I'm well comfortable enough doing basic table and query stuff, but this one is beyond me. Here's the skinny: I have a simple table (Movies_tbl) for my movie library. Fields are Title, Year, Synopsis and then about 20 Yes/No fields for Categories (Drama/Action/Comedy/...). I would like to have a form which has checkboxes for each category.If i wanted a Comedy-Drama, I could tick those two boxes and all matching titles get listed alphabetically. This seems like too many variables for a form, but then again, what do I know ;-) Any help or questions will be greatly appreciated. -Mo Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[ms_access] Query
How do I change this query to a half an hour or even a 15 minute increment rather than 1 hour. By Hour: Hour([MEMTime]) Group by It is taking the MEMTime field (a time field only) and grouping the number of flights during each hour. I get: 06:00 58 07:00 81 08:00 29 09:00 10 etc. What I would like is: 06:00 06:29 50 06:30 06:598 07:00 07:29 40 07:30 07:59 41 and so on.I just want to break it out by half hour for now instead of by each hour. The table just has flight departure times. Thanks! Dave This e-mail and any attachments may be confidential or legally privileged. If you receive this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. [Non-text portions of this message have been removed] Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[ms_access] Query and add authors in blank field to create two tables
I need to query a table with three columns, Authors, Songs and location; In the Author Field, it has many Author names and with 1.. to many empty data or nulls in the authors field [authors] too. Need to know how to creat two relational tables, one authors and one songs with my data. Can some one show me how ? Email me at [EMAIL PROTECTED] Thank U... example of table; Author SongsLocations Nat 'King' Cole null null null Love 62-06 null Ramblin' Rose 127-06 null This Is All I Ask 41-09 johnny cashNullNull null Burning fire 45-05 null Old Ruged cross76-06 . . . end of file Appreciate any help or Suggestion to place the authors in the null field. Thank U... Doug Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] Query Help Please
Thank you John. I had no idea you wanted the SQL from the queries. I'm sorry. Thanks again for everything If you run an update query, then the values are going to be changed in the table. I understand this. My question was: does a reference to a query in another query always cause the first query to run? Thanks again Ilona If you want to report what the value was before the update, you need to reverse your calculation: OldValue: [CurrentValue] / (1 + [PercentIncrease]) John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Saturday, May 13, 2006 12:26 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Help Please Hi John, Another question. What I want is user inputs a % value and a date I run a query (qryA) on my assest table selecting records according to this date and amongst other fields in the query I have Replacement Value off the assets table and an _expression_ that shows the result of increasing the replacement value by the % input. This is displayed in a subform for the user to see the what effect the % increase would have. I then run a COPY of this same query, except it is an update query. Up to here it all works well. I then want anothery query where qryA is joined to the assets table on AssetId so that I can report the before and after update Replacement Values, ie, the before values off qryA and the after values off the assets table, but the Replacement Values I pick up from qryA are the after update values. It seems that qryA runs again. Would this be correct, ie is my thinking right? Is there anyway of preventing it from running again and just using the data resulting from the initial run? Thank you John Ilona Adelaide, Australia [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS a.. Visit your group ms_access on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. -- [Non-text portions of this message have been removed] SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [ms_access] Query Help Please
Ilona- Yes. But why reference an Update query in a Select query? Or am I confused? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Saturday, May 13, 2006 3:50 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Help Please Thank you John. I had no idea you wanted the SQL from the queries. I'm sorry. Thanks again for everything If you run an update query, then the values are going to be changed in the table. I understand this. My question was: does a reference to a query in another query always cause the first query to run? Thanks again Ilona If you want to report what the value was before the update, you need to reverse your calculation: OldValue: [CurrentValue] / (1 + [PercentIncrease]) John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Saturday, May 13, 2006 12:26 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Help Please Hi John, Another question. What I want is user inputs a % value and a date I run a query (qryA) on my assest table selecting records according to this date and amongst other fields in the query I have Replacement Value off the assets table and an _expression_ that shows the result of increasing the replacement value by the % input. This is displayed in a subform for the user to see the what effect the % increase would have. I then run a COPY of this same query, except it is an update query. Up to here it all works well. I then want anothery query where qryA is joined to the assets table on AssetId so that I can report the before and after update Replacement Values, ie, the before values off qryA and the after values off the assets table, but the Replacement Values I pick up from qryA are the after update values. It seems that qryA runs again. Would this be correct, ie is my thinking right? Is there anyway of preventing it from running again and just using the data resulting from the initial run? Thank you John Ilona Adelaide, Australia [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS a.. Visit your group ms_access on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. -- [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[ms_access] Query Problem
Hi All, I came in this morning to a problem with one of my queries. It worked fine on Saturday, but when it tried to run last night, it produced this error: Function isn't available in expressions in query _expression_ with the remainder of the message being made up of my query parameters. Here is the SQL for my query. INSERT INTO MAX ( PRTNUM_15, TNXDTE_15, TNXTIM_15, ORDNUM_15, TNXCDE_15, STKID_15, TNXQTY_15, UDFKEY_15, REFDES_15 ) SELECT [Transaction History].PRTNUM_15, [Transaction History].TNXDTE_15, [Transaction History].TNXTIM_15, [Transaction History].ORDNUM_15, [Transaction History].TNXCDE_15, [Transaction History].STKID_15, [Transaction History].TNXQTY_15, [Transaction History].UDFKEY_15, [Transaction History].REFDES_15 FROM [Transaction History] WHERE ((([Transaction History].TNXDTE_15)=Date()-1) AND (([Transaction History].ORDNUM_15)=00) AND (([Transaction History].TNXCDE_15)=R) AND (([Transaction History].STKID_15)=FG Or ([Transaction History].STKID_15)=WIP)); This query has worked every night for the last 2 years, now all of a sudden it no longer works. As always, any help/advice is greatly appreciated! :) == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [ms_access] Query Problem
Mike- First, I would be tempted to put brackets around the table name: [MAX] -- that is a reserved word in SQL. But this sort of problem is usually related to a bad VB reference or some new code that has a compile error. Open any module in the VB Editor and choose Compile from the Debug menu. If it complains about a library being invalid, choose References from the Tools menu and fix anything that's broken. Did you recently add code or move this database to a different machine? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 7:53 AM To: ms_access@yahoogroups.com Subject: [ms_access] Query Problem Hi All, I came in this morning to a problem with one of my queries. It worked fine on Saturday, but when it tried to run last night, it produced this error: Function isn't available in expressions in query _expression_ with the remainder of the message being made up of my query parameters. Here is the SQL for my query. INSERT INTO MAX ( PRTNUM_15, TNXDTE_15, TNXTIM_15, ORDNUM_15, TNXCDE_15, STKID_15, TNXQTY_15, UDFKEY_15, REFDES_15 ) SELECT [Transaction History].PRTNUM_15, [Transaction History].TNXDTE_15, [Transaction History].TNXTIM_15, [Transaction History].ORDNUM_15, [Transaction History].TNXCDE_15, [Transaction History].STKID_15, [Transaction History].TNXQTY_15, [Transaction History].UDFKEY_15, [Transaction History].REFDES_15 FROM [Transaction History] WHERE ((([Transaction History].TNXDTE_15)=Date()-1) AND (([Transaction History].ORDNUM_15)=00) AND (([Transaction History].TNXCDE_15)=R) AND (([Transaction History].STKID_15)=FG Or ([Transaction History].STKID_15)=WIP)); This query has worked every night for the last 2 years, now all of a sudden it no longer works. As always, any help/advice is greatly appreciated! :) == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [ms_access] Query Problem
Hey John, It doesn't work on anyones machine - same error. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 8:39 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Hey John, The database doesn't have any modules. I haven't touched the design of this database in probably over a year. Can I debug in some other window other then the modules? I'm going to go try it on another machine and see what happens. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 8:21 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- First, I would be tempted to put brackets around the table name: [MAX] -- that is a reserved word in SQL. But this sort of problem is usually related to a bad VB reference or some new code that has a compile error. Open any module in the VB Editor and choose Compile from the Debug menu. If it complains about a library being invalid, choose References from the Tools menu and fix anything that's broken. Did you recently add code or move this database to a different machine? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 7:53 AM To: ms_access@yahoogroups.com Subject: [ms_access] Query Problem Hi All, I came in this morning to a problem with one of my queries. It worked fine on Saturday, but when it tried to run last night, it produced this error: Function isn't available in expressions in query _expression_ with the remainder of the message being made up of my query parameters. Here is the SQL for my query. INSERT INTO MAX ( PRTNUM_15, TNXDTE_15, TNXTIM_15, ORDNUM_15, TNXCDE_15, STKID_15, TNXQTY_15, UDFKEY_15, REFDES_15 ) SELECT [Transaction History].PRTNUM_15, [Transaction History].TNXDTE_15, [Transaction History].TNXTIM_15, [Transaction History].ORDNUM_15, [Transaction History].TNXCDE_15, [Transaction History].STKID_15, [Transaction History].TNXQTY_15, [Transaction History].UDFKEY_15, [Transaction History].REFDES_15 FROM [Transaction History] WHERE ((([Transaction History].TNXDTE_15)=Date()-1) AND (([Transaction History].ORDNUM_15)=00) AND (([Transaction History].TNXCDE_15)=R) AND (([Transaction History].STKID_15)=FG Or ([Transaction History].STKID_15)=WIP)); This query has worked every night for the last 2 years, now all of a sudden it no longer works. As always, any help/advice is greatly appreciated! :) == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [ms_access] Query Problem
OK, ran the debug and this is what turned up: MISSING: Microsoft ActiveX Plugin C:\windows\system32\plugin.ocx The database does have forms and reports, but nothing under the module tab. Thanks :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 8:58 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- Only queries and tables? No forms or reports? No code whatsoever? Humor me -- press Ctrl+G to open the VB Editor and choose Compile from the Debug menu. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 8:39 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Hey John, The database doesn't have any modules. I haven't touched the design of this database in probably over a year. Can I debug in some other window other then the modules? I'm going to go try it on another machine and see what happens. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 8:21 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- First, I would be tempted to put brackets around the table name: [MAX] -- that is a reserved word in SQL. But this sort of problem is usually related to a bad VB reference or some new code that has a compile error. Open any module in the VB Editor and choose Compile from the Debug menu. If it complains about a library being invalid, choose References from the Tools menu and fix anything that's broken. Did you recently add code or move this database to a different machine? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 7:53 AM To: ms_access@yahoogroups.com Subject: [ms_access] Query Problem Hi All, I came in this morning to a problem with one of my queries. It worked fine on Saturday, but when it tried to run last night, it produced this error: Function isn't available in expressions in query _expression_ with the remainder of the message being made up of my query parameters. Here is the SQL for my query. INSERT INTO MAX ( PRTNUM_15, TNXDTE_15, TNXTIM_15, ORDNUM_15, TNXCDE_15, STKID_15, TNXQTY_15, UDFKEY_15, REFDES_15 ) SELECT [Transaction History].PRTNUM_15, [Transaction History].TNXDTE_15, [Transaction History].TNXTIM_15, [Transaction History].ORDNUM_15, [Transaction History].TNXCDE_15, [Transaction History].STKID_15, [Transaction History].TNXQTY_15, [Transaction History].UDFKEY_15, [Transaction History].REFDES_15 FROM [Transaction History] WHERE ((([Transaction History].TNXDTE_15)=Date()-1) AND (([Transaction History].ORDNUM_15)=00) AND (([Transaction History].TNXCDE_15)=R) AND (([Transaction History].STKID_15)=FG Or ([Transaction History].STKID_15)=WIP)); This query has worked every night for the last 2 years, now all of a sudden it no longer works. As always, any help/advice is greatly appreciated! :) == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [ms_access] Query Problem
Mike- If any form or report has code, then you have modules. Uncheck that referece and try a compile. If all is well, then your problem should be solved. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 9:08 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem OK, ran the debug and this is what turned up: MISSING: Microsoft ActiveX Plugin C:\windows\system32\plugin.ocx The database does have forms and reports, but nothing under the module tab. Thanks :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 8:58 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- Only queries and tables? No forms or reports? No code whatsoever? Humor me -- press Ctrl+G to open the VB Editor and choose Compile from the Debug menu. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 8:39 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Hey John, The database doesn't have any modules. I haven't touched the design of this database in probably over a year. Can I debug in some other window other then the modules? I'm going to go try it on another machine and see what happens. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 8:21 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- First, I would be tempted to put brackets around the table name: [MAX] -- that is a reserved word in SQL. But this sort of problem is usually related to a bad VB reference or some new code that has a compile error. Open any module in the VB Editor and choose Compile from the Debug menu. If it complains about a library being invalid, choose References from the Tools menu and fix anything that's broken. Did you recently add code or move this database to a different machine? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 7:53 AM To: ms_access@yahoogroups.com Subject: [ms_access] Query Problem Hi All, I came in this morning to a problem with one of my queries. It worked fine on Saturday, but when it tried to run last night, it produced this error: Function isn't available in expressions in query _expression_ with the remainder of the message being made up of my query parameters. Here is the SQL for my query. INSERT INTO MAX ( PRTNUM_15, TNXDTE_15, TNXTIM_15, ORDNUM_15, TNXCDE_15, STKID_15, TNXQTY_15, UDFKEY_15, REFDES_15 ) SELECT [Transaction History].PRTNUM_15, [Transaction History].TNXDTE_15, [Transaction History].TNXTIM_15, [Transaction History].ORDNUM_15, [Transaction History].TNXCDE_15, [Transaction History].STKID_15, [Transaction History].TNXQTY_15, [Transaction History].UDFKEY_15, [Transaction History].REFDES_15 FROM [Transaction History] WHERE ((([Transaction History].TNXDTE_15)=Date()-1) AND (([Transaction History].ORDNUM_15)=00) AND (([Transaction History].TNXCDE_15)=R) AND (([Transaction History].STKID_15)=FG Or ([Transaction History].STKID_15)=WIP)); This query has worked every night for the last 2 years, now all of a sudden it no longer works. As always, any help/advice is greatly appreciated! :) == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software
RE: [ms_access] Query Problem
Running now! Thanks a million John. I had done a compact earlier, doesn't that recompile as part of the process? I still had the same error after doing the compact. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 9:17 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- If any form or report has code, then you have modules. Uncheck that referece and try a compile. If all is well, then your problem should be solved. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 9:08 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem OK, ran the debug and this is what turned up: MISSING: Microsoft ActiveX Plugin C:\windows\system32\plugin.ocx The database does have forms and reports, but nothing under the module tab. Thanks :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 8:58 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- Only queries and tables? No forms or reports? No code whatsoever? Humor me -- press Ctrl+G to open the VB Editor and choose Compile from the Debug menu. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 8:39 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Hey John, The database doesn't have any modules. I haven't touched the design of this database in probably over a year. Can I debug in some other window other then the modules? I'm going to go try it on another machine and see what happens. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 8:21 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- First, I would be tempted to put brackets around the table name: [MAX] -- that is a reserved word in SQL. But this sort of problem is usually related to a bad VB reference or some new code that has a compile error. Open any module in the VB Editor and choose Compile from the Debug menu. If it complains about a library being invalid, choose References from the Tools menu and fix anything that's broken. Did you recently add code or move this database to a different machine? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 7:53 AM To: ms_access@yahoogroups.com Subject: [ms_access] Query Problem Hi All, I came in this morning to a problem with one of my queries. It worked fine on Saturday, but when it tried to run last night, it produced this error: Function isn't available in expressions in query _expression_ with the remainder of the message being made up of my query parameters. Here is the SQL for my query. INSERT INTO MAX ( PRTNUM_15, TNXDTE_15, TNXTIM_15, ORDNUM_15, TNXCDE_15, STKID_15, TNXQTY_15, UDFKEY_15, REFDES_15 ) SELECT [Transaction History].PRTNUM_15, [Transaction History].TNXDTE_15, [Transaction History].TNXTIM_15, [Transaction History].ORDNUM_15, [Transaction History].TNXCDE_15, [Transaction History].STKID_15, [Transaction History].TNXQTY_15, [Transaction History].UDFKEY_15, [Transaction History].REFDES_15 FROM [Transaction History] WHERE ((([Transaction History].TNXDTE_15)=Date()-1) AND (([Transaction History].ORDNUM_15)=00) AND (([Transaction History].TNXCDE_15)=R) AND (([Transaction History].STKID_15)=FG Or ([Transaction History].STKID_15)=WIP)); This query has worked every night for the last 2 years, now all of a sudden it no longer works. As always, any help/advice is greatly appreciated! :) == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links
RE: [ms_access] Query Problem
Mike- A compact does not compile anything. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 9:22 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Running now! Thanks a million John. I had done a compact earlier, doesn't that recompile as part of the process? I still had the same error after doing the compact. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 9:17 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- If any form or report has code, then you have modules. Uncheck that referece and try a compile. If all is well, then your problem should be solved. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 9:08 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem OK, ran the debug and this is what turned up: MISSING: Microsoft ActiveX Plugin C:\windows\system32\plugin.ocx The database does have forms and reports, but nothing under the module tab. Thanks :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 8:58 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- Only queries and tables? No forms or reports? No code whatsoever? Humor me -- press Ctrl+G to open the VB Editor and choose Compile from the Debug menu. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 8:39 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Hey John, The database doesn't have any modules. I haven't touched the design of this database in probably over a year. Can I debug in some other window other then the modules? I'm going to go try it on another machine and see what happens. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 8:21 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- First, I would be tempted to put brackets around the table name: [MAX] -- that is a reserved word in SQL. But this sort of problem is usually related to a bad VB reference or some new code that has a compile error. Open any module in the VB Editor and choose Compile from the Debug menu. If it complains about a library being invalid, choose References from the Tools menu and fix anything that's broken. Did you recently add code or move this database to a different machine? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 7:53 AM To: ms_access@yahoogroups.com Subject: [ms_access] Query Problem Hi All, I came in this morning to a problem with one of my queries. It worked fine on Saturday, but when it tried to run last night, it produced this error: Function isn't available in expressions in query _expression_ with the remainder of the message being made up of my query parameters. Here is the SQL for my query. INSERT INTO MAX ( PRTNUM_15, TNXDTE_15, TNXTIM_15, ORDNUM_15, TNXCDE_15, STKID_15, TNXQTY_15, UDFKEY_15, REFDES_15 ) SELECT [Transaction History].PRTNUM_15, [Transaction History].TNXDTE_15, [Transaction History].TNXTIM_15, [Transaction History].ORDNUM_15, [Transaction History].TNXCDE_15, [Transaction History].STKID_15, [Transaction History].TNXQTY_15, [Transaction History].UDFKEY_15, [Transaction History].REFDES_15 FROM [Transaction History] WHERE ((([Transaction History].TNXDTE_15)=Date()-1) AND (([Transaction History].ORDNUM_15)=00) AND (([Transaction History].TNXCDE_15)=R
RE: [ms_access] Query Problem
OK, thanks. I'll remember that :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 9:33 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- A compact does not compile anything. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 9:22 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Running now! Thanks a million John. I had done a compact earlier, doesn't that recompile as part of the process? I still had the same error after doing the compact. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 9:17 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- If any form or report has code, then you have modules. Uncheck that referece and try a compile. If all is well, then your problem should be solved. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 9:08 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem OK, ran the debug and this is what turned up: MISSING: Microsoft ActiveX Plugin C:\windows\system32\plugin.ocx The database does have forms and reports, but nothing under the module tab. Thanks :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 8:58 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- Only queries and tables? No forms or reports? No code whatsoever? Humor me -- press Ctrl+G to open the VB Editor and choose Compile from the Debug menu. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 8:39 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Hey John, The database doesn't have any modules. I haven't touched the design of this database in probably over a year. Can I debug in some other window other then the modules? I'm going to go try it on another machine and see what happens. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, April 24, 2006 8:21 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Mike- First, I would be tempted to put brackets around the table name: [MAX] -- that is a reserved word in SQL. But this sort of problem is usually related to a bad VB reference or some new code that has a compile error. Open any module in the VB Editor and choose Compile from the Debug menu. If it complains about a library being invalid, choose References from the Tools menu and fix anything that's broken. Did you recently add code or move this database to a different machine? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 7:53 AM To: ms_access@yahoogroups.com Subject: [ms_access] Query Problem Hi All, I came in this morning to a problem with one of my queries. It worked fine on Saturday, but when it tried to run last night, it produced this error: Function isn't available in expressions in query _expression_ with the remainder of the message being made up of my query parameters. Here is the SQL for my query. INSERT INTO MAX ( PRTNUM_15, TNXDTE_15, TNXTIM_15, ORDNUM_15, TNXCDE_15, STKID_15, TNXQTY_15, UDFKEY_15, REFDES_15 ) SELECT [Transaction History].PRTNUM_15, [Transaction History].TNXDTE_15, [Transaction History].TNXTIM_15, [Transaction History].ORDNUM_15, [Transaction History].TNXCDE_15, [Transaction History].STKID_15, [Transaction
[ms_access] Query/Report From Multiple Tables
First, let me introduce myself. I am Jim, I am a programmer by trade (mainframe, dabble in a little VB.NET). I am currently working on a MS Access database for a veterans group, and it is progressing better than I had given myself credit for. I currently have 4 sub tables, such as state, and board positions the members can hold. Ive done sub forms with combo boxes so the choice can be selected. This part works very well. The sub table for board positions is an alpha field, and has of cource the key field which is an alpha number. However, when I do a query, or even a report (board members report) i only get a number where the board position is supposed to be held. You look at the main form that holds the subform and the title correctly displays. Look at the report, or the query, or even the subform in datasheet view all you get is the number where the position title should be. Its like its indexed and thats all it wants to bring foward. I have made sure all relationships are properly established as well. I would appreciate you guidance in this. This particular report is the final thing and I am done with the project, and it is most frustrating. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [ms_access] Query/Report From Multiple Tables
Jim If I understand your problem at all, in the underlying query make sure you drag the required fields from the two related tables on PositionID. I suppose the title you are looking for is in the Positions table; make sure this field is included in your query. All you have in the Members table is a Position field which links this table to the Positions table and contains the PositionID. The name or description of the position is in the Positions table. If this doesn't address your problem you may have to post a copy of your database in the Files section so that members can pick it up and see where you are going wrong. Regards Liveson - Original Message - From: Jim Margie [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Sunday, 09 April, 2006 17:23 Subject: [ms_access] Query/Report From Multiple Tables First, let me introduce myself. I am Jim, I am a programmer by trade (mainframe, dabble in a little VB.NET). I am currently working on a MS Access database for a veterans group, and it is progressing better than I had given myself credit for. I currently have 4 sub tables, such as state, and board positions the members can hold. Ive done sub forms with combo boxes so the choice can be selected. This part works very well. The sub table for board positions is an alpha field, and has of cource the key field which is an alpha number. However, when I do a query, or even a report (board members report) i only get a number where the board position is supposed to be held. You look at the main form that holds the subform and the title correctly displays. Look at the report, or the query, or even the subform in datasheet view all you get is the number where the position title should be. Its like its indexed and thats all it wants to bring foward. I have made sure all relationships are properly established as well. I would appreciate you guidance in this. This particular report is the final thing and I am done with the project, and it is most frustrating. Yahoo! Groups Links Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[ms_access] Query to prompt form
I am trying to improve on a database that I've taken over and there are queries with several if statements. The result of the if statement is intended to indicate a specific form that the end user should be opening for data entry. What I would like to do is add something into the statements that would auto-open the form. Can I build into an if statement an OpenForm expression? Thanks, Jeanette~ __ This email has been scanned by the MessageLabs Email Security System. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[ms_access] Query statement
Dear all I have a table name detail with two fields type and amt. typer is a character field and the amt is numeric field. The type field contains the type of transactions like RT OR PT and the amt field contains the value for each transaction. I am trying for a query with result to obtain total of PT minus total of RT. I have tried to use following statements in the query:- SELECT a.totrep , b.totpay, (b.totpay-a.totrep) AS Expr1 FROM [select sum(amt), totrep from detail where type='RT']. AS a, [select sum(amt), totpay from detail where type='PT']. AS b; The above query when considers totrep and totpay as a variable. Is there a way out for the above problem? Thanks in advance. Krishnadas Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[ms_access] Query Results as a Text String
Greetings, I am running a query where the results may contain one or multiple records for a given customer. The results of that query are then brought into a report. What I would like to do is list the results of the query for the individual customers as a single string separated by commas, rather than on multiple lines. Is this feasible if so how do I go about accomplishing it? Thanks! Dave Yahoo! Groups Sponsor ~-- Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/q7folB/TM ~- Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] Query problems
Bob- SELECT tblJournal.*, tblJ2.* FROM tblJournal INNER JOIN tblJournal As tblJ2 ON tblJournal.[Date] = tblJ2.[Date] AND tblJournal.[Journal Entry] = tblJ2.[Journal Entry] WHERE tblJournal.Amount = -tblJ2.Amount Use a similar technique to join the table to itself to solve your other problem. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Kate Aliesan Sent: Monday, November 21, 2005 9:29 AM To: ms_access@yahoogroups.com Subject: [ms_access] Query problems Background: I review databases which have accounting data in it. I use Access 2000. The way that accounting data works is that for each account that there is an entry for $1000, there has to be another account(S) that there is an entry for -$1000 on the same date using the entry or source. For example, on 6/04/2005, using journal entry ab200, an entry could look like : Account Amount Date Journal Entry 1090 1000 06/04/2005ab200 5222 1000 06/04/2005 ab200 I would not know the account numbers or date. The first question is how do I design a query that would tell me the accounts on a given date with the same journal entry that have the same absolute value but on is a positive and the second is a negative. The second question pertains to the same data. I want to be able to design a query that occurs on the same day between two or more accounts for opposite amounts. For example: I would want to know all journal entries that occurred on the same day inwhich there is a positive to account 5252 and a negative to account 6000 or a negative to account 6000 through 6050. Any help would be greatly appreciated Bob - Yahoo! FareChase - Search multiple travel sites in one click. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ~-- Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/u8TY5A/tzNLAA/yQLSAA/q7folB/TM ~- Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/u8TY5A/tzNLAA/yQLSAA/q7folB/TM ~- Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [ms_access] Query help
J.J. This should work : SELECT tblPeriods.Period, tblOrders.Item, Sum(tblOrders.Units) AS SumOfUnits FROM tblOrders, tblPeriods WHERE (((tblOrders.DueDate) Between [tblPeriods].[StartDate] And [tblPeriods].[EndDate])) GROUP BY tblPeriods.Period, tblOrders.Item; On 9/20/05, soccercoachjj [EMAIL PROTECTED] wrote: I need some help writing a query to group some data by a date range. I have an order table with three fields: item number, quantity, and due date. I have another table with three fields: period, start date and end date. What I'm trying to do is summarize the quantity of an item by period. As an example: If item A has orders for 100 units each with due dates of 9/22/05, 9/23/05 and 9/28/05. The period table defines period 1 as beginning 8/27/05 and ending 9/24/05, period 2 beginning 9/25/05 and ending 10/29/05. I'm trying to write a query which tells me that I have orders for 200 of item A in period 1 and 100 of item A in period 2. I'm not familiar with how to pull this information where the detail of my order records falls within a date range defined by the records in my period table. Any help would be greatly appreciated. Thanks, J.J. Yahoo! Groups Links -- Eddie [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ~-- Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM ~- Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] Query Joins
Hi John, Just a small clarificaiton. I'm able to create a make table query with union as sub query. Select * into Y from (Select * from a Union all Select * from b Union all Select * from c) But is that advised to create a table out of union query in this way or Select * from a Union all select * from b union all select * from c as q_all and in make table query Select * into y from q_all Kindly advice, KB. Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hr1uerb/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123852419/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 Fair play? Video games influencing politics. Click and talk back!/a./font ~- Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] Query Joins
. -- CHAPTER 9: In the previous chapter, we covered all the ins of JOINS - linking two or more tables or Result Sets using INNER JOIN to find all the rows that match. Now it's time to talk about the outs - linking tables and finding out not only the rows that match but also the rows that don't match. What is an OUTER JOIN? As we explained in the previous chapter, the SQL Standard defines several types of JOIN operations to link two or more tables or Result Sets. An OUTER JOIN asks your database system to return not only the rows that match on the criteria you specify but also to include unmatched rows from either one or both of the two sets you want to link. Let's suppose, for example, that you want to fetch information from the School Scheduling database about students and the classes for which they're registered. As you learned in Chapter 8, an INNER JOIN returns only students who have registered for a class and classes for which a student has registered. It won't return any students who have been accepted at the school but haven't signed up for any classes yet. It also won't return any classes that are on the schedule but for which no student has yet shown an interest. What if you want to list all students and the classes for which they are registered, if any? Conversely, suppose you wanted a list of all the classes and the students who have registered for those classes, if any. To solve this sort of problem, you need to ask for an OUTER JOIN. Figure 9-1 shows you one possible relationship between students and classes using a set diagram. As you can see, a few students haven't registered for a class yet, and a few classes do not yet have any students signed up to take the class. Figure 9-1. A possible relationship between Students and Classes. If you ask for all students and the classes for which they are registered, you'll get a Result Set that looks something like the diagram in Figure 9-2. Figure 9-2. All Students and the Classes for which they are registered. You might ask, What will I see for the students who haven't registered for any classes? Remember in Chapter 5 we introduced you to the concept of a Null or nothing value. When you ask for all students joined with any classes, your database system returns a Null value in all columns from the Classes table when it finds a student who is not yet registered for any classes.If you think about the concept of a difference between two sets that we discussed in Chapter 7, the rows with a Null value in the columns from the Classes table represent the difference between the set of all students and the set of students who have registered for a class. Likewise, if you ask for all classes and any students who registered for classes, the rows with Null values in the columns from the Students table represent the difference between the set of all classes and the set of classes for which students have registered. As we promised, using an OUTER JOIN with a test for Null values is an alternate way to discover the difference between two sets. Unlike a true EXCEPT operation that matches on entire rows from the two sets, you can specify the match in a JOIN operation on just a few specific (usually the Primary Key and Foreign Key) columns. The LEFT / RIGHT OUTER JOIN You'll most commonly use the form of an OUTER JOIN that asks for all the rows from one table or Result Set and any matching rows from a second table or Result Set. To do this, you'll specify either a LEFT OUTER JOIN or a RIGHT OUTER JOIN. What's the difference between LEFT and RIGHT? Remember from the previous chapter that to specify an INNER JOIN on two tables, you name the first table, include the JOIN keyword, and then name the second table. When you begin building queries using OUTER JOIN, the SQL Standard considers the first table you name as the one on the left, and the second table is the one on the right. So, if you want all the rows from the first table and any matching rows from the second table, you'll use a LEFT OUTER JOIN. Conversely, if you want all the rows from the second table and any matching rows from the first table, you'll specify a RIGHT OUTER JOIN. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of tgmiller5 Sent: Thursday, August 11, 2005 4:30 PM To: ms_access@yahoogroups.com Subject: [ms_access] Query Joins I am teaching a class tomorrow on Query Joins. What are some examples I can use to identify what query joins are, what is a inner join, and outer join. When would I used these and why? I really need a simple breakdown of this. Any help is appreciated.. Thank you, Tammy Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hqc111s/M=362131.6882499.7825260.1510227 /D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123803047/A=2889191/R=0/SIG=10r90krvo /*http
[ms_access] Query - Macro.!
All, I have a Very big problem. I have some 20 queries in Access and all of them called in a macro. when i run that macro, out of 20 query one query does not run, and that one query is random query, Its not the same query. Is there any way to over come this problem. Or do we have to use Debug.print Query name after every query. Kindly advice if there is any other way, Thanks and regards, Birumanand. Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hudk9fo/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123177825/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] Query - Macro.!
Don't use a macro. Run the queries from VB using the Execute method of the database object. You'll be able to trap any errors exactly in VB. Macros have no effective error-trapping mechanism. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of biruma nandan Sent: Thursday, August 04, 2005 10:50 AM To: ms_access@yahoogroups.com Subject: [ms_access] Query - Macro.! All, I have a Very big problem. I have some 20 queries in Access and all of them called in a macro. when i run that macro, out of 20 query one query does not run, and that one query is random query, Its not the same query. Is there any way to over come this problem. Or do we have to use Debug.print Query name after every query. Kindly advice if there is any other way, Thanks and regards, Birumanand. Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hudk9fo/M=362131.6882499.7 825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123177825 /A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy/a./font -- --~- Yahoo! Groups Links Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12h4iajr0/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123178726/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[ms_access] query based on username??
Hi, I was wondering if some knew how to base a queries results on the username? So if JSmith is logged in he gets locationCode=1, if BJones is logged in he gets locationcode=2, etc... Thanks In Advance Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12h9oco7h/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122928242/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOOcmpgn=GRPRTP=http://groups.yahoo.com/;In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!/a./font ~- Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ms_access] query based on username??
If you're using Access security, you can find out the ID of the current user with the CurrentUser function. If you want to use the Windows userID, Environ(USERNAME) returns it. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of eliotchs Sent: Monday, August 01, 2005 1:31 PM To: ms_access@yahoogroups.com Subject: [ms_access] query based on username?? Hi, I was wondering if some knew how to base a queries results on the username? So if JSmith is logged in he gets locationCode=1, if BJones is logged in he gets locationcode=2, etc... Thanks In Advance Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12h9oco7h/M=362335.6886445.7 839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122928242 /A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/to pics/education/digitaldivide/?source=YAHOOcmpgn=GRPRTP=http: //groups.yahoo.com/In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!/a./font -- --~- Yahoo! Groups Links Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hirqmfb/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122930702/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 Fair play? Video games influencing politics. Click and talk back!/a./font ~- Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[ms_access] Query Difficulties when unpopulated field queries against another table
I am using Access 2000 to query our system database, trying to draw the detail on a recordset from multiple tables. I have been using the design view to develop my queries. In the database, the first table contains (among other fields) Area and Unit abbreviations. Within the structure of our agency an Area may have multiple or no associated Units, and if none, the Unit field in the first table is null. A second related table contains definitions of Unit and other database specific abbreviations. Unfortunately, it does not contain a definition for the null situation.I can successfully draw the desired information from the tables when the Unit field is populated, but when the field is null my query returns no result. I am certain that my query would work if the definition for the null scenario was in the table, but I do not personally have authority to do it and this is a longer term fix. What I am looking for is assistance in putting together a work around to use in the mean time.Any assistance would be appreciated. Thanks in advance! Dave Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[ms_access] Query
Hi, I'm just starting out trying to learn MS Access. I sure it's easy when you know how! I'm trying to build an appointment database. TRYING! HOW CAN I BOOK APPOINTMENTS, EG. INSERT A PATIENT'S NAME,DATE, TIME INTO A TABLE. BUT FIRST CHECK IF THAT APPOINTMENT TIME, DATE ETC IS TAKEN OR FULL. HOW CAN THIS BE AUTOMATED? CAN THIS BE DONE WITH SQL? THE AIM IS TO BE ABLE TO SEARCH, BOOK MULTIPLE APPOINTMENTS EG. MRS SMITH ON MON AND WED AT 2PM AND 4PM, ETC. THANKS, GRAY. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/