I am running a query that displays in access as: 1.00000000154924E+18 When exported to Excel it displays as: 1000000001549240000.00 the correct number...

I want a parameter query that prompts the user with a drop-down list to enter the data, rather than the user typing a string. This way, I can limit which...

I have a table containing meter info and another table that is supposed to contain a row for each month for each meter in the main table. I need to run a...

Is it possible to take a specific column and specific row, in an access database (Access 2003), and convert that positive number into a negative...

Hi all, I'm probably doing something stupid here but here goes... I'm running some append queries...if there is no value in some of the fields I get a...

I have multiple records that can have a grand total of 100 in field a. I only want the records starting with record 1 (being the most current date) that...

hi, i would like to know whether some one can give me a criteria for a parameter query which wil fulfill the following: basically i have a form consisting of...

I'm pretty sure this can be done but I'm tripping over it. Isn't it possible to perform a StDev calculation on 2 column value of 1 row? For example: ID |...

I loaded a file with participant ssn numbers, but there are duplicates. How do I get rid of the duplicates to get a record count of pariticipants? I can do...

We have a form with a combo box and that combo box executes a query to find all of the records matching the user's name. The query derives that value from a...

We have approximately 4,500 students in tblStudents, and as you would imagine, there are numerous students with the same last name. I have a Find a Record...

Hello, Microsoft Access 2003. I would like my Main Menu form to open when a user opens my database. So far I am in no way networked or web based, I'll...

I have a database that multiple users make entries to. I have an audit table built, and it works fine in documenting the changes. I would like to automate...

I am using Access 2003 I want to create a billing statement report from a query that will give me all invoices due by a specific client, and I would like to...

Hello, Within the db I have a performance table where user input their ID, date, part#, side, startseq & stopseq daily. Then on another reference table with...

I have a table where the users are supposed to input a row each month for each account. I need some way to audit the table to make sure I have an entry for...

Is there a way to make multiple sorts work in a query. There are three fields I wish to sort on, datDate, txtCode, txtCompany. I would like to have the...

Can somebody please help me with this expression. The table is tblClassification, and the field name is "Class". The records in the table in the Class...

Hello, I have an Access Database 2000 to track performance. Within the db I have a performance table where user input their ID, date, part#, side, start...

I'm looking for an easier way of setting up a query in Access. I know how to do the following in Excel, but I don't know how to do it in Access and I am...