I have a residential database and in the query, I want to sort by who is the resident of the unit, instead of displaying if it is the owner or tenant of the...

Hi folks - I'm trying to insert a row into an Access table using the following: INSERT INTO Files (FileID, FileName, FilePath, FileType, FileSize, DiskID)...

I am handling the bookings for a tennis court. Each member is allowed to book up to 3 courts in any 7 day period BUT NO MORE THAN THAT! The maximum period...

My query returns a group of 5 projects: Local Region1 Region2 Region3 International Is there a way to change Local so that it shows in the query as Region 1. ...

Hi, How do I do a date restrictor for the past calander year on a rolling basis? I am running a weekly report and want to get sales for the past year and...

Does anyone know how to limit total figures for a crosstab, either in at the query stage or within the report? Basically, I only want my crosstab query to...

I've posted before but I think I need to be more explicit. I have a book database. It includes a book table which lists all the titles, an author table with...

Hello Folks, about the performance(speed) of a query, does it make difference if I define my field type as string or integer. Thanks.

Thanks to all who replied to my question 'Using Min & Max in combined SQL statements' yesterday. I went with PC Datasheet's solution and it worked a treat....

How would I find the second to last event per person in a table that has dates, events and names. In other words I'm trying to group by name, and instead of...

Hi, 1. I know it is possible to store a VB function and call it in SQL if that function is stored in the MS ACCESS database. Is it possible to call that...

Access XP in Windows 2000 I have a query that runs a report based on combo box results. I am using the Like IIF statement to set the criteria. If I leave...

i have a subform on my main form. the subform has an underlying query attached to it. i made a button on the main form which displays data on the subform. the...

Hi all, On a form, I have a name combo box (Name1) and access names from a query. I would like to also import with those names, their organization as listed...

I'm trying to build an Access form to select some Crews for an Area from a list of Crews belonging to a Branch. Table layout is shown below. I'm hoping to...

I am trying to make a crosstab query that will have a row heading of the salesperson initials and the column headings will be monday through sunday. for the...

HI all, I have a table called transaction, with theses columns; Inv_Nr, Cash, CC, Chq. Where the payment for the invoice is put under the appropriate...

dEAR SIR I bought pckect pc recently, and every time i try to sync with my PC through ms outlook i get this massage(your microsoft exchange server is...

I have a little quetion. I know how to make a query based on another query. But if i write the first query in Vba, how i can write the second quey always in...

I'm trying to duplicate Excel's Autofilter functionality. In Excel, for every column's autofilter criteria you choose, the more the records are filtered. ...