Search results

Problem is that Like "Software.SA.*" returns no results. Using the work around about gives me the results I want but as you say it only caters for SAP...not anything else which starts with SA I wonder why Like "Software.SA.*" doesnt work???

Thanks mate, thats worked brilliantly

Brilliant thanks for that. Like "A.A*" worked a treat. Like "A.A.*?*" did not return any results. The problem i have now is that it is returning other values that i dont want: I get Software.SA.x (which is what I am after) Softarw.SAP.x (which i do not want!) How do I get it to exclude...

Hi all, I have a question regarding using "Like" within a query on access. I use access to query our call logging system and produce reports. Within the call logging system I have a field called "Request area". In request area there are loads of options you can select. I am trying to run a...

Sorry typo, try the link again. Cheers... Phil

Ive posted the link because the picture didnt seem to work

http://i38.photobucket.com/albums/e111/Benson112/Changegraph.jpg

Hi there, I need to create a graph containing monthly data for numbers of changes raised. It needs to display the total amount of changes raised split into priority per month like this: Do i need multiple queries for each month? How do I collate them all together to create the graph...

Thanks for your help mate, ive managed to do what I wanted now. I found a table that had the group names in that i wanted so i managed to get the query to run from the selection.

Thanks for your reply namliam....however I am still completely lost. Not your fault in the slightest its me, im a complete novice with access and dont know what any of that means! lol Id rather do it the "better way" soooo... Ill give you a brief overview of what I am trying to do. I have 10...

When you create the combo box it gives you the two options doesnt it, "I was to lookup the values in a table or query" or "I want to type in the values myself" (or something along those lines) Because I dont havea table or query to lookup the values from, I typed them in myself. Now im stuck...

Hi there, I want to create a drop down box on my form with a list of reports to run however I am struggling!!! I have managed to create the drop down list (combo box thingy) which I have entered the names of the reports as items on the drop down but I am struggling to get access to run the...

Hi All, I was wondering if it is possible to display my access 2000 DB on our intranet site or a website of any description? If so what would I have to do? Also, would there be any issues with multiple people running the reports at the same time? At the minute if somebody else is in the DB, i...

I managed to do it, there was an onption in properties to unblock the file

When i try to open this i get the follownig error message: Microsoft Access cannot open this file. This file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. To open the file, copy it to your machine or an...

Yeah they are definately date fields Its just strange how if i put in the actual datse i.e. Between #01/01/2008# And #31/01/2008# it works fine, but if i use the promts it doesnt?

Thanks for that Bob ill check it out now, Does anybody have any clue why im getting the strange results? Access is querying an Oracle database if that makes any difference. Ive tried using american date formate but still get random results

Sorry I only just read this, input forms sounds a little out of my league mate, i wouldnt know where to start!

It doesnt work! When i type in: Between #01/01/2008# And #31/01/2008# I get the results that i want, i.e Incidents between those two dates. When i type in: Between [Enter Start Date] And [Enter End Date] I get the pop up boxes, i enter my dates, and it returns results from: 01/01/2008...

Thanks all!!