I currently have an Excel document with Access as database for the data in Excel (Excel is basically just a report. I didn't want to create a report in...

I have a personal info table. it contains fields such as name,birthdate and their hobbies. there are 4 hobby fields in the table and they are...

My task is to take a set of date ranges, determine how many days are included in each span, and total them up for each client. The trick is, there may be...

i am using Microsoft XP with the Word program. I am having a problem keeping the text where I place it. I am writing a book but I cannot publish it because...

Hi. I currently have a table in which each record is based on a particular attendance event (students attend a language lab at my university). In each...

Hi! In query I have Like in cod column. I would like to be able to choose two or three Cod. Thanks in advance. an

I have this big query that basically serves my entire project. I realize that may be bad, but it's not a huge project by any means and it's not a huge...

Every week I import an Excel spreadsheet into my database, into a particular table "SalesData 2006". This table at present has 758329 record, with 5 fields...

Access 2000. I have an expression in my query that 99% of the time will give me the correct result, that is rounds up or down correctly. For example, I am...

OK, he're's the dilemma. I have two lists of files I've imported. One has the file names/paths in long format that contains the path, name, size, last...

I have a table that contain personal information of a number of peoples and the table have a birthdate field which contain data of the date of birth and the...

I've got two tables. I need to see all the records in table1 and some fields from table2 based on conditions. My primary join field (field1) could give me...

Hi everyone! Using A02 on XP. I need to calculate the period of time between DateSold and TermDate in my query. I currently have: Age: DateDiff("d",,) and...

I have a database that contains design control criteria. The criteria can be applicable to 4 separate engineering disciplines by level of responsibility -...

I have a query that correctly returns 149 rows. I immediately run it again and get 148 rows. About 2/3 of the time, one row is missing - but its different row...

As part of a Delete Query: I'm trying to find a nifty way to compare a date field in one table to a date field in another table + 45 days. Like: date1 =...

I am creating a schedule database based on the Monday date of each week. I have a table that has each monday date as one of the fields and then another...

I have a column with data similar to: Percentage 24.70% 15.80% 0.00% 3.20% 100.00% I am trying to "hide" the data if the value in "PERCENTAGE" is equal to

Hello All, I inherited a database from a former employee and am trying to locate any query that contains a particular field name. Is there a way within...

Hi, How can i set up Microsoft Access 2003 to automatically back up my database?