Search results

EDIT: Question 1 is now fixed/sorted. Thank you. Moving on to my second issue. This I hope is more simple. so it is a Time delayed query to run a report returning records with a date of so many days less than todays date. I am looking at the link you provided. I have an idea of the query but...

Plog, I appreciate your paitence in the matter, and I will try to clear this up as best as possible. I don't wish to keep the data in letter1, the dates or anything, if I could I'd replace all records with data in Letter 1 as -1 and all empty records with 0, then change the field to yes/no...

Cheers, so that works.... except it is the wrong way round, the Nulls are marked as -1 (which is Yes I believe) and the Not Null is marked as 0 (which is No I believe) Now, it produces the results in a new column which isn't on my table, How do I save that column into the table? (if that makes...

Okay, So I am kind of lost. So Here is an example of the data I imported. What I want to do is change the field to a Yes/No (instead of the short text) and keep the fields that are null as no and the ones with data as yes. So what sort of query would I need to use then?

Thank you very much, Question 1 I was thinking about and I was thinking the way to do it would be have a new field for the YES/NO which then marked it as "Yes" if the original field "is not null" Thanks. I will start to investigate, to be honest I know it's a big learning curve but I have...

Hi guys, Thanks to all your help on my previous project. that has now come to the final stages and is being rolled out. Now I have another porject coming up I could use some advice on, first one I am unsure about but I need to make sure. Question 1: I will be importing data from Excel into...

Thanks, All sorted now :)

Thanks. I have that. but it only lets me sort A on top or Z on top. Is there no way to custom sort it?

Thanks guys, so the setup I have is I have a table with a field in the table called "Day" and it is a "Short text" I have a form which inputs into the field which is a Combo box and is a drop down with Monday to Friday I have a report with the following Query SELECT [Web Leads Table].Day, [Web...

Hi all, Another simple one I hope. I have a combo box which when filled in has the following in it Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday I have a report which brings back data based on these (ie how many enquries were received on each day) However when I run the...

Hi, Wow... as simple as that, I thought it would need something like "if.......... then..... True" I used "True" and it shows only true values, Perfect and simple. Thank you.

Hi, I am sure it is a simple one, but I can't work out how to hide a Record when "False" or a box is unticked on the report. I've used a Query for the report and figured it would go in the Criteria for the tick box but can't find the code I need (I am sure it is simple)

Okay, little bit more help please. I have a report which reports back with "Viewings Made" Some are NULL (or empty values) How do I remove these results? Is my current code, I assume it is a Where [fieldname] is not null ?

Okay, so I got the report between dates sorted. I am using the following. with two "date boxes" and a run button. I also have another box for a similar report which needs to filter by user ID. How can I adjust the code above so it will sort by date (like above) but also which user ID is...

Sorry, maybe I am being stupid. but "Cafeterias"? I was looking at a report and grouping it by portals, whilst it gave me a list, it didn't give me the totals.

Hi everyone. I have managed to get my access DB set up, get the data entry, searching and editing working perfectly (in forms) The next stage is extracting data from these. ie I four of the columns I have are Date Received Portal (drop down list of 3 choices) User Initial (list of 4...

Thanks, I just came back as I worked it out myself (used a different method than above) and is probably a bigger work around. but works well thanks. Just need to get reports working (never used reports before)

Okay, So I have used the Dynamically Search from this thread Dynamically search multiple fields (Sorry I can't post links) Which works perfectly. but I want to be able to edit the results I get returned. How could I do this? I have a form set up as follows. but how do I, once I select a...

Hi Guys. So I am writing a access DB for some of my staff to use (I haven't used Access in years) It is pretty straight forward and has one table with less than 20 fields. I have a data entry form set up and works nicely but I am trying to add a Search function in the header. I have...