Perhaps the most widely distributed desktop database program in the world, Microsoft® Access is a standard in office information management. Whether you are new to Access or upgrading from a previous release, this course takes you step-by-step through your mastery of Access 2007. Learn to create, manage, and distribute databases, complete with input forms and advanced reporting.
Duration : 0:2:52
Im using this query for a range of IP numbers in a database, I was able to use it but, the result or the query is inaccurate
>= and <= will work with numbers, but if you’re IP addresses are stored in the traditional format (15.23.61.211 for example), Access won’t know what to do with them.
Try creating a new field, and entering this formula:
IP2: Replace([IP],".","")
Now, use >= and <= on this field, and see if that gives you the results you want. It most likely will not, unless you use the format 15.023.061.123 instead of 15.23.61.123.
Greetings,
Let me explain myself:
For example, I cant use CASE sentences on a MS Access 97 query… I’d like to know which are available and which are not, to be sure its Access’ fault and not a sintaxis error..
Access 97 supports only limited SQL queries. Most of these can be generated with the query designer functionality in Access, but if you want to access the database using more advance SQL commands, try writing a VB program to do it and use an OLEDB jet connection. Then you get whatever functionatily you want on it.
Good luck!
The issues is I have to excel spread sheets with serial numbers connected to data in rows. However some of the data when being output to a report repeats itself with identical rows. What do i write in the criteria for that column so that it only puts out each serial number once? PLEASE HELP ME
The issues is I have to excel spread sheets with serial numbers connected to data in rows. However some of the data when being output to a report repeats itself with identical rows. What do i write in the criteria for that column so that it only puts out each serial number once? PLEASE HELP ME
Note: Tables are linked to excel files
serial numbers are only repeated in one excel file out of two.
Note that something like this:
ID, Name, Gender
4, Bob, M
4, Jane, F
is ok with the ID repeated. I’m assuming you’re talking about this:
ID, Name, Gender
4, Bob, M
4, Bob, M
Try using GROUP BY in one of the field names.
This Microsoft Access Training Class video by Nicola explains how to design a Select Query. A query is a way to find exact information in your database. For Access computer training classes in Chicago Illinois and New York, NYC visit www.CTStraining.com/Access
Duration : 0:4:18
I have an MS Access query that runs in about 2 seconds and returns 82 records. When I try to create a basic report based on that query I run into problems. There are no pictures, etc in the report–it’s simply displaying the query results. However, that report takes about 20 minutes to run and completely freezes Access while running.
Another odd thing is that I have a nearly identical query and it’s report runs without any delay. The only difference between the query/report combo that works and the one that doesn’t is one field in the queries. Both are date fields, but they’re just stored on different tables.
Any ideas? I can’t figure this out! Thanks in advance for any help!
2 seconds to retuns 82 records it’s too slow.
anyway, have you open two query in the same time?
i mean, one for your ‘view form’ and one for your report ?
if that so, try to send your query to the report without open the ‘view form’, or close your ‘view form’ first before you make a report.
Even this is not a problem for most of database system, but it always worth to try.
some advice to increase speed query :
- Never use lookup table , use query join instead.
- Avoid to fetch all your records.
- Try not to open the table if you didn’t need it.
- Avoid record count, use ‘count’ query instead.
Using QBE builder to provide SQL and sticking it into VBA in order to run a delete query
Duration : 0:6:23
I’m working on an Access db with some very simple queries, but they pull a lot of data. Once I have the query the way I want it, I close and save it, and it’s like it reruns it. This typically happens with my subqueries. Is there a way to bypass whatever is executing?
No some subqueries run when access is examining the structure of main query. Sometimes its fast when the query can return beginning rows quickly, but when it has group by or sorts it generally takes a while.
Best option is to write the query in SQL view–but that requires experience. the other option is to put limits on the sub queries. where PrimaryKey=’whatever’. one the design is right, remove that restriction from the subqueries.
Also, make sure any group by, sort, or joined field has an index in the original table
I get the sinking feeling that my request is beyond the scope of what Access can do, but hopefully someone can tell me definitively.
I have just set up a payroll database to calculate weekly earnings. One pay category is "Mileage reimbursement." If an employee goes on the road, we reimburse them money for their travel. We have come to two agreements: 1. miles will be paid City to City and NOT door to door (so we don’t have to worry about addresses), 2. miles will be based on those found in Microsoft Streets & Trips.
Is there any way to query MS Streets & Trips for mileage within an access form? Can I have a "START" text box and a "END" text box, and use a command button to search MS Streets for the mileage between these two cities?
Thank you.
>> Is there any way to query MS Streets & Trips for mileage within an access form?
The short answer is Yes. The long answer is it requires you to have a fairly firm grasp of Visual Basic For Applications (VBA) and a copy of Streets & Trips on the computer running the Access database.
>> Can I have a "START" text box and a "END" text box, and use a command button to search MS Streets for the mileage between these two cities?
Yes. Again, this requires fairly advanced understanding of VBA.
Updating records in Access using update queries