How do I use my query to write to a table? using Access 2002. Thanks, Troy

I am just beginning with Access but have gotten accustomed to the basics really quick. I am working on a database that has 25-30 fields, many of which are...

Hi, I need some urgent help. I want to be able to delete some data in a field using a query. I know this is a popular ask on this forum, but I cannot use vb...

Hi I have a table which contains tasks with due date. If I want to find all those task that are due within the next 60 days I can put the...

Warning - I am a complete novice to VB. However, I have a situation where the Split function is really needed in a query. I copied the following from the...

I'm using the Mod function within access. My problem is that I cant get it to pick up the numbers after the decimal. For example 13 mod 10.5 should be 2.5. ...

Hi I have a table which holds the names of Managers in an organisation. Other tables then allow staff to be allocated to a manager. I have a report which...

Hi - I'm working with a table that is the product of a Make Table query. The table has a column - Credits - that is a number. When the table is created, and I...

Hi, I have two tables which has one to many relationship. The table A(primary table- one) has field named HOSPITALNAME. At second table B(Many), the...

Hi I have created an Access 2000 database which links to all the tables on a remote SQL Server 2000 database. How do I write the sql statement (or modify the...

I have an Excel SS that is essentially a form to be filled out with multiple entries. The SS is formatted in such a way (each entry in Excel covers 2 rows due...

Is there a way to add an autonumber field to a query after the query is sorting accordingly. Thanks in advance!

I have an access table (let's call it mytable), and I have a text field in this table (lets call the text field mytextfield). This field has thousands of...

Hi, I have two queries that use a user defined function called AlphaOnly. This function strips all non Alpha characters for making a Key for joining my two...

I need to split the UK postcodes in my db down to 4 types. For example, the original POSTCODE field of AB10 6YT needs to become : AB AB10 AB10 6 In the UK...

This is my first time visiting this forum, bare with me. I have searched several places as well as Access help but have not found the answer. I need to...

I need to update a field in one table as the product of two fields in another table. If I create a DSN called "test" and a linked server in SQL Server,...

Date By Week: DatePart("ww",.) in my field. I want the query to get records 10 weeks prior to today. Between Date() And DateAdd("ww",-10,Date()) in my...

How can I get the beginning and ending date to show up in the query? Between Date() And DateAdd("m",-1,Date()) Please help!

Can anyone recommend a book/manual for learning SQL. as easy to follow as possible I need it for ACCESS 2000 and don't want to spend money on a book thats...