Search results

Hi I'm having trouble casting a string into a long as a pointer. I would then like to dereference back into a string. Any help would be greatly appreciated. Paul

Hi again! I am trying to sort records on a couple of fields which are Start Date and End Date. The user selects a month and a year using 2 combo boxes (see previous post), and I would like an expression which will do the following: Show only records where The end date is in the month and year...

Hi I have a form with 2 combo boxes on to select the month and year for the criteria of a query. The date has been formatted using Format([Last day],"mmm/yy"), and the first combo box has the month in, and the second the year eg. JAN 02. Can anyone help me with the expression I need to...

Hi I am trying to sort out some records into the last year to date. I have been trying Between (DateAdd("d",-365,Date())) And (Date()) but this wont work. Any ideas? My next step is to consolidate the information from the last year which will include a number of entries with the same name, a...

Hi I am trying to get a query to call a combo box for it's criteria, but I can't seem to get it to work! Any ideas? I have a database with a load of records and I want to select only records for a specific person. I have it working with [Type Surname] but would like a list of all surnames to...

Hi I am trying to write a sickness record database to make my life easier, but it only seems to be causing me lots of headaches! I would like to run a Query which displays sickness records for a specific month. I have a 'First Day of Sickness' field which I would like to use in the criteria...