I'm in Access 2003 and have a table where i have match_id and player_id. I'm trying to design a query where I return the last 10 matches for a given...

I have one table with mutiple entries. The key is email address but the column site type has a different line for each type of occurrence. ...

I have wrote a query based on a form. A few of the fields I needed to show in the query I had to get from a Cross tab query. Now my form parameters are not...

I am linking to a data file, and want to automatically add a AUTONUMBER after a make table query takes the linked file and makes a new table from it. I will...

The save formatted box is grayed out and I need to change the settings from Pipe delimited to comma delimited. When it was saved as pipe delimited it changed...

I want to set the criteria for the cross tab with a value entered on a form. I do this with normal queries but the cross tab won't recognize the field from the...

I have a query that I have an expression that Concatenate's DatabaseBatch: &" "& . I have another form that looks for records based on the FullName. The...

I am using the below statement in Criteria set the criteria to ANZTransType on the form if not everything although what it is actually doing is if there is...

Hi, I have created a Select Record Access Query and have and Expression that calculates a value based on two of the table fields. This caluclation is okay...

Hello, I cannot select records of a given day: SELECT DISTINCT , COUNT() AS Y FROM WHERE (Format(, 'Short Date') = ?) GROUP BY ; Parameter value...

This should clear out everything- i hope. Pls accept my apologies for posting it many times today and the other day. I am combining everything into a single...

I have query which collects the total expenses and income per month from two tables which works fine, now I want to add a third table to collect the total...

I am a newbie and cant get my head around this problem although probably quite a simple solution. I have a database in which I enter details on a form which...

ocity ost ozip dcity dstate dzip consignee shipdate a b c d e f cat 1/2/2008 a b c d e f ...

ozip dzip consignee shipdate c f cat 1/2/2008 g f cat 1/2/2008 l t cat 1/2/2008 l1 t cat1 2/3/2008 l1 t cat1 2/3/2008 I want to delete the first two records...

In my query I want records that have todays date or greater to show. So in the criteria field i have =Date$(). I do not get todays date with...

I have a Query called which contains two fields and . I also have a table called which lists a range of building types and a minimum and maximum number of...

Not even sure how to type this but I will give it a go I have the following data. Sku Plant WHS Contact Person 12345 11 ...

It seems like an easy question, but I've been struggling for too long to simply take a .doc file and insert the text into an .asp webpage. With some help,...

I have 2 queries: Query1 SELECT (count(TradeVolume)/2) AS TotalVolume FROM HILLTOP; Query2 SELECT (sum(TradeVolume)/2) AS TotalVolume FROM HILLTOP;