I need a way to transferspreadsheet may main table "Account" and my details table "Accountsubform" by date to a floppy disk. I know how to do this,...

I am importing data. In the first record it contains data in field 1 & 2. The next several rows only has data in field 2. I need to have the data in field 1,...

When using Get External Data Link Tables, and then choosing an MS-Excel workbook, I have no possibilities to define the data type of the individual fields....

I have a query linked to a form wher the person can select criteria and the result is repesented as a report. All works fine. The problem is how do I add a...

I have a form based on a query... I was able to enter info into the form and then I changed some of this and now I can't. Form set to can edit etc. Thought I...

Hello. I'd like to know how to make this run faster when it uses only dates. I'm open for any database field format changes, coding changes or query...

Hello! Why doesn´t the pivot table show cents when this is the fact in the underlying data sheet? The amount in the data sheet is 73640,75 SEK and this is...

Is it possible to use the column name, which is a pivot of the first column in the underlying table, in a calculation? Essentially, I want to create a matrix,...

I am making an app more user friendly. Rather than have the user enter multiple parameters, many times, I placed text boxes on the form and use these to...

Hi all, I have a database that I created which contained all the objects, including the tabels. I then split the tables out into a back end database and...

Combining two records into one. Any help on if this is possible would be greatly appreciated. I am pulling data similar to what is below. Record1: John...

Hi. I have a snippet of sql that I'm trying to modify. Here's my example: John Doe and Susie Anderson are spouses. I've been listing their names...

Hi i'm trying to create a query that calculates the age of a person. (in many of the cases the person is dead). I have a date of birth in one field and a date...

When entering parameter criteria referencing value of form control (ex: Forms!!) in QBE grid, Access adds brackets to the expression, which results in syntax...

Please help. I've created a query which is pulling data from 11 tables. The query is not updatable. I've spent hours reading other postings ...

They are alll stored in three seprate tables.. in case someone misunderstood and thought those were all the fields in a single table.

I am building a report that needs two display two specific numbers taht are added up. these numbers ar both assiciated to the assigned account id. I am having...

Thanks for reading my post. I have a need to to build a checkbook register so that I can track a department budget. I have accomplished the portion that adds...

Post your SQL statement. Open the query in design view. Click on menu VIEW - SQL View. Highlight, copy and paste in post. "H0MELY" wrote: Greetings, I...

Hi All, I run a query on a 'tblCandidates' table linked to two other tables 'tblCandidateIndustries' and 'tblCandidatePositions' each of which may have many...