I have built a database for a pilot log book. I have the table and form and the main query that gives me the totals of each column all set and working...

I have a report I am using w/ a query based on the "id" field. But I want to be able to sort on different fields. So I create a form with radio buttons...

Using Access 2000. I want to update the text in a field to include the text that's already there and add two words. field = field & " - cancelled" It...

I have a table which records the dates students received their latest karate belt. The fields are BID (Belt ID), SNAME (Student Name), PRANK (Promotion Rank)...

Hello, i was wondering how i could export queries to a new excel file. I would like to export multiple queries to one excel file (one sheet for each query). ...

In my query, I have a column that does a calculation based on two other columns thus Average: (/)*5 My problems: 1) When I run the query, if a person took no...

I have put a control box on a form that runs a query. The query is to actually select the record that is open on the form, so that I can hit another control...

Hi. I'd like to create a sql statement in a query that does this: If record1/field1 is equal to record2/field1 AND record1/field2 is equal to record2/field2...

I am trying to run a select query and in this query I have a field that is Boolean, so it shows up as -1 or 0 in the query (and on the report). Well, I would...

How do you get zeros to display on a report when the query result is a null value? I've tried the Nz function and it doesn't display anything.

This is from an Access non-expert--no sql background and little vba. Is there an equivalent Access expression to Excel's "countif" function? This could be...

From a novice Query user, I have a db with 64000 records. When I try to do a copy and paste of info from one column/field to another I get the following...

Hi togehter, I have a data table like this: ID LANG TERM 12345 DEU Haus 12345 ENG House 12345 FRA Maison 12346 ENG Sun

Thanks a lot. But, using this I'm getting extra rows. SELECT Table1.Day, Table1., Table1.Component, Table1.Qty, Table2.Qty, Table3Qty FROM (Table1 LEFT JOIN...

Andy, I wonder if you have figured out how to change query selection criteria using vb. I cannot use the form idea that Allen B. have suggested because I...

Hello, I just simply want to append a clone record. Basically, I cloned a record then modified couple of fields and then I wanted to append this...

Hi, I have a table of holidays and a date I want to be able to add 4 working days excl. holidays to the given date How can I do this? Thanks

In a crosstab query, can dates formated in months display data for more than one year. For example, when I use data from across two years it will display the...

I have a query that shows all the base discounts for a product and another query that shows a list of special discounts for a customers. What I am trying to...

I discovered that I had two entries in my Database that were already there through a query. I deleted them and now every field in those two entries (in Form...