I have created a database using Access 2007 but it really confuses me. I used to have Access 2000 and it was really easy to create a query which found all...

Table is Communion fldCommunionID autonumber fldCommunionDate date fldCommunicant number relaated to tblSouls fldSoulID I would like a query to...

Is there any way to change the default when you switch between text and notes so the automatic choice is endnotes, rather than footnotes?

I have a simple query (where the tables are of external database) that lists all customers and their transaction dates. How can I modify the query to get only...

Hi I wonder whether someone may be able to help me please. I am trying to create a query that shows updated fields within a given time period. I have set up...

Hi, I have three feilds: SERVER, TYPE, ERROR I would like to simply add a new record (three feilds mentioned above) to a table using VBA (when a user clicks...

I have a query that sums all wages for all employees by year that I use in a subreport. This is a sample of the results I'd like to have on my report. Year ...

I have inherited a database where someone in their infinite wisdom asked staff to put four key fields into a memo field and separate them with a line...

Hi all, I have created a form , in that command button is created when clicked it will open another form. but i need when button is clicked a input box...

Hi, i have a form with a textbox. I want to enter a word in that text box and when i press enter key a message box should be displayed what characters i have...

Hi, My company has various contracts that contain pricing matrixes. Some of these matrixes have escalating cost structures based on a specific time period....

I am a new Access user and am trying to query the correct rate for the right currency on a specific date. My tables are as follows: tblRecDetails ...

I have a form set up for data entry with a subform linking child records in a different table. In the case where a user closes the form halfway through...

hello gurus This isn't a question as much as it is a beginner's comment on BETWEEN...AND. As it seems to be used, BETWEEN...AND gives results that are...

1. how do I code to prompt just to enter one date? 2. Once this date is entered how do I code it to subract 20 days from that date entered. 3.Next, I have...

Hello Access 2007 Google Groupmeisters, need your help and support on this one.... My Table: Field1 Field2 Field3 Field4 MPIID MPIID 07499750...

I'd love some advise on what direction to go with this... Two tables from two different systems. Basically customer data. All fields are named different but...

Hi, Can anyone help me with this? As you can see below, I have class schedules, which lists days and times but it repeats each time for each day, which are...

I have created a table with data types yes/no. I am trying to create a query that ONLY shows when the user has selected yes. I am trying to create a report...

Below are 2 tables/queries: one is the source the other is the desired result. I scoured the newsgroups and my access books - seems like queries with...