Recent content by Pharaoh

Hi, I have a table with a list of items and dates. Each item can have multiple dates which are displayed as a second entry with a matching item number. I would like to make a query to display the dates on a single line (next to the item number) much like a crosstab query would display. The...

Hi, Thanks for that i had a go and it has got me further than before. Is there a way to show each date for the item as opposed to a max and min?

I had a look and i wanted to show the Item as a Row heading and the Date as the colum heading but i need a value. So then i tried Item as row heading, location as colum heading and date as value but it wouldn't run as i need to make the value field either sum or count. Any other ideas?

Hi, I have a table with 3 fields: Item, Date, Location Each Item can have multiple locations and dates. I would like to display the data in such a way that for each row, it shows the item in column 1 and the dates associated with that item in each of the following columns. Please could...

Ah yes thanks for that, i will amend it.

Hi, That worked perfectly! Thank you so much for your help ^.^

Hi, I made a module as you advised above and got it into SQL View: SELECT GetTimeSlot([time]) AS [Time Periods], IIf([Till Number]="72" Or [Till Number]="73","Putney Library",IIf([Till Number]="77" Or [Till Number]="78","Tooting Library",IIf([Till Number]="74" Or [Till...

Hi, I tried re-creating it from scratch a couple of times. It won't let me view the SQL view and i am greeted with this message: Syntax error (missing operator) I looked over the IIF statements as that was the ones it seems to think are incorrect but they look ok to me and since they work...

Hi, I have written a query using 3 tables all joined by similar properties. I run the query and get my results. However, if i alter any of the selected fields, it corrupts the query and the one of my expressions goes haywire. If then quit without saving and go back into it it's fine and...

Hi, I am trying to write a query to show how many Permits are active on each day of a financial year. In my table I have Permit ID & Expiry Date fields. I am looking to have a list of days of the year with a count of how many permits were still active on that day. Any help with writing a...

Ah thank you both. Got it working now. Regards Pharaoh

Hi, I am trying to produce a query to show the last time a customer bought and item and how many they bought. The fields I am using are a date field a "customer number" field and a "volume bought" field. The problem is that I do not know how to set the query to only show the last batch...

Hi Brian, Ah yes, thanks. So because the field is set to group by it won't show multiple records if only one field is showing. Thanks again. Regards Pharaoh

Hi, I have a bit of a problem with using the count option. Basically, i have a table with multiple fields. I pull down a date field, a user initials field, and an item number field. I use the date field to select on the dates I want to report on and set the total to "where". I put in the...

At present, the computer program we use stores data and changes to data in seperate files according to area of work. We download extracts from the server where the data is stored. The downloads are divided up into sections according to area of work (as they are stored). From there we use...