Search results

I want to be able to produce a report with a unique ref that contains a selected number of records that is calculated between two dates and a certain field.

Hi, I created a query that takes information from a bookings table which contains bookings for artistes and dates they are performing, I have used a start date, end date and ArtisteID in the criteria which is generated via a form that I've created. This gives me an artistes dates between a...

Hiya, I am trying to build a database for an entertainments agency. I have 4 tables created. Agency Table, Act Table, Venues Table & a Bookings Table. The Agents Table as a primary key called AgencyID which is linked to a field in the Acts Table called AgencyID which is a foreign key.The venues...

Hi, Not sure if this is the best way to post I am a newbie!!:) I am trying to build a database for my entertainments agency. The problem I've been having is getting the table to pull information from each other. I have tried several ways and created tables and tried using a form..but the form as...

Hi All, my name is Mark Ellis and i'm from Ilkeston near Nottingham. I am an entertainments agent and also a solo vocalist. My hobbies are cycling,computers and listening to music (Live and at home). I have built a simple database using access before in the past but that was a long time ago to...